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

SQL Functions

来源 Doris 浏览 1 扫码 打印 2026-11-06 15:40:43
    • Date Time Functions
    • Sptial Functions
    • String Functions
    • Aggregate Functions
    • bitmap functions
    • bitwise function
    • json function
    • Encryption and Digest Functions
    • Hash Functions
    • Math Functions
    • table functions
    • window function
    • CAST
    • DIGITAL-MASKING
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Downloads
    • Compilation and Deployment
      • Compilation
      • Compiling with LDB toolchain
      • Compile on ARM platform
      • Installation and deployment
      • Cluster upgrade
    • Getting Started
      • Guidelines for Basic Use
      • Advanced Use Guide
      • Data Model, ROLLUP and Prefix Index
      • Data Partition
      • Rollup and query
      • Best Practices
    • Administrator Guide
      • Load Data
        • Introduction Overview
        • Batch Delete
        • Binlog Load
        • Broker Load
        • Routine Load
        • Sequence Column
        • Spark Load
        • Stream load
        • S3 Load
        • Delete
        • Insert Into
        • Load Json Format Data
      • Schema Change
        • Bitmap Index
        • Replace Table
        • Rollup
        • Schema Change
        • Temporary partition
      • Materialized view
      • HTTP API
        • FE
          • MANAGER
            • Cluster Action
            • Node Action
            • Query Profile Action
          • Backends Action
          • Bootstrap Action
          • Cancel Load Action
          • Check Decommission Action
          • Check Storage Type Action
          • Config Action
          • Connection Action
          • Get DDL Statement Action
          • Get Load Info Action
          • Get Load State
          • Get FE log file
          • Get Small File Action
          • HA Action
          • Hardware Info Action
          • Health Action
          • Log Action
          • Logout Action
          • Meta Action
          • Meta Info Action
          • Meta Replay State Action
          • Profile Action
          • Query Detail Action
          • Query Profile Action
          • Row Count Action
          • Session Action
          • Set Config Action
          • Show Data Action
          • Show Meta Info Action
          • Show Proc Action
          • Show Runtime Info Action
          • Statement Execution Action
          • System Action
          • Table Query Plan Action
          • Table Row Count Action
          • Table Schema Action
          • Upload Action
        • CANCEL LABEL
        • CHECK/RESET Stub Cache
        • Compaction Action
        • CONNECTION
        • get_log_file
        • GET LABEL STATE
        • GET TABLETS ON A PARTICULAR BE
        • PROFILE
        • QUERY DETAIL
        • RESTORE TABLET
        • SHOW DATA
        • MIGRATE SINGLE TABLET TO A PARTICULAR DISK
        • GET TABLETS DISTRIBUTION BETWEEN DIFFERENT DISKS
      • Maintainence Operation
        • Doris Error Table
        • Description of the return value of the OLAP function on the BE side
        • Disk Capacity Management
        • Metadata Operations and Maintenance
        • Monitoring and alarming
        • Multi-tenancy(Deprecated)
        • Tablet metadata management tool
        • Data replica management
        • Tablet Restore Tool
        • Metrics
          • BE Metrics
          • FE Metrics
      • Configuration
        • BE Configuration
        • FE Configuration
        • User Property
      • Block Rule
        • SQL Block Rule
      • Backup and Recovery
      • BloomFilter index
      • Broker
      • Colocation Join
      • Bucket Shuffle Join
      • Dynamic Partition
      • Data export
      • Use mysqldump data to export table structure or data
      • Export Query Result
      • Authority Management
      • LDAP
      • Resource management
      • Statistics of query execution
      • Runtime Filter
      • File Manager
      • SQL MODE
      • Time zone
      • Variable
      • update
      • Multi-tenancy
      • Orthogonal BITMAP calculation
    • Benchmark & Sample
      • Star-Schema-Benchmark
      • Systemd
      • Samples
    • Extending Ability
      • Audit log plugin
      • Doris On ES
      • Logstash Doris Output Plugin
      • ODBC of Doris
      • Hive of Doris
      • Iceberg of Doris
      • Plugin Development Manual
      • Spark Doris Connector
      • Flink Doris Connector
      • DataX doriswriter
      • Seatunnel
        • Seatunnel Connector Spark Doris
        • Seatunnel Connector Flink Doris
      • UDF
        • Contribute UDF
        • Native User Defined Function
        • Remote User Defined Function Service
    • Design Documents
      • Doris Storage File Format Optimization
      • GROUPING SETS DESIGN
      • Metadata Design Document
    • SQL Manual
      • SQL Functions
        • Date Time Functions
          • curdate
          • current_timestamp
          • date_add
          • date_format
          • date_sub
          • datediff
          • day
          • dayname
          • Dayofmonth
          • dayofweek
          • Dayofyear
          • from_days
          • from_unixtime
          • hour
          • makedate
          • minute
          • month
          • Monthname
          • now
          • second
          • Strtodate
          • time_round
          • timediff
          • timestampadd
          • timestampdiff
          • to_days
          • unix_timestamp
          • utc_timestamp
          • week
          • weekday
          • weekofyear
          • year
          • yearweek
        • Sptial Functions
          • ST_AsText,ST_AsWKT
          • ST_Circle
          • `ST_Contains’
          • ST_Distance_Sphere
          • ST_GeometryFromText,ST GeomFromText
          • ST_LineFromText,ST_LineStringFromText
          • St_Point’
          • ST_Polygon,ST_PolyFromText,ST_PolygonFromText
          • ST_X
          • ST_Y
        • String Functions
          • appendtrailingcharifabsent
          • ASCII
          • bit_length
          • CHAR_LENGTH
          • concat
          • Concat_ws
          • ends_with
          • findinset
          • hex
          • instr
          • lcase
          • left
          • length
          • locate
          • lower
          • lpad
          • ltrim
          • money_format
          • nullorempty
          • repeat
          • replace
          • REVERSE
          • right
          • rpad
          • split_part
          • starts_with
          • strleft
          • strright
          • substring
          • unhex
          • fuzzy match
            • like
            • not like
          • regular match
            • regexp
            • regexp_extract
            • regexp_replace
            • not regexp
        • Aggregate Functions
          • APPROXCOUNTDISTINCT
          • GROUP_CONCAT
          • AVG
          • BITMAP_UNION
          • COUNT
          • HLLUNIONAGG
          • MAX
          • MIN
          • PERCENTILE
          • PERCENTILE_APPROX
          • STDDEV,STDDEV_POP
          • STDDEV_SAMP
          • SUM
          • TOPN
          • VARIANCESAMP,VARIANCESAMP
          • VARIANCE,VARPOP,VARIANCEPOP
        • bitmap functions
          • bitmap_and
          • bitmap_contains
          • bitmap_empty
          • bitmapfromstring
          • bitmaphasany
          • bitmaphasall
          • bitmap_hash
          • bitmap_intersect
          • bitmap_or
          • bitmapandcount
          • bitmaporcount
          • bitmapxorcount
          • bitmap_not
          • bitmapandnot
          • bitmapandnot_count
          • bitmapsubsetin_range
          • bitmapsubsetlimit
          • sub_bitmap
          • bitmaptostring
          • bitmap_union
          • bitmap_xor
          • to_bitmap
          • bitmap_max
          • orthogonalbitmapintersect
          • orthogonalbitmapintersect_count
          • orthogonalbitmapunion_count
        • bitwise function
          • bitand
          • bitor
          • bitxor
          • bitnot
        • json function
          • getjsondouble
          • getjsonint
          • getjsonstring
          • json_array
          • json_object
          • json_quote
        • Encryption and Digest Functions
          • AES
          • MD5
          • MD5SUM
          • SM4
          • SM3
          • SM3SUM
        • Hash Functions
          • murmurhash332
        • Math Functions
          • conv
          • pmod
        • table functions
          • explode_bitmap
          • explode_split
          • explodejsonarray
        • window function
        • CAST
        • DIGITAL-MASKING
      • SQL Statements
        • Account Management
          • CREATE ROLE
          • CREATE USER
          • DROP ROLE
          • DROP USER
          • Grant
          • REVOKE
          • SET PASSWORD
          • SET PROPERTY
          • SHOW GRANTS
          • SHOW ROLES
        • Administration
          • ADMIN CANCEL REPAIR
          • ADMIN CLEAN TRASH
          • ADMIN CHECK TABLET
          • ADMIN COMPACT
          • ADMIN REPAIR
          • ADMIN SET CONFIG
          • ADMIN SET REPLICA STATUS
          • ADMIN SHOW CONFIG
          • ADMIN SHOW REPLICA DISTRIBUTION
          • ADMIN SHOW REPLICA STATUS
          • ALTER CLUSTER
          • ALTER SYSTEM
          • CANCEL DECOMMISSION
          • CREATE CLUSTER
          • CREATE FILE
          • DROP CLUSTER
          • DROP FILE
          • ENTER
          • INSTALL PLUGIN
          • LINK DATABASE
          • MIGRATE DATABASE
          • SET LDAPADMINPASSWORD
          • SHOW BACKENDS
          • SHOW BROKER
          • SHOW FILE
          • SHOW FRONTENDS
          • SHOW FULL COLUMNS
          • SHOW INDEX
          • SHOW MIGRATIONS
          • SHOW PLUGINS
          • SHOW TABLE STATUS
          • SHOW TRASH
          • UNINSTALL PLUGIN
        • Data Definition
          • ALTER DATABASE
          • ALTER TABLE
          • ALTER VIEW
          • BACKUP
          • CANCEL ALTER
          • CANCEL BACKUP
          • CREATE ENCRYPTKEY
          • CANCEL RESTORE
          • CREATE DATABASE
          • CREATE INDEX
          • CREATE MATERIALIZED VIEW
          • CREATE REPOSITORY
          • CREATE TABLE LIKE
          • CREATE TABLE
          • CREATE VIEW
          • Colocate Join
          • DROP DATABASE
          • DROP ENCRYPTKEY
          • DROP INDEX
          • DROP MATERIALIZED VIEW
          • DROP REPOSITORY
          • DROP TABLE
          • DROP VIEW
          • HLL
          • RECOVER
          • REFRESH DATABASE
          • REFRESH TABLE
          • RESTORE
          • SHOW ENCRYPTKEYS
          • TRUNCATE TABLES
          • CREATE FUNCTION
          • DROP FUNCTION
          • SHOW FUNCTIONS
        • Data Manipulation
          • BEGIN
          • BROKER LOAD
          • CANCEL DELETE
          • Cancel Label
          • CANCEL LOAD
          • CREATE SYNC JOB
          • DELETE
          • EXPORT
          • GET LABEL STATE
          • GROUP BY
          • LOAD
          • MINI LOAD
          • MULTI LOAD
          • OUTFILE
          • PAUSE ROUTINE LOAD
          • PAUSE SYNC JOB
          • RESTORE TABLET
          • RESUME ROUTINE LOAD
          • RESUME SYNC JOB
          • ROUTINE LOAD
          • SHOW ALTER
          • SHOW BACKUP
          • SHOW CREATE FUNCTION
          • SHOW CREATE ROUTINE LOAD
          • SHOW DATA
          • SHOW DATA SKEW
          • SHOW DATABASES
          • SHOW DELETE
          • SHOW DYNAMIC PARTITION TABLES
          • SHOW EXPORT
          • SHOW LOAD
          • SHOW PARTITIONS
          • SHOW PROPERTY
          • SHOW REPOSITORIES
          • SHOW RESTORE
          • SHOW ROUTINE LOAD TASK
          • SHOW ROUTINE LOAD
          • SHOW SNAPSHOT
          • SHOW SYNC JOB
          • SHOW TABLES
          • SHOW TABLE CREATION
          • SHOW TABLET
          • SHOW TRANSACTION
          • SHOW LAST INSERT
          • STOP ROUTINE LOAD
          • STOP SYNC JOB
          • STREAM LOAD
          • ALTER ROUTINE LOAD
          • INSERT
          • UPDATE
          • Lateral View
        • Data Types
          • BIGINT
          • BITMAP
          • BOOLEAN
          • CHAR
          • date
          • DATETIME
          • DECIMAL
          • Double
          • FLOAT
          • HLL (HyperLogLog)
          • INT
          • SMALLINT
          • STRING
          • TINYINT
          • VARCHAR
        • Utility
          • Describe
    • Doris User
      • user case
    • Developer Guide
      • Debug Tool
      • Doris Docker quick build development environment
      • Doris BE Storage Layer Benchmark Tool
      • Setting FE dev env - Eclipse
      • Setting Up dev env for FE - IntelliJ IDEA
      • BE development and debugging environment under Linux
      • Java Format Code
      • C++ Format Code
      • How to Share blogs
      • Minidump
      • Bitmap/HLL data format
    • FAQ
      • FAQ
      • Common Error
    • Apache Community
      • Doris Team
      • Gitter Manual
      • Subscribe to mailing lists
      • Feedback
      • How to Contribute
        • Contribute to Doris
        • Committer Guide
        • Commit Format Specification
        • Code Submission Guide
      • Release Process & Verification
        • Release Preparation
        • Release Doris Core
        • Release Doris Connectors
        • Complete Release
        • Verify the Apache release version
      • Security
    暂无相关搜索结果！

      本文档使用 WanXiangYunDang 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      微信小程序阅读

      BookChat 微信小程序阅读
      微信扫一扫，知识掌上学

      书签列表

        阅读记录

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