CTAS as csv from Rest API

1

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?

2

@yeshreddy

You can download the result of a query (up to 1 Million rows) in CSV or JSON or PARQUET formats

download-result
download-result1062×562 44.1 KB

Thanks
@balaji.ramaswamy

3

Hi,

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?

Thanks
Wayne
`

4

@waynekoepcke Currently, CTAS is limited to PARQUET

5

OK - Thanks for the clarification Balaji