Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎10-29-2018

Hive Multiselect

[ Edited ]
CID    F_ID    NME
1  A QR
1  B QB
2  A QR
3  B QB
4  A QR
4  B QB

Result: -
CID F_ID NME
1  A QR
1  B QB
4  A QR
4  B QB
Result should only outcome the CID
that fall in both F_ID - A & B, what should be the Hive Query, In oracle we can use LISTAGG Function
Announcements