TOP

hive 关于array的常用操作。[排序][包含]
2018-12-02 17:27:36 】 浏览:647
Tags:hive 关于 array 常用 操作 排序 包含

select count(*) from xxxxxxxx
> lateral view explode(pair) ids_table1 as id1 lateral view explode(pair) ids_table2 as id2

> where year=2016 and month =2 and day =23 and id2.type=68 and id1.type=68 and sort_array(dates)[0]='20160223' limit 3;





select count(*) from xx
lateral view explode(pair) ids_table1 as id1 lateral view explode(pair) ids_table2 as id2
where year='2016' and month='02' and day='23' and id2.type=68 and id1.type=64 and array_contains(dates,'20160223');




hive 关于array的常用操作。[排序][包含] https://www.cppentry.com/bencandy.php?fid=117&id=193275

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇hive 常用运算 下一篇hive 查看某表字段类型