For example:
The name address
Zhang SAN Shanghai
Li si Shanghai
Fifty and Shanghai


Inquiry into the following format:
The address name
Shanghai [zhang SAN, li si, fifty]


Query name after the form is an array, is there any great god help me think a Hivesql processing, thank you very much

CodePudding user response:

https://www.cnblogs.com/cc11001100/p/9043946.html, baidu know

CodePudding user response:

Select the address, collect_set (name) from tablename group by the address