Apache Doris v1.1 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

String Functions

来源 1 浏览 185 扫码 打印 2022-10-13 12:16:25
  • bit_length
  • lpad
  • lower
  • upper
  • repeat
  • concat
  • substring
  • ends_with
  • trim
  • rtrim
  • hex
  • elt
  • find_in_set
  • left
  • strleft
  • split_part
  • parse_url
  • Regular Match
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • 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 ) 重置阅读进度