Blank CSV file when Exporting Results

Dremio Cloud
1

I have a couple of queries I am running in Dremio where the query returns results. However, when I click CSV to export the file, the exported file is blank. This is only happening on a couple of queries, not all. The queries are using views we created in Dremio and the views themselves export the data results correctly. It also doesn’t matter if the dataset is small (<100) or large (>10,000).

Anyone know what the issue might be?

2

Hi @nikki.myers ,

Can you confirm if you are using Dremio Cloud or Dremio Software? Additionally, are there any null values in the CSV?

Cindy

3

Actually i just figured it out. Dremio doesn’t like NULL as field_name in the select statement. It has to be ‘’ as field_name if you want to return a blank row.