RE: Logging MySQL queries

2011-06-02 Thread Steven Wong
bject: RE: Logging MySQL queries 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) ha

Re: Logging MySQL queries

2011-05-24 Thread Edward Capriolo
a 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 >

RE: Logging MySQL queries

2011-05-24 Thread Steven Wong
: 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

Re: Logging MySQL queries

2011-05-23 Thread Dilip Joseph
If you just want to temporarily look at the queries while debugging some problem, one option I have found useful is to enable logging of all queries on your mysqld (assuming mysqld instance is used only for hive, and is not under heavy load). Dilip On Mon, May 23, 2011 at 2:45 PM, Steven Wong wr

RE: Logging MySQL queries

2011-05-23 Thread Steven Wong
, 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

Re: Logging MySQL queries

2011-05-23 Thread Carl Steinbach
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

Re: Logging MySQL queries

2011-05-23 Thread Ashish Thusoo
you will have to write a pre execute or post execute hook to do this. The Hook api is at http://hive.apache.org/docs/r0.7.0/api/org/apache/hadoop/hive/ql/hooks/package-summary.html and then specify your

Logging MySQL queries

2011-05-23 Thread Steven Wong
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