Apache Doris v1.1 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
AES
来源 1
浏览
226
扫码
打印
2022-10-13 12:11:07
example
Syntax
example
AES_DECRYPT
description
Syntax
keywords
上一篇:
下一篇:
发布点评
Admin Manual
Sql Interception
Multi-tenancy
tracing
performance optimization
cluster management
Cluster upgrade
load balancing
Elastic scaling
Config
FE Configuration
User Property
BE Configuration
Data Admin
Data Recover
Data Backup
Data Restore
HTTP API
GET TABLETS DISTRIBUTION BETWEEN DIFFERENT DISKS
GET LABEL STATE
CANCEL LABEL
QUERY DETAIL
MIGRATE SINGLE TABLET TO A PARTICULAR DISK
FE
Session Action
Log Action
Show Proc Action
Query Profile Action
Row Count Action
Hardware Info Action
Check Storage Type Action
Show Meta Info Action
Get Small File Action
Meta Info Action
Backends Action
Config Action
Health Action
Show Data Action
Statement Execution Action
Get DDL Statement Action
Meta Action
Upload Action
Set Config Action
Connection Action
Logout Action
MANAGER
Node Action
Cluster Action
Query Profile Action
Profile Action
Get FE log file
System Action
Table Query Plan Action
Query Schema Action
Show Runtime Info Action
Get Load Info Action
Meta Replay State Action
Table Schema Action
HA Action
Table Row Count Action
Cancel Load Action
Bootstrap Action
Query Detail Action
Check Decommission Action
Get Load State
RESTORE TABLET
CONNECTION
GET TABLETS ON A PARTICULAR BE
SHOW DATA
CHECK ALL TABLET SEGMENT LOST
CHECK/RESET Stub Cache
Compaction Action
PROFILE
get\_log\_file
Maintenance and Monitor
Disk Capacity Management
Tablet Restore Tool
Tablet Local Debug
Data replica management
Metadata Operations and Maintenance
Monitoring and alarming
Multi-tenancy(Deprecated)
Monitor Metrics
Monitor Metrics
Doris Error Table
Description of the return value of the OLAP function on the BE side
Tablet metadata management tool
User Privilege and Ldap
Authority Management
LDAP
Statistics of query execution
Advanced Usage
Approximate deduplication using HLL
Resource management
Materialized view
File Manager
Time zone
Alter Table
Replace Table
Schema Change
Best Practice
Debug Log
Query Analysis
Import Analysis
Data Cache
Partition Cache
Doris Partition
Temporary partition
Dynamic Partition
Join Optimization
Doris Join optimization principle
Colocation Join
Bucket Shuffle Join
Runtime Filter
Variable
Broker
Orthogonal BITMAP calculation
Data Operation
Export
Export Query Result
Data export
Use mysqldump data to export table structure or data
Import
Import Overview
Import Scenes
Synchronize data using Insert method
Import local data
Synchronize data through external table
Data transformation, column mapping and filtering
Data import things and atomicity
import strict mode
External storage data import
Kafka Data Subscription
Import Way
Spark Load
Load Json Format Data
Broker Load
S3 Load
Insert Into
Binlog Load
Stream load
Routine Load
Update and Delete
Sequence Column
Batch Delete
Delete
update
Doris Introduction
Introduction to Apache Doris
Ecosystem
DataX doriswriter
Logstash Doris Output Plugin
Audit log plugin
Plugin Development Manual
CloudCanal Data Import
Mysql to Doris
Flink Doris Connector
Spark Doris Connector
Doris Manager
System settings
Cluster management
Space list
Initialize
Compile and deploy
Space management
Expansion table
Doris On ES
Doris On Iceberg
Doris On Hive
Doris On ODBC
Doris Hudi external table
SeaTunnel
Seatunnel Connector Flink Doris
Seatunnel Connector Spark Doris
UDF
Contribute UDF
Remote User Defined Function Service
Native User Defined Function
Java UDF
UDFA
Remote User Defined Aggregation Function Service
FAQ
Install Error
Data Operation Error
SQL Error
Getting Started
Getting-Started
Install And Deploy
Installation and deployment
Compile
Compilation
Compiling with LDB toolchain
Compilation With Arm
SQL Manual
SQL Functions
CAST
DIGITAL-MASKING
Analytic(Window) Functions
WINDOW-FUNCTION-FIRST_VALUE
WINDOW-FUNCTION-ROW_NUMBER
WINDOW-FUNCTION
WINDOW-FUNCTION-COUNT
WINDOW-FUNCTION-SUM
WINDOW-FUNCTION-LAST_VALUE
WINDOW-FUNCTION-MIN
WINDOW-FUNCTION-LAG
WINDOW-FUNCTION-DENSE_RANK
WINDOW-FUNCTION-AVG
WINDOW-FUNCTION-RANK
WINDOW-FUNCTION-WINDOW-FUNNEL
WINDOW-FUNCTION-LEAD
WINDOW-FUNCTION-NTILE
WINDOW-FUNCTION-MAX
Aggregate Functions
VARIANCE_SAMP,VARIANCE_SAMP
PERCENTILE
HLL_UNION_AGG
APPROX_COUNT_DISTINCT
COUNT
STDDEV,STDDEV_POP
COLLECT_LIST
STDDEV_SAMP
AVG
MAX_BY
GROUP_CONCAT
MIN
TOPN
BITMAP_UNION
MAX
COLLECT_SET
VARIANCE,VAR_POP,VARIANCE_POP
MIN_BY
SUM
PERCENTILE_APPROX
Array Functions
ARRAY_SUM Function
array_except
size
array_distinct
array_intersect
array_slice
element_at
ARRAY_MIN Function
arrays_overlap
array_union
array_sort
ARRAY_AVG Function
ARRAY_PRODUCT Function
array_position
ARRAY_MAX Function
array_remove
array_contains
Bitmap Functions
bitmap_subset_in_range
bitmap_contains
sub_bitmap
bitmap_count
to_bitmap
bitmap_has_any
bitmap_and_count
bitmap_max
bitmap_empty
bitmap_min
bitmap_subset_limit
bitmap_xor
bitmap_and_not_count
orthogonal_bitmap_intersect_count
bitmap_hash
bitmap_intersect
bitmap_not
bitmap_from_string
orthogonal_bitmap_intersect
bitmap_and
bitmap_to_string
orthogonal_bitmap_union_count
intersect_count
bitmap_and_not
bitmap_xor_count
bitmap_union
bitmap_has_all
bitmap_or_count
bitmap_or
Bitwise Functions
bitnot
bitor
bitand
bitxor
Condition Functions
case
nvl
ifnull
coalesce
nullif
if
Date Functions
weeks_add
week
hours_sub
timestampdiff
weeks_sub
hours_add
datediff
date_add
months_diff
year
dayofweek
minute
date_format
seconds_sub
str_to_date
to_days
dayofmonth
dayname
days_sub
unix_timestamp
weekday
curdate,current_date
from_unixtime
hours_diff
month
weeks_diff
minutes_diff
months_add
day
makedate
from_days
days_diff
timediff
monthname
yearweek
quarter
minutes_sub
localtime,localtimestamp
minutes_add
weekofyear
current_timestamp
seconds_add
time_round
curtime,current_time
hour
dayofyear
days_add
second
years_diff
now
extract
years_add
convert_tz
months_sub
timestampadd
date_sub
utc_timestamp
to_date
seconds_diff
years_sub
Encryption Functions
SM4
MD5
AES
MD5SUM
SM3
SM3SUM
GIS Functions
St_Point
ST_Contains
ST_Polygon,ST_PolyFromText,ST_PolygonFromText
ST_LineFromText,ST_LineStringFromText
ST_X
ST_Circle
ST_Y
ST_GeometryFromText,ST_GeomFromText
ST_Distance_Sphere
ST_AsText,ST_AsWKT
Hash Functions
murmur_hash3_32
JSON Functions
get_json_string
json_object
json_quote
json_array
get_json_double
get_json_int
Math Functions
log2
ln
truncate
acos
abs
least
asin
tan
cbrt
pow
floor
bin
ceil
sin
negative
log10
pmod
e
radians
degrees
greatest
positive
atan
cos
round
conv
sign
Pi
exp
log
sqrt
String Functions
starts_with
split_part
upper
append_trailing_char_if_absent
ascii
replace
lpad
substring
lcase
ends_with
null_or_empty
reverse
repeat
money_format
parse_url
rpad
rtrim
ucase
substr
right
length
concat_ws
char_length
Regular Match
regexp_replace
not regexp
regexp
regexp_extract
locate
lower
concat
ltrim
find_in_set
left
strleft
hex
instr
trim
elt
bit_length
strright
unhex
Fuzzy Match
not like
like
Table Functions
explode
explode_bitmap
explode_json_array
numbers
outer combinator
explode_numbers
explode_split
SQL Reference
Account Management
DROP-USER
GRANT
LDAP
REVOKE
ALTER-USER
SET-PASSWORD
CREATE-ROLE
DROP-ROLE
SET-PROPERTY
CREATE-USER
Cluster management
ALTER-SYSTEM-ADD-OBSERVER
ALTER-SYSTEM-DROP-FOLLOWER
ALTER-SYSTEM-ADD-BROKER
ALTER-SYSTEM-DROP-BACKEND
ALTER-SYSTEM-ADD-FOLLOWER
ALTER-SYSTEM-DROP-OBSERVER
ALTER-SYSTEM-DROP-BROKER
ALTER-SYSTEM-MODIFY-BROKER
ALTER-SYSTEM-ADD-BACKEND
CANCEL-ALTER-SYSTEM
ALTER-SYSTEM-MODIFY-BACKEND
ALTER-SYSTEM-DECOMMISSION-BACKEND
Database Administration
ADMIN-SHOW-REPLICA-DISTRIBUTION
ADMIN-SHOW-REPLICA-STATUS
ADMIN DIAGNOSE TABLET
ADMIN-COPY-TABLET
ADMIN-SET-CONFIG
ENABLE-FEATURE
ADMIN-SHOW-CONFIG
UNINSTALL-PLUGIN
ADMIN SHOW TABLET STORAGE FORMAT
ADMIN-CLEAN-TRASH
ADMIN-SET-REPLICA-STATUS
KILL
INSTALL-PLUGIN
ADMIN-CANCEL-REPAIR
SET-VARIABLE
RECOVER
ADMIN-CHECK-TABLET
ADMIN-REPAIR-TABLE
Data Types
STRING
SMALLINT
ARRAY
BOOLEAN
VARCHAR
TINYINT
INT
DATETIME
DATETIMEV2
FLOAT
BITMAP
DOUBLE
DECIMAL
HLL (HyperLogLog)
CHAR
QUANTILE_STATE
BIGINT
LARGEINT
DATEV2
DATE
DDL
Alter
ALTER-TABLE-PARTITION
ALTER-RESOURCE
ALTER-TABLE-ROLLUP
ALTER-TABLE-BITMAP
ALTER-VIEW
ALTER-SQL-BLOCK-RULE
ALTER-TABLE-RENAME
CANCEL-ALTER-TABLE
ALTER-TABLE-REPLACE-COLUMN
ALTER-TABLE-PROPERTY
ALTER-TABLE-COMMENT
ALTER-DATABASE
ALTER-TABLE-COLUMN
Backup and Restore
DROP-REPOSITORY
CANCEL-RESTORE
CREATE-REPOSITORY
CANCEL-BACKUP
BACKUP
RESTORE
Create
CREATE-TABLE-AS-SELECT
CREATE-FILE
CREATE-INDEX
CREATE-DATABASE
CREATE-MATERIALIZED-VIEW
CREATE-EXTERNAL-TABLE
CREATE-CATALOG
CREATE-SQL-BLOCK-RULE
CREATE-TABLE-LIKE
CREATE-VIEW
CREATE-RESOURCE
CREATE-POLICY
CREATE-TABLE
CREATE-FUNCTION
CREATE-ENCRYPT-KEY
Drop
DROP-MATERIALIZED-VIEW
DROP-INDEX
DROP-MATERIALIZED-VIEW
DROP-TABLE
DROP-DATABASE
DROP-FILE
DROP-ENCRYPT-KEY
DROP-FUNCTION
DROP-RESOURCE
DROP-CATALOG
TRUNCATE-TABLE
DROP-DATABASE
DML
OUTFILE
Load
STOP-ROUTINE-LOAD
RESUME-SYNC-JOB
RESUME-ROUTINE-LOAD
CREATE-ROUTINE-LOAD
CANCEL-LOAD
CREATE-SYNC-JOB
STOP-SYNC-JOB
STREAM-LOAD
MULTI-LOAD
CLEAN-LABEL
ALTER-ROUTINE-LOAD
PAUSE-SYNC-JOB
BROKER-LOAD
PAUSE-ROUTINE-LOAD
Manipulation
DELETE
EXPORT
INSERT
UPDATE
SELECT
Show
SHOW-COLUMNS
SHOW-PROPERTY
SHOW-BACKUP
SHOW-TABLES
SHOW-BACKENDS
SHOW-EVENTS
SHOW-STATUS
SHOW-TRIGGERS
SHOW-VIEW
SHOW-FUNCTIONS
SHOW-PROCEDURE
SHOW-ROLES
SHOW-ROUTINE-LOAD
SHOW-FILE
SHOW-TABLE-STATUS
SHOW-FRONTENDS
SHOW-DATABASE-ID
SHOW-ROLLUP
SHOW-SNAPSHOT
SHOW-SMALL-FILES
SHOW-ALTER
SHOW-CREATE-DATABASE
SHOW-CHARSET
SHOW-ENCRYPT-KEY
SHOW-TRASH
SHOW-QUERY-PROFILE
SHOW-MIGRATIONS
SHOW-PARTITION-ID
SHOW-EXPORT
SHOW-DYNAMIC-PARTITION
SHOW-WARNING
SHOW-PROCESSLIST
SHOW-COLLATION
SHOW-CREATE-TABLE
SHOW-SYNC-JOB
SHOW-VARIABLES
SHOW-ROUTINE-LOAD-TASK
SHOW-DATABASES
SHOW-DELETE
SHOW-TABLET
SHOW-WHITE-LIST
SHOW-TRANSACTION
SHOW-PLUGINS
SHOW-GRANTS
SHOW-BROKER
SHOW ALTER TABLE MATERIALIZED VIEW
SHOW-SQL-BLOCK-RULE
SHOW-CREATE-MATERIALIZED-VIEW
SHOW DATA SKEW
SHOW-TABLETS
SHOW-TABLE-ID
SHOW-PARTITIONS
SHOW-CREATE-FUNCTION
SHOW-ENGINES
SHOW-DATA
SHOW-LOAD-PROFILE
SHOW-LOAD
SHOW-PROC
SHOW-REPOSITORIES
SHOW-RESOURCES
SHOW-INDEX
SHOW-RESTORE
SHOW-LOAD-WARNINGS
SHOW-LAST-INSERT
SHOW-CREATE-ROUTINE-LOAD
SHOW-STREAM-LOAD
SHOW-OPEN-TABLES
Utility
REFRESH-CATALOG
DESCRIBE
HELP
USE
SWITCH
Table Design
Best Practices
Data Model
Rollup and query
Guidelines for Basic Use
Data Partition
Index
BloomFilter index
Bitmap Index
Index
暂无相关搜索结果!
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫,轻松掌上读
×
文档下载
请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度