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
After posting my question, I did some digging and also found the log4j categories. Unfortunately, setting them to DEBUG in hive-log4j.properties has no effect.

I will look into log4jdbc. Thanks for pointing it out.

From: Carl Steinbach [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 23, 2011 3:51 PM
Subject: Re: Logging MySQL queries

Hi Steven,

I think you can tell Datanucleus to log SQL using some of the configuration properties described here: http://www.datanucleus.org/products/accessplatform/logging.html

It looks like the Datanucleus.Datastore.* categories are the ones you are interested in.

Another option which may work is better is to use the log4jdbc proxy driver: http://code.google.com/p/log4jdbc/

Hope this helps.

On Mon, May 23, 2011 at 2:45 PM, Steven Wong <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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?