程序员小挽的博客

impala中cast函数转换数据类型//decimal 保留两位小数SELECT CAST('123' AS DECIMAL(10,2)) --123.00//decimal 默认为decimal(9,0)SELECT CAST(123.02 as DECIMAL) --123//bigintSELECT CAST(123.123 AS BIGINT) --123//stringSELECT CAST(123.123 AS STRING)

#impala日期格式转换##获取当前日期//获取当前日期select from_unixtime(unix_timestamp(),'yyyy-MM-dd') from tableName；##日期格式化//格式化日期select from_unixtime(unix_timestamp('2021-11-12 11:12:11'),'yyyy-MM-dd') from tableName;select from_unixtime(unix_timestamp(t1.column),'y