思维导图备注

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

SQL Functions

 Github  来源:Doris 浏览 310 扫码 分享 2021-12-12 23:03:20
  • Date Time Functions
  • Sptial Functions
  • String Functions
  • Aggregate Functions
  • bitmap functions
  • Hash Functions
  • window function
  • CAST
  • DIGITAL-MASKING
当前内容版权归 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)
  • Downloads
  • Compilation and Deployment
    • Compilation
    • 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
        • 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
      • 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
    • Broker
    • Colocation Join
    • Bucket Shuffle Join
    • Dynamic Partition
    • Data export
    • Export Query Result
    • Authority Management
    • LDAP
    • Resource management
    • Statistics of query execution
    • Runtime Filter
    • File Manager
    • SQL MODE
    • Time zone
    • Variable
    • update
    • Multi-tenancy
  • Benchmark & Bast Practices
    • Star-Schema-Benchmark
    • Systemd
    • Samples
  • Extending Ability
    • Audit log plugin
    • Doris On ES
    • Logstash Doris Output Plugin
    • ODBC of Doris
    • Plugin Development Manual
    • Spark Doris Connector
    • Flink Doris Connector
    • DataX doriswriter
    • UDF
      • Contribute UDF
      • User Defined Function
      • Users contribute UDF
        • Orthogonal BITMAP calculation UDAF
  • 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
        • 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
        • getjsondouble
        • getjsonint
        • getjsonstring
        • group_concat
        • instr
        • lcase
        • left
        • length
        • locate
        • lower
        • lpad
        • ltrim
        • money_format
        • nullorempty
        • repeat
        • replace
        • REVERSE
        • right
        • rpad
        • split_part
        • starts_with
        • strleft
        • strright
        • fuzzy match
          • like
          • not like
        • regular match
          • regexp
          • regexp_extract
          • regexp_replace
            • description
            • example
            • keyword
          • not regexp
      • Aggregate Functions
        • APPROXCOUNTDISTINCT
        • 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
        • bitmap_hash
        • bitmap_intersect
        • bitmap_or
        • bitmap_not
        • bitmaptostring
        • bitmap_union
        • bitmap_xor
        • to_bitmap
      • Hash Functions
        • murmurhash332
      • window function
      • CAST
      • DIGITAL-MASKING
    • DDL 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 REPAIR
        • ADMIN SET CONFIG
        • ADMIN SET REPLICA STATUS
        • ADMIN SHOW CONFIG
        • ADMIN SHOW REPLICA DISTRIBUTION
        • ADMIN SHOW REPLICA STATUS
        • ADMIN SHOW DATA SKEW
        • 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
        • RESTORE
        • SHOW ENCRYPTKEYS
        • TRUNCATE TABLES
        • CREATE FUNCTION
        • DROP FUNCTION
        • SHOW FUNCTIONS
      • Data Manipulation
        • BROKER LOAD
        • CANCEL DELETE
        • Cancel Label
        • CANCEL LOAD
        • CREATE SYNC JOB
        • DELETE
        • EXPORT
        • GET LABEL STATE
        • GROUP BY
        • LOAD
        • MINI LOAD
        • MULTI LOAD
        • 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 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 TABLET
        • SHOW TRANSACTION
        • STOP ROUTINE LOAD
        • STOP SYNC JOB
        • STREAM LOAD
        • ALTER ROUTINE LOAD
        • INSERT
        • UPDATE
      • Data Types
        • BIGINT
        • BITMAP
        • BOOLEAN
        • CHAR
        • date
        • DATETIME
        • DECIMAL
        • Double
        • FLOAT
        • HLL (HyperLogLog)
        • INT
        • SMALLINT
        • STRING
        • TINYINT
        • VARCHAR
      • Utility
        • Describe
  • Developer Guide
    • Debug Tool
    • 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
  • Apache Community
    • PMC Members & Committer
    • Gitter Manual
    • Subscribe to mailing lists
    • Feedback
    • Contribute to Doris
    • Committer Guide
    • Code Submission Guide
    • Publish of Apache Doris
    • Verify Apache Release
暂无相关搜索结果！

    本文档使用 BookStack 构建

    展开/收起文章目录

    分享，让知识传承更久远

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    • 普通下载
    • 下载码下载(免登录无限下载)
    你与大神的距离，只差一个APP
    APP下载
    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档
    温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
    下载码方式下载：免费、免登录、无限制。 免费获取下载码

    微信小程序阅读

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

    书签列表

      阅读记录

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