环境:
1. hive版本0.13.0
2. 表test_array有数组字段例如:
select c_array from test_array where dt='2016-09-26' and size(c_array)=2 limit 2;
["105750","1246345","907964"]
["935105","359772","935104"]
3.转为字符串:
select concat_ws(',',c_array) from test_array where dt='2016-09-26' and size(c_array)=2 limit 2;
105750,1246345,907964
935105,359772,935104