ca5
3/23/2018 - 3:32 AM
iso8601
hive, presto で iso8601のtimestampを扱う
# https://reboooot.net/post/covert-from-iso8601/
#hive
from_unixtime(unix_timestamp('2018-03-12T21:00:00+09:00', "yyyy-MM-dd'T'HH:mm:ssX"), 'yyyy-MM-dd')hive, presto で iso8601のtimestampを扱う
# https://reboooot.net/post/covert-from-iso8601/
#hive
from_unixtime(unix_timestamp('2018-03-12T21:00:00+09:00', "yyyy-MM-dd'T'HH:mm:ssX"), 'yyyy-MM-dd')