2 Answers
- Newest
- Most votes
- Most comments
1
Currently, Redshift Spectrum does not support AVRO nested types. The alternatives would be
-> to un-nest the columns and then query them as primitive types
-> use another format (for example Apache Parquet, Apache ORC, JSON ) that supports nested types with Redshift Spectrum https://aws.amazon.com/about-aws/whats-new/2018/08/amazon-redshift-announces-support-for-nested-data-with-redshift-spectrum/
->Try to ingest the data into Redshift using COPY command https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-format.html#copy-avro
0
Thank you for the answer. Do you know if there are any plans to include avro support in spectrum? Thanks!
answered 3 years ago
Relevant content
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago