hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Wong <sw...@netflix.com>
Subject RE: Logging MySQL queries
Date Wed, 25 May 2011 00:01:24 GMT
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:swong@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:carl@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 <swong@netflix.com<mailto:swong@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


Mime
View raw message