hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <athu...@fb.com>
Subject Re: Logging MySQL queries
Date Mon, 23 May 2011 22:06:53 GMT
you will have to write a pre execute or post execute hook to do this. The Hook api is at

http://hive.apache.org/docs/r0.7.0/api/org/apache/hadoop/hive/ql/hooks/package-summary.html

<http://hive.apache.org/docs/r0.7.0/api/org/apache/hadoop/hive/ql/hooks/package-summary.html>and
then specify your hook in the site.xml for hive as follows...

<property>
  <name>hive.exec.post.hooks</name>
  <value>[name of the class that implements the interface]</value>
  <description>Post execution hooks</description>
</property>

Ashish

On May 23, 2011, at 2:45 PM, Steven Wong wrote:

My Hive metastore uses MySQL. I’d like to see Hive CLI log all SQL queries that are issued
to MySQL. What config/property should I set to accomplish this?

Thanks.
Steven


Mime
View raw message