Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Logging MySQL queries

Copy link to this message
Re: Logging MySQL queries
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>and then specify your hook in the site.xml for hive as follows...

  <value>[name of the class that implements the interface]</value>
  <description>Post execution hooks</description>


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?