Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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

<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

NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB