[TOC] # 行轉列 創建表 ~~~ hive (db1)> create table person_info( > name string, > constellation string, > blood_type string) > row format delimited fields terminated by "\t"; ~~~ 數據 ~~~ 孫悟空 白羊座 A 大海 射手座 A 康師傅 白羊座 B 豬八戒 白羊座 A 鳳姐 射手座 A ~~~ 導入數據 ~~~ load data local inpath "/root/study/person_info.tsv" into table person_info; ~~~ sql ~~~ select t1.base, concat_ws('|', collect_set(t1.name)) name from ( select name, concat(constellation, ",", blood_type) base from person_info ) t1 group by t1.base; ~~~