According to the Wiki <https://cwiki.apache.org/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command> you need to call:
alter session set `store.format`='json'; to change the storage format. On Tue, Jan 6, 2015 at 12:35 PM, Sungwook Yoon <[email protected]> wrote: > Hi > > I am trying to save the query as csv > > So, I am doing > > create table as dfs.tmp.`/tmp.csv` select .. > > It creates a parquet file. > Why did it not create csv file? > > Thanks, > > Sungwook >
