思维导图备注

Apache Doris v1.2 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

SQL Reference

 Github  来源:Doris 浏览 226 扫码 分享 2023-02-18 22:41:24
  • Account Management
  • Cluster management
  • DDL
  • DML
  • Database Administration
  • Show
  • Data Types
  • Operators
  • Utility
当前内容版权归 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
    APP下载
    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档
    温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
    下载码方式下载：免费、免登录、无限制。 免费获取下载码

    微信小程序阅读

    BookChat 微信小程序阅读
    您与他人的薪资差距，只差一个随时随地学习的小程序

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度