1、当某个字段应用了case when条件并且使用了or,且where查询条件的里正好有该字段 对于非group by字段,可以用Hive的collect_set函数收集这些字段,返回一个数组; 使用数字

Amazon.com: Incipio IP-434 HIVE Response C
300x300 - 8KB - JPEG

Amazon.com: Incipio IP-432 HIVE Response C
300x300 - 8KB - JPEG

Amazon.com: Incipio Hive Response Standing
300x300 - 12KB - JPEG

Incipio iPad 4\/ iPad 2 Hive Honeycomb dermaS
190x246 - 5KB - JPEG
Hive Leather Case Black DSi DS Lite Compat
169x225 - 9KB - JPEG
Cute Deluxe Bling Shining 3D Hive Diamond C
224x225 - 11KB - JPEG
ugs Hex Bugs Mega Set Glow Elevation Case
225x225 - 12KB - JPEG

mazon.com: Incipio BlackBerry PlayBook Hive
300x300 - 14KB - JPEG
Cute Deluxe Bling Shining 3D Hive Diamond C
225x225 - 14KB - JPEG
ugs Hex Bugs Mega Set Glow Elevation Case
208x225 - 11KB - JPEG
ugs Hex Bugs Mega Set Glow Elevation Case
225x209 - 8KB - JPEG
hive | Rakuten Global Market: Flight case: KRYS
730x730 - 137KB - JPEG
hive | Rakuten Global Market: Flight case for L L
350x300 - 10KB - JPEG
hive | Rakuten Global Market: Ultima Darts Cas
730x780 - 82KB - JPEG
hive | Rakuten Global Market: STEAL DART ca
730x919 - 91KB - JPEG