CTAS as csv from Rest API

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