我的书签
添加书签
移除书签Numeric Functions
- Getting Started
- Install and Deploy
- Table Design
- Data Operation
- Advanced Usage
- Query Acceleration
- Lakehouse
- Ecosystem
- SQL Manual
- SQL Functions
- Array Functions
- ARRAY
- ARRAY_MAX
- ARRAY_MIN
- ARRAY_MAP
- ARRAY_FILTER
- ARRAY_AVG
- ARRAY_SUM
- ARRAY_SIZE
- ARRAY_REMOVE
- ARRAY_SLICE
- ARRAY_SORT
- ARRAY_REVERSE_SORT
- ARRAY_SORTBY
- 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_ENUMERATE_UNIQ
- ARRAY_POPBACK
- ARRAY_POPFRONT
- ARRAY_PUSHFRONT
- ARRAY_PUSHBACK
- ARRAY_COMPACT
- ARRAY_CONCAT
- ARRAY_ZIP
- ARRAY_SHUFFLE
- ARRAY_CUM_SUM
- ARRAY_EXISTS
- ARRAY_FIRST_INDEX
- ARRAY_LAST_INDEX
- ARRAY_FIRST
- ARRAY_LAST
- ARRAYS_OVERLAP
- ARRAY_COUNT
- 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_SECOND
- FROM_UNIXTIME
- UNIX_TIMESTAMP
- UTC_TIMESTAMP
- TO_DATE
- TO_DAYS
- TIME_TO_SEC
- SEC_TO_TIME
- EXTRACT
- MAKEDATE
- STR_TO_DATE
- TIME_ROUND
- TIMEDIFF
- TIMESTAMPADD
- TIMESTAMPDIFF
- DATE_ADD
- DATE_SUB
- DATE_TRUNC
- DATE_FORMAT
- DATEDIFF
- MICROSECONDS_ADD
- MICROSECONDS_DIFF
- MICROSECONDS_SUB
- MILLISECONDS_ADD
- MILLISECONDS_DIFF
- MILLISECONDS_SUB
- 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
- CHAR
- 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
- Search in String
- Mask in String
- Fuzzy Match
- Regular Match
- Struct Functions
- Combinators
- 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
- COUNT_BY_ENUM
- HISTOGRAM
- MAP_AGG
- 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_ANDNOT
- BITMAP_SUBSET_LIMIT
- BITMAP_SUBSET_IN_RANGE
- SUB_BITMAP
- BITMAP_COUNT
- BITMAP_AND_COUNT
- BITMAP_AND_NOT_COUNT,BITMAP_ANDNOT_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
- ORTHOGONAL_BITMAP_EXPR_CALCULATE
- ORTHOGONAL_BITMAP_EXPR_CALCULATE_COUNT
- BITMAP_HASH64
- BITMAP_REMOVE
- Bitwise Functions
- Conditional Functions
- JSON Functions
- Hash Functions
- HLL Functions
- Numeric Functions
- Encryption Functions
- Table Functions
- Analytic(Window) Functions
- Window Functions Overview
- WINDOW_FUNCTION_SUM
- WINDOW_FUNCTION_AVG
- WINDOW_FUNCTION_MAX
- WINDOW_FUNCTION_MIN
- WINDOW_FUNCTION_COUNT
- WINDOW_FUNCTION_RANK
- WINDOW_FUNCTION_DENSE_RANK
- WINDOW_FUNCTION_FIRST_VALUE
- WINDOW_FUNCTION_LAST_VALUE
- WINDOW_FUNCTION_LEAD
- WINDOW_FUNCTION_LAG
- WINDOW_FUNCTION_ROW_NUMBER
- WINDOW_FUNCTION_NTILE
- WINDOW_FUNCTION_WINDOW_FUNNEL
- IP Functions
- Vector Distance Functions
- CAST
- DIGITAL_MASKING
- WIDTH_BUCKET
- Array Functions
- SQL Reference
- Cluster management
- Account Management
- Database Administration
- ADMIN-SHOW-CONFIG
- ADMIN-SET-CONFIG
- SET-VARIABLE
- INSTALL-PLUGIN
- UNINSTALL-PLUGIN
- ADMIN-SET-REPLICA-STATUS
- ADMIN-SET-REPLICA-VERSION
- ADMIN-SET-PARTITION-VERSION
- ADMIN-SET-TABLE-STATUS
- ADMIN-SHOW-REPLICA-DISTRIBUTION
- ADMIN-SHOW-REPLICA-STATUS
- ADMIN-REPAIR-TABLE
- ADMIN-CANCEL-REPAIR
- ADMIN-CHECK-TABLET
- ADMIN DIAGNOSE TABLET
- ADMIN-COPY-TABLET
- ADMIN SHOW TABLET STORAGE FORMAT
- ADMIN-CLEAN-TRASH
- RECOVER
- KILL
- ADMIN-REBALANCE-DISK
- ADMIN-CANCEL-REBALANCE-DISK
- ENABLE FEATURE
- Data Types
- DDL
- DML
- 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-LOAD
- SHOW-CREATE-REPOSITORY
- 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-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-workload-GROUPS
- SHOW-PARTITIONS
- SHOW-FRONTENDS
- SHOW-FRONTENDS-DISKS
- 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
- SHOW-QUERY-STATS
- Operators
- Utility
- SQL Functions
- Admin Manual
- cluster management
- Data Admin
- Sql Interception
- Statistics of query execution
- TLS certificate
- FE SSL certificate
- Maintenance and Monitor
- Memory Management
- Config
- User Privilege and Ldap
- System Table
- WORKLOAD GROUP
- Multi-tenancy
- HTTP API
- FE
- Config Action
- HA Action
- Hardware Info Action
- Help Action
- Log Action
- Login Action
- Logout Action
- Query Profile Action
- Session Action
- System Action
- Colocate Meta Action
- Meta Action
- Cluster Action
- Node Action
- Query Profile Action
- Backends Action
- Bootstrap Action
- Cancel Load Action
- Check Decommission Action
- Check Storage Type Action
- Connection Action
- Extra Basepath Action
- Fe Version Info Action
- Get DDL Statement Action
- Get Load Info Action
- Get Load State
- Get FE log file
- Get Small File Action
- Health Action
- Meta Info Action
- Meta Replay State Action
- Metrics Action
- Profile Action
- Query Detail Action
- Query Schema Action
- Query Stats Action
- Row Count Action
- Set Config Action
- Show Data Action
- Show Meta Info Action
- Show Proc Action
- Show Runtime Info Action
- Show Table Data Action
- Statement Execution Action
- Table Query Plan Action
- Table Row Count Action
- Table Schema Action
- Upload Action
- Import Action
- Meta Info Action
- Debug Point
- Statistic Action
- BE
- Check Stub Cache
- Reset Stub Cache
- View Compaction Status
- Manually Trigger Compaction
- View Meta
- Make Snapshot
- Check All Tablet Segment Lost
- Config of BE
- Metrics
- View Tablet Distribution
- Migration Tablet
- View Tablet Info
- Checksum
- Download Log about Load Error
- Pad Rowset
- Be Version Info
- Check Alive
- Reload Tablet
- Restore Tablet
- FE
- FAQ
- Benchmark
- Release notes
暂无相关搜索结果！
本文档使用 WanXiangYunDang 构建
