TOP

hive 關于array的常用操作。[排序][包含]
2018-12-02 17:27:36 】 瀏覽:1406
Tags:

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 常用運算 下一篇hive 查看某表字段類型