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
