我的书签
添加书签
移除书签SQL Functions
- Getting Started
- Doris Introduction
- Install And Deploy
- Table Design
- Data Operation
- Advanced Usage
- Alter Table
- Doris Partition
- Data Cache
- Join Optimization
- [Experimental] Pipeline execution engine
- Materialized view
- Broker
- Best Practice
- Resource management
- Orthogonal BITMAP calculation
- Approximate deduplication using HLL
- Variable
- Time zone
- File Manager
- cold hot separation
- Compute Node
- High-concurrency point query
- Lakehouse
- Ecosystem
- 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
- 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
- Regular Match
- 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
- Condition Functions
- JSON Functions
- Hash Functions
- HLL Functions
- Math Functions
- Encryption Functions
- Table Functions
- 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
- Array Functions
- SQL Reference
- Account Management
- 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
- DML
- 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
- Operators
- Utility
- SQL Functions
- Admin Manual
- cluster management
- Data Admin
- Sql Interception
- Statistics of query execution
- tracing
- performance optimization
- Maintenance and Monitor
- Memory Management
- Config
- User Privilege and Ldap
- System Table
- Multi-tenancy
- HTTP API
- FE
- MANAGER
- 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
- FE
- FAQ
- Benchmark
- Release notes
暂无相关搜索结果！
本文档使用 BookStack 构建
