Query results in csv file include 'null' string for blank cell

[AlexG]

After running a sql script, when downloading the results to a csv file, the file includes a null string for blank cells (see screenshot). Is ther a setting I can change to simply get empty cells instead?

[jose_gonzalez]

You need to use "emptyValue" when writing you data

df.write.csv(PATH, header=True, emptyValue='')

  Here is a list of APIs references https://spark.apache.org/docs/latest/sql-data-sources-csv.html

[AlexG]

Thank you. How would you download to csv the results from a SQL script without the null strings in empty cells?

I mainly work with SQL notebooks

[NandiniN]

Hi AlexG,

I tested with the table content containing null and with empty data and it works as expected in the download option too.

Here is an eg:

CREATE TABLE my_table_null_test1 (
id INT,
name STRING
);

INSERT INTO my_table_null_test1 (id, name) VALUES
(1, 'John Doe'),
(2, NULL),
(3, 'Jane Doe'),
(NULL, 'Anonymous')
(4, '');

If you do not want nulls, you may have to modify the query to use 

coalesce(NULL, '') or

nvl(NULL, '');

 Hope it helps. Thanks!