hive計算時間差

参照先:https://blog.csdn.net/sinat_40431164/article/details/80813978
1、まずString to Date形式
yyyy-MM-dd
to_date(from_unixtime(UNIX_TIMESTAMP(dt,’yyyy-MM-dd’)))
yyyy-MM-dd
 
2、関数の再使用

datediff(to_date(from_unixtime(UNIX_TIMESTAMP( TIME01,'yyyy-MM-dd'))),to_date(from_unixtime(UNIX_TIMESTAMP(TIME02,'yyyy-MM-dd'))))

3、ビューの作成:

create view hive_external_view as
select substring(TIME01,1,7) days ,
TIME01,
TIME02,
datediff(to_date(from_unixtime(UNIX_TIMESTAMP(TIME01,'yyyy-MM-dd'))),to_date(from_unixtime(UNIX_TIMESTAMP(TIME02,'yyyy-MM-dd'))))
as inhosp_sumdays
from hive_external