hadoop - 如何在 impala 或 hive 上读取复杂类型数组 ？

Question

我尝试读取 hive 上的复杂类型

dog.owners (array<string>)

使用以下查询

select dog_id, concat_ws(',',collect_set(owners)) as owners 
from dog 
group by dog_id

但我收到以下错误

Argument 2 of function CONCAT_WS must be "string or array<string>", but "array<array<string>>" was found.

看起来数据类型不匹配。我试图将列所有者创建为 array<array<string>>但我仍然遇到同样的错误。有没有办法阅读关于 hive 或黑斑羚的专栏？

Answer 1

select dog_id, do.* from dog, dog.owners as do