I want to generate csv files from Dremio but do not want to set the store.format = csv all the time. Is there any way to dynamically change the store.format for only one request or session?
You can download the result of a query (up to 1 Million rows) in CSV or JSON or PARQUET formats
I tried using
set store.format = ‘csv’
But the file created by the following CTAS statement was still a parquet. How did you get a create table (CTAS) statement to create parquet files?
@waynekoepcke Currently, CTAS is limited to PARQUET
OK - Thanks for the clarification Balaji