I am using Amazon EMR. I have discovered that setting those log4j categories has the desired effect in EMR Hive 0.5, but has no effect in EMR Hive 0.7 beta version.
Setting them in Apache Hive 0.7 release version (on my computer, with Derby instead of MySQL) has the desired effect also. From: Steven Wong [mailto:sw...@netflix.com] Sent: Monday, May 23, 2011 4:13 PM To: user@hive.apache.org Subject: 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. 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
