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
