Select into s3 NULL specification

Help Procedural SQL
1

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’
CONFIG ‘’
CREDENTIALS ‘’
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’

1 Like
2

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.

1 Like
3

thanks for letting me know

4

Hi guys,
I am facing the same issue today, although I’m writing into Azure rather than S3.

Could you update on the feature request?

Thanks