impala中cast函数转换数据类型

impala中cast函数转换数据类型

//decimal 保留两位小数
SELECT CAST('123' AS DECIMAL(10,2))    --123.00

//decimal 默认为decimal(9,0)
SELECT CAST(123.02 as DECIMAL)         --123

//bigint
SELECT CAST(123.123 AS BIGINT)         --123

//string
SELECT CAST(123.123 AS STRING)         --123.123

//时间类型
SELECT CAST('2021-11-16' AS TIMESTAMP) --2021-11-16 :00:00:00 00000000