Hive - 常用sql整理

Hive - 常用sql整理

一、实现13位时间戳转毫秒时间类型

select
    concat(t,".",substring(1611231717343,11,13))
from(
    select from_unixtime(cast(substring(1611231717343,0,10) as bigint),'yyyy-MM-dd HH:dd:ss') as t)tmp;