- 产品简介
- 购买指南
- 快速入门
- 操作指南
- 开发指南
- 客户端访问
- 实践教程
- SQL 语法
- SuperSQL 语法
- SuperSQL 语法概览
- 统一语法
- 常用数据类型
- DDL 语法
- CREATE DATABASE
- SHOW DATABASES
- DESCRIBE DATABASE
- ALTER DATABASE
- DROP DATABASE
- CREATE TABLE
- REPLACE TABLE AS SELECT
- SHOW TABLES
- SHOW CREATE TABLE
- SHOW TBLPROPERTIES
- DESCRIBE TABLE
- SHOW COLUMNS IN TABLE
- ALTER TABLE
- ALTER TABLE ADD COLUMNS
- ALTER TABLE ADD COLUMN AFTER/FIRST
- ALTER TABLE DROP COLUMN
- ALTER TABLE ADD PARTATION
- SHOW PARTITIONS
- ALTER TABLE DROP PARTITION
- ALTER TABLE ADD PARTITION FIELD
- ALTER TABLE DROP PARTITION FIELD
- ALTER TABLE ... RENAME COLUMN
- ALTER TABLE SET TBLPROPERTIES
- ALTER TABLE SET LOCATION
- ALTER TABLE ... WRITE ORDERED BY
- ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
- ALTER TABLE ... SET IDENTIFIER FIELDS
- ALTER TABLE ... DROP IDENTIFIER FIELDS
- MSCK REPAIR TABLE
- ANALYZE TABLES
- DROP TABLE
- EXPLAIN
- CALL STATEMENT
- CREATE VIEW AS
- SHOW VIEWS
- DESCRIBE VIEW
- SHOW CREATE VIEW
- SHOW COLUMNS IN VIEW
- ALTER VIEW
- DROP VIEW
- CREATE FUNCTION
- SHOW FUNCTION
- DROP FUNCTION
- DML 语法
- DQL 语法
- Iceberg 表语法
- 物化视图语法
- SQL 隐式转换
- 函数
- 标准 Spark 语法概览
- 标准 Presto 语法概览
- 保留字
- SuperSQL 语法
- API 文档
- History
- Introduction
- API Category
- Making API Requests
- Data Table APIs
- Task APIs
- CreateSparkSessionBatchSQL
- CancelSparkSessionBatchSQL
- CancelTask
- CreateResultDownload
- CreateSparkAppTask
- CreateTask
- CreateTasks
- DeleteSparkApp
- DescribeEngineUsageInfo
- DescribeResultDownload
- DescribeSparkAppTasks
- DescribeTaskResult
- DescribeTasks
- QueryTaskCostDetail
- CreateSparkApp
- DescribeSparkAppJob
- DescribeSparkSessionBatchSqlLog
- ModifySparkApp
- DescribeSparkAppJobs
- ModifySparkAppBatch
- DescribeTaskStatistics
- DescribeQuery
- DescribeJobs
- DescribeJob
- Metadata APIs
- Service Configuration APIs
- CreateCHDFSBindingProduct
- DeleteCHDFSBindingProduct
- DescribeOtherCHDFSBindingList
- CreateStoreLocation
- DescribeStoreLocation
- ModifyDataEngineDescription
- RollbackDataEngineImage
- SwitchDataEngine
- SwitchDataEngineImage
- UpgradeDataEngineImage
- DeleteThirdPartyAccessUser
- DescribeDataEngineImageVersions
- DescribeSubUserAccessPolicy
- DescribeThirdPartyAccessUser
- RegisterThirdPartyAccessUser
- RestartDataEngine
- UpdateUserDataEngineConfig
- UpdateDataEngineConfig
- Permission Management APIs
- AddUsersToWorkGroup
- AttachUserPolicy
- AttachWorkGroupPolicy
- BindWorkGroupsToUser
- CreateUser
- CreateWorkGroup
- DeleteUser
- DeleteUsersFromWorkGroup
- DeleteWorkGroup
- DescribeUserInfo
- DescribeUserRoles
- DescribeUserType
- DescribeUsers
- DescribeWorkGroupInfo
- DescribeWorkGroups
- DetachUserPolicy
- DetachWorkGroupPolicy
- ModifyUser
- ModifyUserType
- ModifyWorkGroup
- UnbindWorkGroupsFromUser
- UpdateRowFilter
- CheckGrantedPermission
- Database APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- Data Types
- Error Codes
- 通用类参考
- DLC 政策
- 服务等级协议
- 联系我们
- 产品简介
- 购买指南
- 快速入门
- 操作指南
- 开发指南
- 客户端访问
- 实践教程
- SQL 语法
- SuperSQL 语法
- SuperSQL 语法概览
- 统一语法
- 常用数据类型
- DDL 语法
- CREATE DATABASE
- SHOW DATABASES
- DESCRIBE DATABASE
- ALTER DATABASE
- DROP DATABASE
- CREATE TABLE
- REPLACE TABLE AS SELECT
- SHOW TABLES
- SHOW CREATE TABLE
- SHOW TBLPROPERTIES
- DESCRIBE TABLE
- SHOW COLUMNS IN TABLE
- ALTER TABLE
- ALTER TABLE ADD COLUMNS
- ALTER TABLE ADD COLUMN AFTER/FIRST
- ALTER TABLE DROP COLUMN
- ALTER TABLE ADD PARTATION
- SHOW PARTITIONS
- ALTER TABLE DROP PARTITION
- ALTER TABLE ADD PARTITION FIELD
- ALTER TABLE DROP PARTITION FIELD
- ALTER TABLE ... RENAME COLUMN
- ALTER TABLE SET TBLPROPERTIES
- ALTER TABLE SET LOCATION
- ALTER TABLE ... WRITE ORDERED BY
- ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
- ALTER TABLE ... SET IDENTIFIER FIELDS
- ALTER TABLE ... DROP IDENTIFIER FIELDS
- MSCK REPAIR TABLE
- ANALYZE TABLES
- DROP TABLE
- EXPLAIN
- CALL STATEMENT
- CREATE VIEW AS
- SHOW VIEWS
- DESCRIBE VIEW
- SHOW CREATE VIEW
- SHOW COLUMNS IN VIEW
- ALTER VIEW
- DROP VIEW
- CREATE FUNCTION
- SHOW FUNCTION
- DROP FUNCTION
- DML 语法
- DQL 语法
- Iceberg 表语法
- 物化视图语法
- SQL 隐式转换
- 函数
- 标准 Spark 语法概览
- 标准 Presto 语法概览
- 保留字
- SuperSQL 语法
- API 文档
- History
- Introduction
- API Category
- Making API Requests
- Data Table APIs
- Task APIs
- CreateSparkSessionBatchSQL
- CancelSparkSessionBatchSQL
- CancelTask
- CreateResultDownload
- CreateSparkAppTask
- CreateTask
- CreateTasks
- DeleteSparkApp
- DescribeEngineUsageInfo
- DescribeResultDownload
- DescribeSparkAppTasks
- DescribeTaskResult
- DescribeTasks
- QueryTaskCostDetail
- CreateSparkApp
- DescribeSparkAppJob
- DescribeSparkSessionBatchSqlLog
- ModifySparkApp
- DescribeSparkAppJobs
- ModifySparkAppBatch
- DescribeTaskStatistics
- DescribeQuery
- DescribeJobs
- DescribeJob
- Metadata APIs
- Service Configuration APIs
- CreateCHDFSBindingProduct
- DeleteCHDFSBindingProduct
- DescribeOtherCHDFSBindingList
- CreateStoreLocation
- DescribeStoreLocation
- ModifyDataEngineDescription
- RollbackDataEngineImage
- SwitchDataEngine
- SwitchDataEngineImage
- UpgradeDataEngineImage
- DeleteThirdPartyAccessUser
- DescribeDataEngineImageVersions
- DescribeSubUserAccessPolicy
- DescribeThirdPartyAccessUser
- RegisterThirdPartyAccessUser
- RestartDataEngine
- UpdateUserDataEngineConfig
- UpdateDataEngineConfig
- Permission Management APIs
- AddUsersToWorkGroup
- AttachUserPolicy
- AttachWorkGroupPolicy
- BindWorkGroupsToUser
- CreateUser
- CreateWorkGroup
- DeleteUser
- DeleteUsersFromWorkGroup
- DeleteWorkGroup
- DescribeUserInfo
- DescribeUserRoles
- DescribeUserType
- DescribeUsers
- DescribeWorkGroupInfo
- DescribeWorkGroups
- DetachUserPolicy
- DetachWorkGroupPolicy
- ModifyUser
- ModifyUserType
- ModifyWorkGroup
- UnbindWorkGroupsFromUser
- UpdateRowFilter
- CheckGrantedPermission
- Database APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- Data Types
- Error Codes
- 通用类参考
- DLC 政策
- 服务等级协议
- 联系我们
数据湖计算 DLC 支持通过统一函数在不同内核使用，同时兼容 Spark、Presto，具体函数及支持的内核可参见下表。
数据湖计算 DLC 同时支持 Presto 的内置函数，支持列表及开启方式可参见 Presto 内置函数。
函数 | Spark | Presto |
ABS | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：与入参一致 | 出参： double |
ACOS | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
ACOSH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
ADD_MONTHS | 入参：date|timestamp|string, int | 入参：date|timestamp|string, int |
| 出参：date | 出参：date |
AES_DECRYPT | - | 入参：(binary, string|binary) |
| | 出参： binary |
AES_ENCRYPT | - | 入参：(string|binary, string|binary) |
| | 出参： binary |
AND | 入参：boolean AND boolean | boolean AND boolean |
| 出参：boolean | 出参：boolean |
ANY | 入参：boolean | 入参：boolean |
| 出参：boolean | 出参：boolean |
ANY_MATCH | 入参：(array<T>, lambda function) | - |
| 出参：boolean | |
APPROX_COUNT_DISTINCT | 入参：(bigint|double|decimal|date|timestamp, | - |
| | double|array<double>[, bigint]) |
| | 出参：与第二个输入参数相同 |
APPROX_PERCENTILE | 入参：(bigint|double|decimal|, array<double>|double[, int]) | 入参：(bigint|double|decimal, double[, int]) |
| 出参：double|array | 出参：double|array |
ARG_MAX | 入参：（col1, col2 | expr(col2)） | - |
| 出参：col2或expr(col2)的类型 | |
ARG_MIN | 入参：（col1, col2 | expr(col2)） | |
| 出参：col2或expr(col2)的类型 | |
ARRAY | 入参：(T, ...) | 入参：(T, ...) |
| 出参：array<T> | 出参：array<T> |
ARRAYS_OVERLAP | 入参：(array<T>, array<T>) | 入参：(array<T>, array<T>) |
| 出参：boolean | 出参：boolean |
ARRAYS_ZIP | 入参：(array<T>, array< U> , ...) | - |
| | 出参：array<struct<T, U, ...>> |
ARRAY_CONTAINS | 入参：(array<T>, T) | 入参：(array<T>, T) |
| 出参：boolean | 出参：boolean |
ARRAY_DISTINCT | 入参：array<T> | 入参：array<T> |
| 出参：array<T> | 出参：array<T> |
ARRAY_EXCEPT | 入参：(array<T>, array<T>) | 入参：(array<T>, array<T>) |
| 出参：array<T> | 出参：array<T> |
ARRAY_INTERSECT | 入参：(array<T>, array<T>) | 入参：(array<T>, array<T>) |
| 出参：array<T> | 出参：array<T> |
ARRAY_JOIN | 入参：(array<T>, string[, string]) | 入参：(array<T>, string[, string]) |
| 出参：string | 出参：string |
ARRAY_MAX | 入参：array<bigint|double|decimal> | 入参：array<bigint|double|decimal> |
| 出参：bigint|double|decimal | 出参：bigint|double|decimal |
ARRAY_MIN | 入参：array<bigint|double|decimal> | 入参：array<bigint|double|decimal> |
| 出参：bigint|double|decimal | 出参：bigint|double|decimal |
ARRAY_POSITION | 入参：(array<T>, bigint) | 入参：(array<T>, bigint) |
| 出参：bigint | 出参：bigint |
ARRAY_REMOVE | 入参：(array<T>, T) | 入参：(array<T>, T) |
| 出参：array<T> | 出参：array<T> |
ARRAY_REPEAT | 入参：(array<T>, bigint) | 入参：(array<T>, bigint) |
| 出参：array<T> | 出参：array<T> |
ARRAY_SORT | 入参：(array<T>, function(T, T)->integer) | 入参：(array<T>) |
| 出参：array<T> | 出参：array<T> |
ARRAY_UNION | 入参：(array<T>, array<T>) | 入参：(array<T>, array<T>) |
| 出参：array<T> | 出参：array<T> |
ASCII | 入参：string | 入参：string |
| 出参：int | 出参：int |
ASIN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
ASINH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
ASSERT_TRUE | 入参：boolean | 入参：boolean |
| 出参：null|抛出异常 | 出参：null|抛出异常 |
ATAN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
ATAN2 | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：double | 出参：double |
ATANH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
AVG | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
BASE64 | 入参：string|binary | 入参：binary |
| 出参：string | 出参： string |
BIGINT | 强制类型转换为bigint | 强制类型转换为bigint |
BIN | 入参：bigint | 入参：bigint |
| 出参：string | 出参： string |
BINARY | 强制类型转换为 binary | 强制类型转换为 binary |
BIT_AND | 入参：int | 入参：int |
| 出参：int | 出参：int |
BIT_COUNT | 入参：int|boolean | 入参：int|boolean |
| 出参：int | 出参：int |
BIT_GET | 入参：(int, int) | 入参：(int, int) |
| 出参：int | 出参：int |
BIT_LENGTH | 入参：string | 入参：string |
| 出参：int | 出参：int |
BIT_OR | 入参：int | 入参：int |
| 出参：int | 出参：int |
BIT_XOR | 入参：int | 入参：int |
| 出参：int | 出参：int |
BOOLEAN | 强制类型转换为 boolean | 强制类型转换为 boolean |
BOOL_AND | 入参：boolean | 入参：boolean |
| 出参：boolean | 出参：boolean |
BOOL_OR | 入参：boolean | 入参：boolean |
| 出参：boolean | 出参：boolean |
BROUND | 入参：(bigint|double|decimal, int) | 入参：(bigint|double|decimal, int) |
| 出参：int | 出参：int |
BTRIM | 入参：(string[, string]) | 入参：(string[, string]) |
| 出参：string | 出参：string |
CARDINALITY | 入参：(array|map) | 入参：(array|map) |
| 出参：int | 出参：int |
CAST | 入参：(<expr> AS T) | 入参：(<expr> AS T) |
| 出参：T | 出参：T |
CBRT | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
CEIL | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：bigint | 出参：bigint |
CEILING | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：bigint | 出参：bigint |
CHAR | 入参：int | 入参：int |
| 出参：string | 出参：string |
CHARACTER_LENGTH | 入参：string|binary | 入参：string |
| 出参：int | 出参：int |
CHAR_LENGTH | 入参：string|binary | 入参：string |
| 出参：int | 出参：int |
CHR | 入参：int|double | 入参：int|double |
| 出参：string | 出参： string |
CLUSTER_SAMPLE | 入参：（bigint [, bigint]） | - |
| 出参：boolean | |
COALESCE | 入参：(T, T, ...) | 入参：(T, T, ...) |
| 出参：T | 出参：T |
COLLECT_LIST | 入参：T | 入参：T |
| 出参：array<T> | 出参： array<T> |
COLLECT_SET | 入参：T | 入参：T |
| 出参：array<T> | 出参： array<T> |
CONCAT | 入参：string|array | 入参(string|binary, string|binary, ...) |
| 出参：与输入参数一致 | 出参：string |
CONCAT_WS | 入参：(string, [string | array<string>]+) | 入参：(string, [string | array<string>]+) |
| 出参：string | 出参：string |
CONTEXT_NGRAMS | - | 入参：(array<array<string>>, array<string>, int, int) |
| | 出参：array<struct<string, double>> |
CONV | 入参：(bigint|double|decimal|string, int, int) | 入参：(bigint|double|decimal|string, int, int) |
| 出参：string | 出参： string |
CORR | 入参：bigint|double|decimal, | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
| 出参：double | |
COS | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
COSH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
COT | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
COUNT | 入参：T | 入参：T |
| 出参：bigint | 出参： bigint |
COUNT_IF | 入参：boolean | - |
| | 出参：int |
COUNT_MIN_SKETCH | 入参：(int|binary|string, double, double, int) | - |
| | 出参：binary |
COVAR_POP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
COVAR_SAMP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
CRC32 | 入参：string|binary | 入参：string|binary |
| 出参：bigint | 出参：bigint |
CUME_DIST | 入参：无 | 入参：无 |
| 出参：double | 出参：double |
CURRENT_CATALOG | 入参：无 | - |
| | 出参：string |
CURRENT_DATABASE | 入参：无 | - |
| 出参：string | |
CURRENT_DATE | 入参：无 | 入参：无 |
| 出参：date | 出参：date |
CURRENT_TIMESTAMP | 入参：无 | 入参：无 |
| 出参：timestamp | 出参：timestamp |
CURRENT_TIMEZONE | 入参：无 | 入参：无 |
| 出参：string | 出参：string |
CURRENT_USER | 入参：无 | 入参：无 |
| 出参：string | 出参：string |
DATE | 入参：string | 入参：string |
| 出参：date | 出参：date |
DATEDIFF | 入参：(string|timestamp|date, string|timestamp|date) | 入参：(string|timestamp|date, string|timestamp|date) |
| 出参：int | 出参：int |
DATE_ADD | 入参：(string|date|timestamp, int) | 入参：(string|date|timestamp, int) |
| 出参：date | 出参： date |
DATEADD | 入参：(date/timestamp, int, string) | - |
| 出参：timestamp | |
DATE_FORMAT | 入参：(string|date|timestamp, string) | 入参：(string|date|timestamp, string) |
| 出参：string | 出参：string |
DATE_FROM_UNIX_DATE | 入参：int | 入参：int |
| 出参：date | 出参：date |
DATE_PART | 入参：(string, string|date|timestamp) | 入参：(string, string|date|timestamp) |
| 出参：bigint|double|decimal | 出参：bigint|double|decimal |
DATE_SUB | 入参：(string|date|timestamp) | 入参：(string|date|timestamp) |
| 出参：date | 出参：date |
DATE_TRUNC | 入参：(string, string) | 入参：(string, string) |
| 出参：timestamp | 出参：timestamp |
DAY | 入参：string|timestamp|date | 入参：string|timestamp|date |
| 出参：int | 出参：int |
DAYOFMONTH | 入参：string|timestamp|date | 入参：string|timestamp|date |
| 出参：int | 出参：int |
DAYOFWEEK | 入参：string|timestamp|date | string|timestamp|date |
| 出参：int | 出参：int |
DAYOFYEAR | 入参：string|timestamp|date | string|timestamp|date |
| 出参：int | 出参：int |
DECIMAL | cast as decimal | cast as decimal |
DECODE | 入参：(binary, string) | (int, int, string[, int, string]...[, default]) | 入参：(binary, string) |
| 出参： | 出参： string |
DEGREES | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
DENSE_RANK | 入参：无 | 入参：无 |
| 出参：int | 出参：int |
DIV | 入参：bigint|double|decimal | - |
| | 出参：int |
DOUBLE | cast as double | cast as double |
E | 入参：无 | 入参：无 |
| 出参：double | 出参：double |
ELEMENT_AT | 入参：(array|map, int) | 入参：(array, int) |
| 出参：与array元素|map value一致 | 出参：与array元素一致 |
ELT | 入参：(int, T, U,...) | 入参：(int, string, string, ...) |
| 出参：依输入而定 | 出参： string |
ENCODE | 入参：(string|binary, string) | 入参：(string, string) |
| 出参：binary | 出参： binary |
EVERY | 入参：T | 入参：T |
| 出参：boolean | 出参：boolean |
EXP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
EXPLODE | 入参：array<T> | - |
| | 出参：T |
EXPLODE_OUTER | 入参：array<T> | - |
| | 出参：T |
EXPM1 | 入参：bigint|double|decimal | - |
| | 出参：double |
FACTORIAL | 入参：int | 入参：int |
| 出参：bigint | 出参： bigint |
FIELD | - | 入参：(T, T, T, ...) |
| | 出参：int |
FIND_IN_SET | 入参：(string, string) | 入参：(string, string) |
| 出参：int | 出参：int |
FIRST_VALUE | 入参：(T[, boolean]) | - |
| | 出参：T |
FLATTEN | 入参：array<array<T>> | 入参：array<array<T>> |
| 出参：array<T> | 出参：array<T> |
FLOAT | cast as float | cast as float |
FLOOR | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：bigint | 出参：bigint |
FORMAT_NUMBER | 入参：(bigint|double|decimal, int|string) | 入参：(bigint|double|decimal, int) |
| 出参：string | 出参：string |
FORMAT_STRING | 入参：(string, T, ...) | 入参：(string, T, ...) |
| 出参：string | 出参：string |
FROM_CSV | 入参：(string, string[, map]) | - |
| | 出参：struct |
FROM_JSON | 入参：(string, string[, map]) | - |
| | 出参：struct |
FROM_UNIXTIME | 入参：(bigint[, string]) | 入参：(bigint[, string]) |
| 出参：string | 出参：string |
FROM_UTC_TIMESTAMP | 入参：(string, string) | 入参：(bigint|double|decimal|timestamp|date|string, string) |
| 出参：timestamp | 出参： timestamp |
GETBIT | 入参：(int, int) | 入参：(int, int) |
| 出参：int | 出参：int |
GET_IDCARD_AGE | 入参：string | - |
| 出参：int | |
GET_IDCARD_BIRTHDAY | 入参：string | - |
GET_IDCARD_BIRTHDAY | 出参：date | - |
GET_IDCARD_SEX | 入参：string | - |
| 出参：string | |
GREATEST | 入参：(bigint|double|decimal, bigint|double|decimal, ...) | 入参：(bigint|double|decimal, bigint|double|decimal, ...) |
| 出参：与输入一致 | 出参：与输入一致 |
GROUPING | 入参：T | T |
| 出参：int | 出参：int |
GROUPING_ID | 入参：[T[, T...]] | - |
| | 出参：int |
HASH | 入参：(T, T,...) | 入参：(T, T,...) |
| 出参：int | 出参：int |
HEX | 入参：int|string|binary | 入参：int|string|binary |
| 出参：string | 出参：string |
HISTOGRAM_NUMERIC | - | 入参：bigint|double|decimal |
| | 出参：array<struct<'x', 'y'>> |
HOUR | 入参：string|timestamp | 入参：string|timestamp |
| 出参：int | 出参：int |
HYPOT | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
IF | 入参：(boolean, T, T) | 入参：(boolean, T, T) |
| 出参：T | 出参：T |
IFNULL | 入参：(T, U) | - |
| | 出参：T|U |
IN | 入参：(T, T,...) | 入参：(T, T,...) |
| 出参：boolean | 出参：boolean |
INITCAP | 入参：string | 入参：string |
| 出参：string | 出参：string |
INLINE | 入参：array | - |
| | 出参：table |
INLINE_OUTER | 入参：array | - |
| | 出参：table |
INPUT_FILE_BLOCK_LENGTH | 入参：无 | - |
| | 出参：int |
INPUT_FILE_BLOCK_START | 入参：无 | - |
| | 出参：int |
INPUT_FILE_NAME | 入参：无 | - |
| | 出参：string |
INSTR | 入参：(string, string) | 入参：(string, string) |
| 出参：int | 出参：int |
INT | 强制类型转换为 int | 强制类型转换为 int |
ISNAN | 入参：T | 入参：T |
| 出参：boolean | 出参：boolean |
ISNOTNULL | 入参：T | 入参：T |
| 出参：boolean | 出参：boolean |
ISNULL | 入参：T | 入参：T |
| 出参：boolean | 出参：boolean |
JSON_ARRAY_LENGTH | 入参：string | 入参：string |
| 出参：int | 出参：int |
JSON_OBJECT_KEYS | 入参：string | 入参：string |
| 出参：array | 出参：array |
JSON_TUPLE | 入参：(string, ..., string) | - |
| | 出参：string...string |
KEYVALUE | 入参：(string [, string, string], string) | |
| 出参：string | |
KURTOSIS | 入参：bigint|double|decimal | - |
| | 出参：double |
LAG | 入参：(T[, int[, string]]) | 入参：(T[, int[, string]]) |
| 出参: T | 出参：T |
LAST_DAY | 入参：string|date|timestamp | 入参：string|date|timestamp |
| 出参：string | 出参：string |
LAST_VALUE | 入参：(T[, boolean]) | - |
| | 出参：T |
LCASE | 入参：string | 入参：string |
| 出参：string | 出参：string |
LEAD | 入参：(T[, int[, string]]) | 入参：(T[, int[, string]]) |
| 出参：T | 出参：T |
LEAST | 入参：(bigint|double|decimal, bigint|double|decimal, ...) | (bigint|double|decimal, bigint|double|decimal, ...) |
| 出参：与输入一致 | 出参：与输入一致 |
LEFT | 入参：(string, int) | 入参：(string, int) |
| 出参：string | 出参：string |
LENGTH | 入参：string | 入参：string |
| 出参：int | 出参：int |
LEVENSHTEIN | 入参：(string, string) | 入参：(string, string) |
| 出参：int | 出参：int |
LIKE | 入参：(string, string) | string LIKE string ESCAPE string | 入参：(string, string) |
| 出参：boolean | 出参：boolean |
LN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
LOCATE | 入参：(string, string[, int]) | 入参：(string, string[, int]) |
| 出参：int | 出参：int |
LOG | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：double | 出参：double |
LOG10 | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
LOG1P | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
LOG2 | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
LOWER | 入参：string | 入参：string |
| 出参：string | 出参：string |
LPAD | 入参：(string, int[, string]) | 入参：(string, int, string) |
| 出参：string | 出参：string |
LTRIM | 入参：string | 入参：string |
| 出参：string | 出参：string |
MAKE_DATE | 入参：(int, int, int) | 入参：(int, int, int) |
| 出参：date | 出参：date |
MAKE_TIMESTAMP | 入参：(int, int, int, int, int, int[, string]) | 入参：(int, int, int, int, int, int[, string]) |
| 出参：timestamp | 出参：timestamp |
MAP | 入参：(K1, V1, K2, V2,...) | 入参：(array<K>, array<V>) |
| 出参：map | 出参：map |
MAP_CONCAT | 入参：(map, ...) | 入参：(map, ...) |
| 出参：map | 出参：map |
MAP_ENTRIES | 入参：map | 入参：map |
| 出参：array | 出参：array |
MAP_FROM_ARRAYS | 入参：(array, array) | 入参：(array, array) |
| 出参：map | 出参：map |
MAP_FROM_ENTRIES | 入参：array | 入参：array |
| 出参：map | 出参：map |
MAP_KEYS | 入参：map | 入参：map |
| 出参：array | 出参：array |
MAP_UINON_SUM | 入参：map | - |
| 出参：map | |
MAP_VALUES | 入参：map | 入参：map |
| 出参：array | 出参：array |
MAX | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：与入参一致 | 出参： double |
MAX_BY | 入参：T, bigint|double|decimal | 入参：T, bigint|double|decimal |
| 出参：T | 出参：T |
MAX_PT | 入参：const string | - |
| 出参: string | |
MD5 | 入参：string|binary | 入参：string|binary |
| 出参：string | 出参： string |
MEAN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
MIN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：与入参一致 | 出参： double |
MINUTE | 入参：(stirng|timestamp) | 入参：(stirng|timestamp) |
| 出参：int | 出参：int |
MIN_BY | 入参：(T, bigint|double|decimal) | 入参：(T, bigint|double|decimal) |
| 出参：T | 出参：T |
MOD | 入参：(bigint|double|decimal, bigint|double|decimal) | bigint|double|decimal MOD bigint|double|decimal | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：int|double | 出参：int|double |
MONOTONICALLY_INCREASING_ID | 入参：无 | - |
| | 出参：bigint |
MONTH | 入参：date|timestamp|string | 入参：date|timestamp|string |
| 出参：int | 出参：int |
MONTHS_BETWEEN | 入参：(date|timestamp|string, date|timestamp|string[, boolean]) | 入参：(date|timestamp|string, date|timestamp|string) |
| 出参：double | 出参：double |
NAMED_STRUCT | 入参：(K1, V1, K2, V2, ...) | - |
| | 出参：struct |
NANVL | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：double | 出参：double |
NEGATIVE | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：bigint|double|decimal | 出参： int | double |
NEXT_DAY | 入参：(string|date|timestamp, string) | 入参：(string|date|timestamp, string) |
| 出参：date | 出参：string |
NGRAMS | - | 入参：(array<array<string>>, int, int, int) |
| | 出参：array<struct<string, double>> |
NOW | 入参：无 | 入参：无 |
| 出参：timestamp | 出参：timestamp |
NTH_VALUE | 入参：(T[, int]) | 入参：(T[, int]) |
| 出参：T | 出参：T |
NTILE | 入参：int | 入参：int |
| 出参：int | 出参： int |
NULLIF | 入参：(T, T) | 入参：(T, T) |
| 出参：T | 出参：T |
NVL | 入参：(T, T) | 入参：(T, T) |
| 出参：T | 出参：T |
NVL2 | 入参：(T, T, T) | 入参：(T, T, T) |
| 出参：T | 出参：T |
OCTET_LENGTH | 入参：string | 入参：string |
| 出参：int | 出参：int |
OR | 入参：expr1 OR expr2 | 入参：expr1 OR expr2 |
| 出参：boolean | 出参：boolean |
OVERLAY | 入参：(string PLACING string FROM int[ FOR int]) | - |
| | 出参： |
PARSE_URL | 入参：(string, string[, string]) | 入参：(string, string[, string]) |
| 出参：string | 出参： string |
PERCENTILE | 入参：(bigint|double|decimal, bigint|double|decimal|array, int) | 入参：(bigint|double|decimal, bigint|double|decimal|array, int) |
| 出参：bigint|double|decimal|array | 出参：double|array |
PERCENTILE_APPROX | 入参：(bigint|double|decimal, bigint|double|decimal | array[, int]) | 入参：(bigint|double|decimal, bigint|double|decimal[, int]) |
| 出参：double|array | 出参：double|array |
PERCENT_RANK | 入参：无 | 入参：无 |
| 出参：double | 出参：double |
PI | 入参：无 | 入参：无 |
| 出参：double | 出参：double |
PMOD | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：与入参一致 | 出参：与入参一致 |
POSITION | 入参：(string, string[, int]) | (string IN string) | 入参：(string, string[, int]) | (string IN string) |
| 出参：int | 出参：int |
POSITIVE | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：与入参一致 | 出参：与入参一致 |
POSEXPLODE | 入参：array | - |
| | 出参：table |
POSEXPLODE_OUTER | 入参：array | - |
| | 出参：table |
POW | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：double | 出参：double |
POWER | 入参：(bigint|double|decimal, bigint|double|decimal) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：double | 出参：double |
PRINTF | 入参：(string, T, ...) | 入参：(string, T, ...) |
| 出参：string | 出参：string |
QUARTER | 入参：string|date|timestamp | 入参：string|date|timestamp |
| 出参：int | 出参：int |
RADIANS | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
RAISE_ERROR | 入参：string | 入参：string |
| 出参：抛出异常 | 出参：抛出异常 |
RAND | 入参：[int] | 入参：[int] |
| 出参：double | 出参：double |
RANDN | 入参：[int] | 入参：[long] |
| 出参：double | 出参：double |
RANDOM | 入参：[int] | 入参：[int] |
| 出参：double | 出参：double |
RANK | 入参：无 | 入参：无 |
| 出参：int | 出参：int |
REGEXP | 入参：(string, string) | 入参：(string, string) |
| 出参：boolean | 出参：boolean |
REGEXP_COUNT | 入参：(string, string) | - |
| 出参：int | |
REGEXP_EXTRACT | 入参：(string, string[, int]) | 入参：(string, string, int) |
| 出参：int | 出参：int |
REGEXP_EXTRACT_ALL | 入参：(string, string[, int]) | 入参：(string, string[, int]) |
| 出参：array | 出参：array |
REGEXP_LIKE | 入参：(string, string) | 入参：(string, string) |
| 出参：boolean | 出参：boolean |
REGEXP_REPLACE | 入参：(string, string, string[, int]) | 入参：(string, string, string) |
| 出参：string | 出参：string |
REGEXP_SUBSTR | 入参：(string, string) | - |
| 出参：string | |
REPEAT | 入参：(string, int) | 入参：(string, int) |
| 出参：string | 出参：string |
REPLACE | 入参：(string, string[, string]) | 入参：(string, string, string) |
| 出参：string | 出参：string |
REVERSE | 入参：string | array | 入参：string |
| 出参：string | 出参：string |
RIGHT | 入参：(string, int) | 入参：(string, int) |
| 出参：string | 出参：string |
RINT | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
RLIKE | 入参：(string, string) | 入参：(string, string) |
| 出参：boolean | 出参：boolean |
ROUND | 入参：(double, int) | 入参：(double, int) |
| 出参：double | 出参：double |
ROW_NUMBER | 入参：无 | 入参：无 |
| 出参：int | 出参：int |
RPAD | 入参：(string, int[, string]) | 入参：(string, int, string) |
| 出参：string | 出参：string |
RTRIM | 入参：string | 入参：string |
| 出参：string | 出参：string |
SAMPLE | 入参：(long [, long [, cols...]]) | - |
| 出参：boolean | |
SCHEMA_OF_CSV | 入参：(string[, map]) | |
| | 出参：struct |
SCHEMA_OF_JSON | 入参：(string[, map]) | - |
| | 出参： |
SECOND | 入参：string|timestamp | 入参：string|timestamp |
| 出参：int | 出参：int |
SENTENCES | (string[, string, string]) | 入参：(string[, string, string]) |
| 出参：array<array<string>> | 出参：array<array<string>> |
SEQUENCE | 入参：(int|bigint|date|timestamp, int|bigint|date|timestamp, int) | 入参：(int|bigint|date|timestamp, int|bigint|date|timestamp, int) |
| 出参：与入参一致 | 出参：与入参一致 |
SHA | 入参：string|binary | 入参：string|binary |
| 出参：string | 出参：string |
SHA1 | 入参：string|binary | 入参：string|binary |
| 出参：string | 出参：string |
SHA2 | 入参：(string, int) | 入参：(string, int) |
| 出参：string | 出参：string |
SHIFTLEFT | 入参：(int|bigint, int) | 入参：(int|biging, int) |
| 出参：int|bigint | 出参：int|bigint |
SHIFTRIGHT | 入参：(int|bigint, int) | 入参：(int|bigint, int) |
| 出参：int|bigint | 出参：int|bigint |
SHIFTRIGHTUNSIGNED | 入参：(int|bigint, int) | 入参：(int|bigint, int) |
| 出参：int|bigint | 出参：int|bigint |
SHUFFLE | 入参：array | 入参：array |
| 出参：array | 出参：array |
SIGN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
SIGNUM | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
SIN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
SINH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
SIZE | 入参：array | map | 入参：array | map |
| 出参：int | 出参：int |
SKEWNESS | 入参：bigint|double|decimal | - |
| | 出参：double |
SLICE | 入参：(array, int, int) | 入参：(array, int, int) |
| 出参：array | 出参：array |
SMALLINT | cast as smallint | cast as smallint |
SOME | 入参：boolean | 入参：boolean |
| 出参：boolean | 出参：boolean |
SORT_ARRAY | 入参：(array[, boolean]) | 入参：array |
| 出参：array | 出参：array |
SOUNDEX | 入参：string | 入参：string |
| 出参：string | 出参：string |
SPACE | 入参：string | 入参：string |
| 出参：string | 出参：string |
SPARK_PARTITION_ID | 入参：无 | - |
| | 出参：int |
SPLIT | 入参：(string, string, int) | 入参：(string, string) |
| 出参：string | 出参：string |
SQRT | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
STACK | 入参：(T, U, ...) | - |
| | 出参：table |
STD | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
STDDEV | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
STDDEV_POP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
STDDEV_SAMP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
STRING | cast as string | cast as string |
STRUCT | 入参：(T, U, ...) | 入参：(T, U, ...) |
| 出参：struct | 出参：struct |
STR_TO_MAP | 入参：(string[, string[, string]]) | 入参：(string[, string, string]) |
| 出参：map | 出参：map |
SUBSTR | 入参：(string, int[, int]) | (string FROM int [FOR int]) | 入参：(string|binary, int[, int]) | (string|binary FROM int [FOR int]) |
| 出参：string | 出参： string |
SUBSTRING | 入参：(string, int[, int]) | (string FROM int [FOR int]) | 入参：(string|binary, int[, int]) | (string|binary FROM int [FOR int]) |
| 出参：string | 出参： string |
SUBSTRING_INDEX | 入参：(string, string, int) | 入参：(string, string, int) |
| 出参：string | 出参：string |
SUM | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：与输入一致 | 出参： double |
TAN | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
TANH | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参：double |
TIMESTAMP | 入参：string | 入参：string |
| 出参：timestamp | 出参：timestamp |
TIMESTAMP_ADD | 入参：（date/timestamp, int, string） | |
| 出参：timestamp | |
TIMESTAMP_MICROS | 入参：bigint | 入参：bigint |
| 出参：timestamp | 出参：timestamp |
TIMESTAMP_MILLIS | 入参：bigint | 入参：bigint |
| 出参：timestamp | 出参：timestamp |
TIMESTAMP_SECONDS | 入参：bigint | 入参：bigint |
| 出参：timestamp | 出参：timestamp |
TIMEZONE_HOUR | 入参：string | - |
| | 出参：int |
TIMEZONE_MINUTE | 入参：string | - |
| | 出参：int |
TINYINT | cast as tinyint | cast as tinyint |
TO_CHAR | 入参：(boolean|int|long|double|decimal [, string]) | |
| 出参：string | |
TO_CSV | 入参：(struct[, map]) | - |
| | 出参：string |
TO_DATE | 入参：(string[, string]) | 入参：string |
| 出参：date | 出参： date |
TO_JSON | 入参：(string[, map]) | - |
| | 出参：string |
TO_TIMESTAMP | 入参：(string[, string]) | 入参：(string) |
| 出参：timestamp | 出参：timestamp |
TO_UNIX_TIMESTAMP | 入参：(string[, string]) | 入参：(string[, string]) |
| 出参：timestamp | 出参：timestamp |
TO_UTC_TIMESTAMP | 入参：(string[, string]) | 入参：(bigint|double|decimal|date|timestamp|string, string) |
| 出参：timestamp | 出参： timestamp |
TRANS_ARRAY | 入参：(int, string, cols...) | - |
| 出参：与cols类型相同 | |
TRANS_COLS | 入参：(int, cols...) | |
| 出参：(int, cols） | |
TRANSLATE | 入参：(string, string, string) | - |
| | 出参：string |
TRIM | 入参：string | 入参：string |
| 出参：string | 出参： string |
TRUNC | 入参：(string|date|timestamp, string) | 入参：(string|date|timestamp, string) |
| 出参：string | 出参： string |
TRY_ADD | 入参：(bigint|double|decimal|date|timestamp|, bigint|double|decimal|date|timestamp) | 入参：(bigint|double|decimal, bigint|double|decimal) |
| 出参：与入参一致 | 出参：与入参一致 |
TRY_DIVIDE | 入参：(bigint|double|decimal, bigint|double|decimal) | - |
| | 出参：double |
TYPEOF | 入参：T | 入参：T |
| 出参：string | 出参：string |
UCASE | 入参：string | 入参：string |
| 出参：string | 出参：string |
UNBASE64 | 入参：string | 入参：string |
| 出参：string | 出参：string |
UNHEX | 入参：string | 入参：string |
| 出参：binary | 出参：binary |
UNIX_DATE | 入参：string|timestamp|date | 入参：string|timestamp|date |
| 出参：int | 出参：int |
UNIX_MICROS | 入参：timestamp | 入参：timestamp |
| 出参：bigint | 出参：bigint |
UNIX_MILLIS | 入参：timestamp | 入参：timestamp |
| 出参：bigint | 出参：bigint |
UNIX_SECONDS | 入参：timestamp | 入参：timestamp |
| 出参：bigint | 出参：bigint |
UNIX_TIMESTAMP | 入参：[date|timestamp|string[, string]] | 入参：(date|timestamp|string[, string]) |
| 出参：bigint | 出参： bigint |
UPPER | 入参：string | 入参：string |
| 出参：string | 出参：string |
URL_DECODE | 入参：string | - |
| 出参：string | |
UUID | 入参：无 | 入参：无 |
| 出参：string | 出参：string |
VARIANCE | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
VAR_POP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
VAR_SAMP | 入参：bigint|double|decimal | 入参：bigint|double|decimal |
| 出参：double | 出参： double |
VERSION | 入参：无 | 入参：无 |
| 出参：string | 出参：string |
WEEKDAY | 入参：date|timestamp|string | 入参：date|timestamp|string |
| 出参：int | 出参：int |
WEEKOFYEAR | 入参：date|timestamp|string | 入参：date|timestamp|string |
| 出参：int | 出参：int |
WIDTH_BUCKET | 入参：(bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int) | 入参：(bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int) |
| 出参：int | 出参：int |
WINDOW | 入参：(date|timestamp, string[, string[, string]]) | - |
| | 出参：table |
XPATH | 入参：(string, string) | 入参：(string, string) |
| 出参：array | 出参：array |
XPATH_BOOLEAN | 入参：(string, string) | 入参：(string, string) |
| 出参：boolean | 出参：boolean |
XPATH_DOUBLE | 入参：(string, string) | 入参：(string, string) |
| 出参：double | 出参：double |
XPATH_FLOAT | 入参：(string, string) | 入参：(string, string) |
| 出参：float | 出参：float |
XPATH_INT | 入参：(string, string) | 入参：(string, string) |
| 出参：int | 出参：int |
XPATH_LONG | 入参：(string, string) | 入参：(string, string) |
| 出参：bigint | 出参：bigint |
XPATH_NUMBER | 入参：(string, string) | 入参：(string, string) |
| 出参：double | 出参：double |
XPATH_STRING | 入参：(string, string) | 入参：(string, string) |
| 出参：string | 出参：string |
XXHASH64 | 入参：(T, U, ...) | 入参：(T, U, ...) |
| 出参：bigint | 出参：bigint |
YEAR | 入参：date|timestamp|string | 入参：date|timestamp|string |
| 出参：int | 出参：int |
是
否
本页内容是否解决了您的问题？