Querying arrays
Amazon Athena lets you create arrays, concatenate them, convert them to different data types, and then filter, flatten, and sort them.
Topics
- Creating arrays
- Concatenating arrays
- Converting array data types
- Finding lengths
- Accessing array elements
- Flattening nested arrays
- Creating arrays from subqueries
- Filtering arrays
- Sorting arrays
- Using aggregation functions with arrays
- Converting arrays to strings
- Using arrays to create maps
- Querying arrays with complex types and nested structures