1 Answer
- Newest
- Most votes
- Most comments
0
Try changing "UNNEST(browse_nodes) AS single_browse_node" to "UNNEST(browse_nodes) AS t(single_browse_node)".
It tells Athena to, for each row, flatten the array browse_nodes into a relation called t that has a column called single_browse_node. The alias t is arbitrary.
Relevant content
- asked 9 months ago
- asked 9 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 months ago