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

String Functions

来源 Doris 浏览 2 扫码 打印 2026-11-04 20:05:37
    • ascii
    • length
    • bit_length
    • char_length
    • lpad
    • rpad
    • lower
    • lcase
    • upper
    • ucase
    • repeat
    • reverse
    • concat
    • concat_ws
    • substr
    • substring
    • append_trailing_char_if_absent
    • ends_with
    • starts_with
    • trim
    • ltrim
    • rtrim
    • null_or_empty
    • hex
    • unhex
    • elt
    • instr
    • locate
    • find_in_set
    • replace
    • left
    • right
    • strleft
    • strright
    • split_part
    • money_format
    • parse_url
    • Fuzzy Match
    • Regular Match
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • 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
    • Table Design
      • Data Model
      • Data Partition
      • Guidelines for Basic Use
      • Rollup and query
      • Best Practices
      • Index
        • 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
      • Materialized view
      • Broker
      • Best Practice
        • Query Analysis
        • Import Analysis
        • Debug Log
      • Resource management
      • Orthogonal BITMAP calculation
      • Approximate deduplication using HLL
      • Variable
      • Time zone
      • File Manager
    • Ecosystem
      • Expansion table
        • Doris On ES
        • Doris Hudi external table
        • Doris On Iceberg
        • Doris On ODBC
        • Doris On Hive
      • Spark Doris Connector
      • Flink Doris Connector
      • DataX doriswriter
      • Mysql to Doris
      • Logstash Doris Output Plugin
      • Plugin Development Manual
      • Audit log plugin
      • CloudCanal Data Import
      • Doris Manager
        • Compile and deploy
        • Initialize
        • Cluster management
        • Space list
        • Space management
        • System settings
      • 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
    • SQL Manual
      • SQL Functions
        • Array Functions
          • ARRAY_MAX Function
          • array_remove
          • array_slice
          • array_sort
          • array_position
          • array_contains
          • array_except
          • ARRAY_PRODUCT Function
          • array_intersect
          • arrays_overlap
          • ARRAY_MIN Function
          • element_at
          • ARRAY_AVG Function
          • size
          • array_distinct
          • array_union
          • ARRAY_SUM Function
        • 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
          • 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_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
          • ascii
          • length
          • bit_length
          • char_length
          • lpad
          • rpad
          • lower
          • lcase
          • upper
          • ucase
          • repeat
          • reverse
          • concat
          • concat_ws
          • substr
          • substring
          • append_trailing_char_if_absent
          • ends_with
          • starts_with
          • trim
          • ltrim
          • rtrim
          • null_or_empty
          • hex
          • unhex
          • elt
          • instr
          • locate
          • find_in_set
          • replace
          • left
          • right
          • strleft
          • strright
          • split_part
          • money_format
          • parse_url
          • Fuzzy Match
            • like
            • not like
          • Regular Match
            • regexp
            • regexp_extract
            • regexp_replace
            • not regexp
        • Aggregate Functions
          • COLLECT_SET
          • MIN
          • STDDEV_SAMP
          • AVG
          • PERCENTILE
          • HLL_UNION_AGG
          • TOPN
          • COUNT
          • SUM
          • MAX_BY
          • BITMAP_UNION
          • PERCENTILE_APPROX
          • STDDEV,STDDEV_POP
          • GROUP_CONCAT
          • COLLECT_LIST
          • MIN_BY
          • MAX
          • VARIANCE_SAMP,VARIANCE_SAMP
          • APPROX_COUNT_DISTINCT
          • VARIANCE,VAR_POP,VARIANCE_POP
        • Bitmap Functions
          • to_bitmap
          • bitmap_hash
          • bitmap_from_string
          • bitmap_to_string
          • 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
        • Bitwise Functions
          • bitand
          • bitor
          • bitxor
          • bitnot
        • Condition Functions
          • case
          • coalesce
          • if
          • ifnull
          • nvl
          • nullif
        • JSON Functions
          • get_json_double
          • get_json_int
          • get_json_string
          • json_array
          • json_object
          • json_quote
        • Hash Functions
          • murmur_hash3_32
        • Math Functions
          • conv
          • bin
          • sin
          • cos
          • tan
          • asin
          • acos
          • atan
          • e
          • Pi
          • exp
          • log
          • log2
          • ln
          • log10
          • ceil
          • floor
          • pmod
          • round
          • truncate
          • abs
          • sqrt
          • cbrt
          • pow
          • degrees
          • radians
          • sign
          • positive
          • negative
          • greatest
          • least
        • Encryption Functions
          • AES
          • MD5
          • MD5SUM
          • SM4
          • SM3
          • SM3SUM
        • Table Functions
          • explode_json_array
          • explode
          • explode_split
          • explode_bitmap
          • outer combinator
          • numbers
          • explode_numbers
        • 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
      • 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-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-COLUMN
            • ALTER-TABLE-PROPERTY
            • ALTER-TABLE-ROLLUP
            • ALTER-TABLE-RENAME
          • 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
          • 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
        • Show
          • SHOW-DATABASES
          • SHOW-LAST-INSERT
          • SHOW-BACKUP
          • SHOW-MIGRATIONS
          • SHOW-PARTITION-ID
          • SHOW ALTER TABLE MATERIALIZED VIEW
          • SHOW-SNAPSHOT
          • SHOW-FUNCTIONS
          • SHOW-ROLLUP
          • SHOW-ENGINES
          • SHOW-DELETE
          • SHOW-SQL-BLOCK-RULE
          • SHOW-CREATE-FUNCTION
          • SHOW-ROUTINE-LOAD
          • SHOW-SYNC-JOB
          • SHOW-WHITE-LIST
          • SHOW-WARNING
          • SHOW DATA SKEW
          • SHOW-DATABASE-ID
          • SHOW-DYNAMIC-PARTITION
          • SHOW-TABLET
          • SHOW-VARIABLES
          • SHOW-CREATE-ROUTINE-LOAD
          • SHOW-PLUGINS
          • SHOW-EVENTS
          • SHOW-LOAD-WARNINGS
          • SHOW-ROLES
          • SHOW-GRANTS
          • SHOW-INDEX
          • SHOW-EXPORT
          • SHOW-PROCEDURE
          • SHOW-ROUTINE-LOAD-TASK
          • SHOW-BACKENDS
          • SHOW-PROC
          • SHOW-COLLATION
          • SHOW-TABLE-STATUS
          • SHOW-REPOSITORIES
          • SHOW-CREATE-DATABASE
          • SHOW-CREATE-MATERIALIZED-VIEW
          • SHOW-QUERY-PROFILE
          • SHOW-OPEN-TABLES
          • SHOW-TABLETS
          • SHOW-LOAD
          • SHOW-TABLES
          • SHOW-RESOURCES
          • SHOW-PARTITIONS
          • SHOW-FRONTENDS
          • SHOW-RESTORE
          • SHOW-DATA
          • SHOW-PROPERTY
          • SHOW-BROKER
          • SHOW-TRIGGERS
          • SHOW-PROCESSLIST
          • SHOW-ENCRYPT-KEY
          • SHOW-COLUMNS
          • SHOW-TRASH
          • SHOW-VIEW
          • SHOW-TRANSACTION
          • SHOW-FILE
          • SHOW-STREAM-LOAD
          • SHOW-STATUS
          • SHOW-LOAD-PROFILE
          • SHOW-TABLE-ID
          • SHOW-ALTER
          • SHOW-SMALL-FILES
          • SHOW-CREATE-TABLE
          • SHOW-CHARSET
        • Data Types
          • VARCHAR
          • INT
          • DATE
          • DATETIME
          • DATEV2
          • DATETIMEV2
          • BITMAP
          • DOUBLE
          • STRING
          • HLL (HyperLogLog)
          • ARRAY
          • LARGEINT
          • QUANTILE_STATE
          • SMALLINT
          • TINYINT
          • DECIMAL
          • BIGINT
          • BOOLEAN
          • FLOAT
          • CHAR
        • Utility
          • HELP
          • USE
          • DESCRIBE
          • SWITCH
          • REFRESH-CATALOG
    • 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
        • Multi-tenancy(Deprecated)
        • Tablet Local Debug
        • Tablet Restore Tool
        • Metadata Operations and Maintenance
      • Config
        • FE Configuration
        • BE Configuration
        • User Property
      • User Privilege and Ldap
        • Authority Management
        • LDAP
      • 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
        • 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
    暂无相关搜索结果！

      本文档使用 WanXiangYunDang 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

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

      微信小程序阅读

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

      书签列表

        阅读记录

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