How to save output in any format

I am using drill in embedded mode in window having 1.8 version.  Suppose i have fire query :- select * from DemoSQLServer..Attribute; It will return some output. Now my question is :- Is it possible to save the output ?  I know in drill documnet  !record  is there:-  https://drill.apache.org/docs

Re: How to save output in any format

You can specify this using the outputformat option in sqlline. sqlline> !record ~/output.csv sqlline> !outputformat csv Another way I usually do is via sqlline variables and scripts. $DRILL_HOME/bin/sqlline -u jdbc:drill:zk=: --outputformat=csv < ~/input.sql > ~/output.csv On Tue, Sep 6, 2016

Re: How to save output in any format

You may also look at using the storage plugins to create output by using CTAS. You then need to set the session/system to use the appropriate storage format (store.format). http://drill.apache.org/docs/configuration-options-introduction/