Search code examples
sqlsqlplusapache-drill

Is there alternative to "autotrace traceonly" on Apache Drill?

I'm new to Apache Drill.

For performance testing purpose, I'm trying to measure the time to execute a query. And also I do not need to print the executed result.

In Oracle SQL Plus, there is set autotrace traceonly. This setting feature is the following(quoting from the oracle web site):

Similar to SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any. If STATISTICS is enabled, query data is still fetched, but not printed.

In Apache Drill's sqlline, I got the error like the following: Error: PARSE ERROR: Encountered "traceonly" at line 1, column 15...

Do you have any ideas for alternatives?

Thanks,

p.s.

I also read this answered question. Any command in mysql equivalent to Oracle's autotrace for performance turning Unfortunately, it doesn't work on Apache Drill.

Solution

  • You could put your query(s) in a text file (e.g. query.sql), then run sqlline and forward the output to /dev/null:

    bin/sqlline -u jdbc:drill:zk=localhost:2181 -f query.sql > /dev/null

    It will still display some data, but only minimal:

    1/1          select * from cp.`employee.json`;
1,155 rows selected (0.65 seconds)
Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
apache drill 1.4.0 
"say hello to my little drill"