这通常表示Athena不支持查询中使用的一种或多种Hive数据类型。您可以通过以下方式解决此问题:
例如:
DESCRIBE my_table;
以下是展开Hive中的复杂类型的示例代码:
WITH my_table_expanded AS ( SELECT col1, col2, my_array_col.element AS array_element, my_map_col.key AS map_key, my_map_col.value AS map_value FROM my_table CROSS JOIN UNNEST(my_array_col) AS my_array_col(element) CROSS JOIN UNNEST(map_keys(my_map_col)) AS my_map_col(key, value) ) SELECT * FROM my_table_expanded WHERE array_element = 'value' AND map_key = 'key';