Thanks Andries (and also, Aditya). I will try that. On Sun, Feb 8, 2015 at 5:50 PM, Andries Engelbrecht < [email protected]> wrote:
> CTAS (Create Table As) is the way to get a CSV output. Make sure you point > to the correct directory and storage plugin configuration. > > Also to the best way to ensure you get the CSV output file is set the > session setting for output to CSV. > > I.e. alter session set `store.format` = ‘csv’; > > As an FYI, to spool or record the output of a sqlline session you can use > -- !record /tmp/test.out (Where you need to specific the local file > system path and file name) > To stop recording the output simple enter !record again. > > This however will just output to file the screen output and not in a > specific file format. > > > —Andries > > > On Feb 8, 2015, at 12:27 PM, Aditya <[email protected]> wrote: > > > Please see > > > https://cwiki.apache.org/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command > > > > On Sun, Feb 8, 2015 at 10:47 AM, Minnow Noir <[email protected]> > wrote: > > > >> I'm trying to extract query results as CSV for ingestion into another > >> tool. There's no obvious way in sqlline, the web UI, or the docs to > >> extract query results as CSV (or other formats). > >> > >> sqlline ./test.sql > output.csv doesn't work. Is there a way to pass > >> sqlline a query file and then dump the output? > >> > >> Thanks > >> > >
