Query arrays

Amazon Athena lets you create arrays, concatenate them, convert them to different data types, and then filter, flatten, and sort them.

Topics

• Create arrays
• Concatenate strings and arrays
• Convert array data types
• Find array lengths
• Access array elements
• Flatten nested arrays
• Create arrays from subqueries
• Filter arrays
• Sort arrays
• Use aggregation functions with arrays
• Convert arrays to strings
• Use arrays to create maps
• Query arrays with complex types