Hive
qq_35970254
这个作者很懒,什么都没留下…
展开
-
HiveSQL-get_json_object
从json串中获取所需字段 select get_json_object(ext_info,'$.Type'),get_json_object(ext_info,'$.Amount'),* from aa原创 2016-10-08 20:59:23 · 1522 阅读 · 0 评论 -
HiveSQL-datediff函数
datediff()求两个日期间间隔的函数:datediff(大日期,小日期) datediff(from_unixtime(unix_timestamp(b.partitiontime,'yyyyMMdd')) ,from_unixtime(unix_timestamp(a.partitiontime,'yyyyMMdd'))) and datediff(from_unixtime(unix原创 2016-10-08 21:01:46 · 6706 阅读 · 0 评论 -
HiveSQL-if函数
if函数 select a.partitiontime,if (0 if(50 ,a.from_source,if (a.platform in('android','iPad'原创 2016-10-08 21:16:06 · 1911 阅读 · 0 评论