1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
0
When using the Amazon Athena UNLOAD command, it uses the default serializer LazySimpleSerDe. This serializer outputs empty values as Null, like you are experiencing, and cannot be changed.
One option is to specify each column in your select that you do not want to output to null and use a function to transform nulls. This would be instead of doing a SELECT *
.
For example:
UNLOAD (SELECT col1, COALESCE(col2,'') FROM table)
TO 's3://my_athena_data_location/my_folder/'
WITH (format = 'JSON')
References:
beantwortet vor 7 Monaten
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren