3 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
I had the same issue and solved that with creating a view and adding some size checks for array columns like this one:
IF(CARDINALITY(my_array_column) = 0, NULL, my_array_column) AS my_array_column
répondu il y a 5 ans
0
I am having the same problem but unfortunately the above suggestion does not work because it appears to happen with nested arrays as well which i cannot check the cardinality of and replace with null if empty without unnesting everything first (if that would even be possible due to multiple struct & array columns and levels of nesting).
répondu il y a 5 ans
0
Admittedly responding to an old question, but a simple solution is to use ORC as format instead of PARQUET (format='ORC'), which doesn't have an issue with empty values.
répondu il y a 3 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- Comment définir le nombre ou la taille des fichiers lorsque j'exécute une requête CTAS dans Athena ?AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 7 mois
- AWS OFFICIELA mis à jour il y a 3 ans