CODEWITHSUNDEEP
hiveimpala
Himanshu Garg
Himanshu Garg

Reputation: 21

Collect list function in hive and impala

I am using 

concat_ws(' ',  collect_list(field1)) as field1,

but the query is not running in impala. Does impala not support this function? If not, what is an alternative for a similar operation in impala?

Upvotes: 1

Views: 6061

Answers (1)

Vijiy
Vijiy

Reputation: 1197

You can use group_concat() function in impala, Plase refer https://www.cloudera.com/documentation/enterprise/5-5-x/topics/impala_group_concat.html

Upvotes: 3

Related Questions