环境:
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
版权声明:本文为gongmf原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。