2 Antworten
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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!
beantwortet vor 2 Jahren
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren