try this (drillbit is started in embedded mode): sqlline -u jdbc:drill:zk=local -n admin -p admin -f test.sql > test.out
You could put multiple statements in the .sql file. Use ";" as a statement separator. On Wed, Sep 2, 2015 at 4:22 PM, Edmon Begoli <[email protected]> wrote: > I have a query I would to benchmark in a batch. > > Let's call it benchmark.sql > > Is there a way to execute it in some way from the shell where I would not > need to go in the drill shell. > > Something like: > > $drill-cli benchmark.sql > results.txt > > So I can parse and post-process the execution times. >
