Presto-hive access query history

1
votes

I'm using presto for querying Hive warehouse, I got query history in presto web interface. Question:

In hive query history logs will available in the Hadoop file system hive path.

1
presto
Presto doesn't execute Hive query. It directly accesses HDFS. You can also ask such a question on the community Slack. prestosql.io/slack.html – ebyhr

1 Answers

1
votes

No, the queries Presto executes are not available in HDFS (or anywhere, really). They are temporarily available in-memory on the Coordinator to show in the UI. What you can do is create an implementation of an EventListener in order to receive the queries Presto executes. You can then do whatever you like with that information, e.g. log it or write it to a database.