MySQL has query logging, also mysql-proxy exists. Edward
On Tue, May 24, 2011 at 8:01 PM, Steven Wong <sw...@netflix.com> wrote: > 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> 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 > > >
