- 博客(6)
- 收藏
- 关注
原创 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 1943
原创 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 6804
原创 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 1532
原创 Excel——if函数常用总结
=IF(A1>=10,"10+",IF(A1=IF(AND(I1=1),"1-5","5+")=IF(OR(I1>=10,I1=10,"bb","cc"))
2016-09-21 15:19:56 485
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人