I am using the select into s3 functionality. Some fields are being exported as ‘\N’. These are null fields. Is there a way to control the representation of NULLs when exporting? Ideally report nothing between the delimiters?
select * from t
into S3 ‘mybucket’
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
This is currently not supported, though we have a feature request tracking adding it. For now, you can use
IFNULL(expr, <null_val>) to replace NULLs with how you want them to be represented in your export.
thanks for letting me know
I am facing the same issue today, although I’m writing into Azure rather than S3.
Could you update on the feature request?