If you are benchmarking, I strongly suggest that you use a direct Drillbit connection. Using a zk based connection string adds a few seconds for connection lookup and management.
You can see bin/drillbit-localhost for an example. -- Jacques Nadeau CTO and Co-Founder, Dremio On Wed, Sep 2, 2015 at 4:32 PM, Jinfeng Ni <[email protected]> wrote: > 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. > > >
