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