×
思维导图备注
Apache Doris v1.2 Documentation
首页
AI助手
白天
夜间
小程序
阅读
书签
我的书签
添加书签
移除书签
FAQ
Github
来源:Doris
浏览
495
扫码
2023-02-18 22:41:19
Install Error
Data Operation Error
SQL Error
当前内容版权归
Doris
或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问
Doris
.
上一篇:
下一篇:
版本
Apache Doris v3.0 中文文档
Apache Doris v3.0 Documentation
Apache Doris v2.1 Documentation
Apache Doris v2.1 中文文档
Apache Doris v2.0 Documentation
Apache Doris v2.0 中文文档
Apache Doris v1.2 Documentation
Apache Doris v1.2 中文文档
Apache Doris v1.1 Documentation
Apache Doris v1.1 中文文档
Apache Doris v1.0 中文文档
Apache Doris v1.0 Documentation
Apache Doris v0.15 Documentation
Apache Doris v0.15 中文文档
Apache Doris v0.14 Documentation
Apache Doris v0.14 中文文档
Apache Doris v0.13 Document
Apache Doris v0.13 中文文档
Apache Doris 0.12 Documentation
Apache Doris 0.12 中文文档
Apache Doris v0.11 Documentation
Apache Doris v0.11 中文文档
Apache Doris 文档(201812)
Getting Started
Getting-Started
Doris Introduction
Introduction to Apache Doris
Install And Deploy
Installation and Deployment
Compile
Compilation
Compiling with LDB toolchain
Compilation With Arm
Compilation on Windows
Compilation on macOS
Construct Docker
Build Docker Image
Deploy Docker cluster
Table Design
Data Model
Data Partition
Guidelines for Basic Use
Rollup and query
Best Practices
dynamie schema table
Index
inverted index
BloomFilter index
NGram BloomFilter Index
Index
Bitmap Index
Data Operation
Import
Import Overview
Import Scenes
Import local data
External storage data import
Kafka Data Subscription
Synchronize data through external table
Synchronize data using Insert method
Data import things and atomicity
Data transformation, column mapping and filtering
import strict mode
Import Way
Binlog Load
Broker Load
Routine Load
Spark Load
Stream load
S3 Load
Insert Into
Load Json Format Data
Export
Data export
Export Query Result
Use mysqldump data to export table structure or data
Update and Delete
Batch Delete
update
Delete
Sequence Column
Advanced Usage
Alter Table
Schema Change
Replace Table
Doris Partition
Dynamic Partition
Temporary partition
Data Cache
Partition Cache
Join Optimization
Bucket Shuffle Join
Colocation Join
Runtime Filter
Doris Join optimization principle
[Experimental] Pipeline execution engine
Materialized view
Broker
Best Practice
Query Analysis
Import Analysis
Debug Log
Compaction
Resource management
Orthogonal BITMAP calculation
Approximate deduplication using HLL
Variable
Time zone
File Manager
cold hot separation
Compute Node
High-concurrency point query
Lakehouse
Multi Catalog
Multi Catalog
Hive
Iceberg
Hudi
Elasticsearch
JDBC
Alibaba Cloud DLF
FAQ
External Table
Elasticsearch External Table
JDBC External Table
ODBC External Table
Hive External Table
File Analysis
File Cache
Ecosystem
Spark Doris Connector
Flink Doris Connector
DataX doriswriter
Mysql to Doris
Logstash Doris Output Plugin
Plugin Development Manual
Audit log plugin
CloudCanal Data Import
Hive Bitmap UDF
SeaTunnel
Seatunnel Connector Flink Doris
Seatunnel Connector Spark Doris
UDF
Contribute UDF
Remote User Defined Function Service
Native User Defined Function
Java UDF
UDAF
Remote User Defined Aggregation Function Service
SQL Manual
SQL Functions
Array Functions
array
array_max
array_min
array_avg
array_sum
array_size
array_remove
array_slice
array_sort
array_position
array_contains
array_except
array_product
array_intersect
array_range
array_distinct
array_difference
array_union
array_join
array_with_constant
array_enumerate
array_popback
array_compact
arrays_overlap
countequal
element_at
Date Functions
convert_tz
curdate,current_date
curtime,current_time
current_timestamp
localtime,localtimestamp
now
year
quarter
month
day
dayofyear
dayofmonth
dayofweek
week
weekday
weekofyear
yearweek
dayname
monthname
hour
minute
second
from_days
last_day
to_monday
from_unixtime
unix_timestamp
utc_timestamp
to_date
to_days
extract
makedate
str_to_date
time_round
timediff
timestampadd
timestampdiff
date_add
date_sub
date_trunc
date_format
datediff
minutes_add
minutes_diff
minutes_sub
seconds_add
seconds_diff
seconds_sub
hours_add
hours_diff
hours_sub
days_add
days_diff
days_sub
weeks_add
weeks_diff
weeks_sub
months_add
months_diff
months_sub
years_add
years_diff
years_sub
GIS Functions
ST_X
ST_Y
ST_Circle
ST_Distance_Sphere
St_Point
ST_Polygon,ST_PolyFromText,ST_PolygonFromText
ST_AsText,ST_AsWKT
ST_Contains
ST_GeometryFromText,ST_GeomFromText
ST_LineFromText,ST_LineStringFromText
String Functions
to_base64
from_base64
ascii
length
bit_length
char_length
lpad
rpad
lower
lcase
upper
ucase
initcap
repeat
reverse
concat
concat_ws
substr
substring
sub_replace
append_trailing_char_if_absent
ends_with
starts_with
trim
ltrim
rtrim
null_or_empty
not_null_or_empty
hex
unhex
elt
instr
locate
field
find_in_set
replace
left
right
strleft
strright
split_part
split_by_string
substring_index
money_format
parse_url
convert_to
extract_url_parameter
uuid
space
sleep
esquery
mask
mask_first_n
mask_last_n
multi_search_all_positions
multi_match_any
Fuzzy Match
like
not like
Regular Match
regexp
regexp_extract
regexp_extract_all
regexp_replace
regexp_replace_one
not regexp
Aggregate Functions
COLLECT_SET
MIN
STDDEV_SAMP
AVG
AVG_WEIGHTED
PERCENTILE
PERCENTILE_ARRAY
HLL_UNION_AGG
TOPN
TOPN_ARRAY
TOPN_WEIGHTED
COUNT
SUM
MAX_BY
BITMAP_UNION
group_bitmap_xor
group_bit_and
group_bit_or
group_bit_xor
PERCENTILE_APPROX
STDDEV,STDDEV_POP
GROUP_CONCAT
COLLECT_LIST
MIN_BY
MAX
ANY_VALUE
VARIANCE_SAMP,VARIANCE_SAMP
APPROX_COUNT_DISTINCT
VARIANCE,VAR_POP,VARIANCE_POP
RETENTION
SEQUENCE-MATCH
SEQUENCE-COUNT
GROUPING
GROUPING_ID
Bitmap Functions
to_bitmap
bitmap_hash
bitmap_from_string
bitmap_to_string
bitmap_to_array
bitmap_from_array
bitmap_empty
bitmap_or
bitmap_and
bitmap_union
bitmap_xor
bitmap_not
bitmap_and_not
bitmap_subset_limit
bitmap_subset_in_range
sub_bitmap
bitmap_count
bitmap_and_count
bitmap_and_not_count
orthogonal_bitmap_union_count
bitmap_xor_count
bitmap_or_count
bitmap_contains
bitmap_has_all
bitmap_has_any
bitmap_max
bitmap_min
intersect_count
bitmap_intersect
orthogonal_bitmap_intersect
orthogonal_bitmap_intersect_count
bitmap_hash64
Bitwise Functions
bitand
bitor
bitxor
bitnot
Condition Functions
case
coalesce
if
ifnull
nvl
nullif
JSON Functions
jsonb_parse
jsonb_extract
get_json_double
get_json_int
get_json_string
json_array
json_object
json_quote
Hash Functions
murmur_hash3_32
murmur_hash3_64
HLL Functions
HLL_CARDINALITY
HLL_EMPTY
HLL_HASH
Math Functions
conv
bin
sin
cos
tan
asin
acos
atan
e
Pi
exp
log
log2
ln
log10
ceil
floor
pmod
round
round_bankers
truncate
abs
sqrt
cbrt
pow
degrees
radians
sign
positive
negative
greatest
least
random
mod
Encryption Functions
AES
MD5
MD5SUM
SM4
SM3
SM3SUM
Table Functions
explode_json_array
explode
explode_split
explode_bitmap
outer combinator
numbers
explode_numbers
s3
hdfs
iceberg_meta
Analytic(Window) Functions
WINDOW-FUNCTION-LAG
WINDOW-FUNCTION-SUM
WINDOW-FUNCTION-LAST_VALUE
WINDOW-FUNCTION-AVG
WINDOW-FUNCTION-MIN
WINDOW-FUNCTION-COUNT
WINDOW-FUNCTION
WINDOW-FUNCTION-RANK
WINDOW-FUNCTION-DENSE_RANK
WINDOW-FUNCTION-MAX
WINDOW-FUNCTION-FIRST_VALUE
WINDOW-FUNCTION-LEAD
WINDOW-FUNCTION-ROW_NUMBER
WINDOW-FUNCTION-NTILE
WINDOW-FUNCTION-WINDOW-FUNNEL
CAST
DIGITAL-MASKING
width_bucket_bucket
SQL Reference
Account Management
SET-PROPERTY
REVOKE
GRANT
LDAP
CREATE-ROLE
DROP-ROLE
CREATE-USER
DROP-USER
SET-PASSWORD
ALTER-USER
Cluster management
ALTER-SYSTEM-DROP-FOLLOWER
ALTER-SYSTEM-DECOMMISSION-BACKEND
ALTER-SYSTEM-DROP-OBSERVER
CANCEL-ALTER-SYSTEM
ALTER-SYSTEM-DROP-BROKER
ALTER-SYSTEM-ADD-OBSERVER
ALTER-SYSTEM-MODIFY-BACKEND
ALTER-SYSTEM-ADD-FOLLOWER
ALTER-SYSTEM-MODIFY-BROKER
ALTER-SYSTEM-ADD-BROKER
ALTER-SYSTEM-ADD-BACKEND
ALTER-SYSTEM-DROP-BACKEND
DDL
Alter
ALTER-CATALOG
ALTER-DATABASE
ALTER-TABLE-BITMAP
ALTER-TABLE-PARTITION
ALTER-TABLE-COLUMN
ALTER-RESOURCE
CANCEL-ALTER-TABLE
ALTER-TABLE-COMMENT
ALTER-VIEW
ALTER-SQL-BLOCK-RULE
ALTER-TABLE-REPLACE
ALTER-TABLE-PROPERTY
ALTER-TABLE-ROLLUP
ALTER-TABLE-RENAME
ALTER-POLICY
Backup and Restore
RESTORE
DROP-REPOSITORY
CANCEL-RESTORE
BACKUP
CANCEL-BACKUP
CREATE-REPOSITORY
Create
CREATE-ENCRYPT-KEY
CREATE-TABLE-AS-SELECT
CREATE-POLICY
CREATE-VIEW
CREATE-DATABASE
CREATE-FILE
CREATE-INDEX
CREATE-RESOURCE
CREATE-TABLE-LIKE
CREATE-MATERIALIZED-VIEW
CREATE-EXTERNAL-TABLE
CREATE-TABLE
CREATE-SQL-BLOCK-RULE
CREATE-FUNCTION
CREATE-CATALOG
Drop
DROP-INDEX
DROP-RESOURCE
DROP-FILE
DROP-ENCRYPT-KEY
DROP-DATABASE
DROP-MATERIALIZED-VIEW
DROP-MATERIALIZED-VIEW
TRUNCATE-TABLE
DROP-TABLE
DROP-FUNCTION
DROP-DATABASE
DROP-CATALOG
DML
Load
PAUSE-ROUTINE-LOAD
MULTI-LOAD
RESUME-SYNC-JOB
CREATE-ROUTINE-LOAD
STOP-ROUTINE-LOAD
CLEAN-LABEL
ALTER-ROUTINE-LOAD
CANCEL-LOAD
RESUME-ROUTINE-LOAD
STOP-SYNC-JOB
PAUSE-SYNC-JOB
BROKER-LOAD
CREATE-SYNC-JOB
STREAM-LOAD
Manipulation
INSERT
SELECT
DELETE
UPDATE
EXPORT
CANCEL-EXPORT
OUTFILE
Database Administration
ADMIN DIAGNOSE TABLET
ADMIN-SHOW-CONFIG
KILL
ADMIN-CHECK-TABLET
ADMIN-CLEAN-TRASH
ENABLE-FEATURE
RECOVER
UNINSTALL-PLUGIN
ADMIN-SET-REPLICA-STATUS
ADMIN-SHOW-REPLICA-DISTRIBUTION
INSTALL-PLUGIN
ADMIN-REPAIR-TABLE
ADMIN-CANCEL-REPAIR
SET-VARIABLE
ADMIN-SET-CONFIG
ADMIN SHOW TABLET STORAGE FORMAT
ADMIN-SHOW-REPLICA-STATUS
ADMIN-COPY-TABLET
ADMIN-REBALANCE-DISK
ADMIN-CANCEL-REBALANCE-DISK
Show
SHOW ALTER TABLE MATERIALIZED VIEW
SHOW-ALTER
SHOW-BACKUP
SHOW-BACKENDS
SHOW-BROKER
SHOW-CATALOGS
SHOW-CREATE-TABLE
SHOW-CHARSET
SHOW-CREATE-CATALOG
SHOW-CREATE-DATABASE
SHOW-CREATE-MATERIALIZED-VIEW
SHOW-CREATE-ROUTINE-LOAD
SHOW-CREATE-FUNCTION
SHOW-COLUMNS
SHOW-COLLATION
SHOW-DATABASES
SHOW DATA SKEW
SHOW-DATABASE-ID
SHOW-DYNAMIC-PARTITION
SHOW-DELETE
SHOW-DATA
SHOW-ENGINES
SHOW-EVENTS
SHOW-EXPORT
SHOW-ENCRYPT-KEY
SHOW-FUNCTIONS
SHOW-TYPECAST
SHOW-FILE
SHOW-GRANTS
SHOW-LAST-INSERT
SHOW-LOAD-PROFILE
SHOW-LOAD-WARNINGS
SHOW-INDEX
SHOW-MIGRATIONS
SHOW-PARTITION-ID
SHOW-SNAPSHOT
SHOW-ROLLUP
SHOW-SQL-BLOCK-RULE
SHOW-ROUTINE-LOAD
SHOW-SYNC-JOB
SHOW-WHITE-LIST
SHOW-WARNING
SHOW-TABLET
SHOW-VARIABLES
SHOW-PLUGINS
SHOW-ROLES
SHOW-PROCEDURE
SHOW-ROUTINE-LOAD-TASK
SHOW-PROC
SHOW-TABLE-STATUS
SHOW-REPOSITORIES
SHOW-QUERY-PROFILE
SHOW-OPEN-TABLES
SHOW-TABLETS
SHOW-LOAD
SHOW-TABLES
SHOW-RESOURCES
SHOW-PARTITIONS
SHOW-FRONTENDS
SHOW-RESTORE
SHOW-PROPERTY
SHOW-TRIGGERS
SHOW-PROCESSLIST
SHOW-TRASH
SHOW-VIEW
SHOW-TRANSACTION
SHOW-STREAM-LOAD
SHOW-STATUS
SHOW-TABLE-ID
SHOW-SMALL-FILES
SHOW-POLICY
SHOW-CATALOG-RECYCLE-BIN
Data Types
BOOLEAN
TINYINT
SMALLINT
INT
BIGINT
LARGEINT
FLOAT
DOUBLE
DECIMAL
DECIMALV3
DATE
DATETIME
DATEV2
DATETIMEV2
CHAR
VARCHAR
STRING
HLL (HyperLogLog)
BITMAP
QUANTILE_STATE
ARRAY
JSONB
Operators
IN
Utility
HELP
USE
DESCRIBE
SWITCH
REFRESH
Admin Manual
cluster management
Cluster upgrade
Elastic scaling
load balancing
Data Admin
Data Backup
Data Restore
Data Recover
Sql Interception
Statistics of query execution
tracing
performance optimization
Maintenance and Monitor
Monitor Metrics
Monitor Metrics
Disk Capacity Management
Data replica management
Description of the return value of the OLAP function on the BE side
Doris Error Table
Tablet metadata management tool
Monitoring and alarming
Tablet Local Debug
Tablet Restore Tool
Metadata Operations and Maintenance
Memory Management
Memory Tracker
Memory Limit Exceeded Analysis
BE OOM Analysis
Config
Config Dir
FE Configuration
BE Configuration
User Property
User Privilege and Ldap
Authority Management
LDAP
System Table
backends
rowsets
Multi-tenancy
HTTP API
FE
MANAGER
Query Profile Action
Node Action
Cluster Action
Get Load State
Bootstrap Action
HA Action
Meta Replay State Action
Statement Execution Action
Profile Action
Meta Info Action
Meta Action
Query Profile Action
Show Data Action
Config Action
Get FE log file
Connection Action
System Action
Table Schema Action
Show Meta Info Action
Hardware Info Action
Log Action
Cancel Load Action
Logout Action
Backends Action
Get Load Info Action
Show Runtime Info Action
Query Detail Action
Upload Action
Session Action
Table Row Count Action
Get Small File Action
Table Query Plan Action
Set Config Action
Row Count Action
Get DDL Statement Action
Show Proc Action
Check Decommission Action
Health Action
Check Storage Type Action
Query Schema Action
RESTORE TABLET
PAD ROWSET
GET LABEL STATE
MIGRATE SINGLE TABLET TO A PARTICULAR DISK
CANCEL LABEL
PROFILE
SHOW DATA
GET TABLETS DISTRIBUTION BETWEEN DIFFERENT DISKS
CONNECTION
Compaction Action
QUERY DETAIL
GET TABLETS ON A PARTICULAR BE
get\_log\_file
CHECK/RESET Stub Cache
CHECK ALL TABLET SEGMENT LOST
FAQ
Install Error
Data Operation Error
SQL Error
Benchmark
Star-Schema-Benchmark
TPC-H Benchmark
Release notes
Release 1.2.2
Release 1.2.1
Release 1.2.0
Release 1.1.5
Release 1.1.4
Release 1.1.3
Release 1.1.2
Release 1.1.1
Release 1.1.0
暂无相关搜索结果！
本文档使用
BookStack
构建
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
普通下载
下载码下载(免登录无限下载)
你与大神的距离，只差一个APP
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
温馨提示
每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
下载码方式下载：免费、免登录、无限制。
免费获取下载码
下载码
文档格式
PDF
EPUB
MOBI
码上下载
×
微信小程序阅读
您与他人的薪资差距，只差一个随时随地学习的小程序
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
欢迎使用AI助手
AI助手
全屏
缩小
隐藏
清空
我的书签
添加书签
移除书签
