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.