2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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!
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a 9 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an