Presto: Running presto sql script from cli - not able to see time taken by the query.

Created on 19 Oct 2016 · 3Comments · Source: prestodb/presto

Hi ,

I am using below command to run sql query. I am able to get the result of the query. But I am not able to find the time taken by query with this way. In case hive by using 2> , we can get details of query execution.

./presto-cli-0.152-executable.jar --server serverIp:port --catalog hive --schema databaseName -f ~/Scripts/Presto/q1.hql

enhancement stale

Source

KishorBaindoor

👍2

Most helpful comment

Agree with you to show time cost when running SQLs in command line. Also better to show stats below for statistic purpose.

"Query 20180208_034908_03080_uysbu, FINISHED, 1 node
Splits: 18 total, 18 done (100.00%)
0:01 [8.1K rows, 41.7KB] [12.2K rows/s, 62.7KB/s]"

nianglao on 8 Feb 2018

👍5

All 3 comments

We should add an option to show the stats for non-interactive queries. For basic timing, you can use the UNIX "time" command: https://linux.die.net/man/1/time

electrum on 19 Oct 2016

Agree with you to show time cost when running SQLs in command line. Also better to show stats below for statistic purpose.

"Query 20180208_034908_03080_uysbu, FINISHED, 1 node
Splits: 18 total, 18 done (100.00%)
0:01 [8.1K rows, 41.7KB] [12.2K rows/s, 62.7KB/s]"

nianglao on 8 Feb 2018

👍5

This issue has been automatically marked as stale because it has not had any activity in the last 2 years. If you feel that this issue is important, just comment and the stale tag will be removed; otherwise it will be closed in 7 days. This is an attempt to ensure that our open issues remain valuable and relevant so that we can keep track of what needs to be done and prioritize the right things.