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. Steven From: Carl Steinbach [mailto:c...@cloudera.com] Sent: Monday, May 23, 2011 3:51 PM To: user@hive.apache.org 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. Carl On Mon, May 23, 2011 at 2:45 PM, Steven Wong <sw...@netflix.com<mailto:sw...@netflix.com>> 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
