Load data throws exception, cant figure it out

2012-07-02 Thread Ruben de Vries
Hey Guys, I've been playing with Hive for a while now but somehow I run into this error all of a sudden when setting up my production cluster. $ hive -e 'LOAD DATA INPATH "/tmp/members_map_2012-06-30.map" OVERWRITE INTO TABLE members_map_full;' Loading data to table hyves_goldmine.members_map_

Re: getting Hive table access times

2012-07-02 Thread Stephen R. Scaffidi
On 06/28/2012 09:28 AM, Stephen R. Scaffidi wrote: I've written some code where I am trying to get the atime of my tables in Hive. It's fairly simple - the method call in question is simply: int atime = htable.getLastAccessTime(); Where htable is an otherwise normal org.apache.hadoop.hive.m

RE: Load data throws exception, cant figure it out

2012-07-02 Thread Ruben de Vries
Figured it out myself by running with ' -hiveconf hive.root.logger=INFO,console' that it was binlog --- Hey Guys, I've been playing with Hive for a while now but somehow I run into this error all of a sudden when setting up my product

Re: getting Hive table access times

2012-07-02 Thread VanHuy Pham
I think it only makes sense to use getLastAccessTime() when you have already used setLastAccessTime() MANUALLY, otherwise hive does not automatically set the access time in its metastore. Correct me if I am wrong! On Mon, Jul 2, 2012 at 4:46 AM, Stephen R. Scaffidi < sscaff...@tripadvisor.com> wro

How to a property in hive query

2012-07-02 Thread Abhishek
Hi all, Can I know, how to override a property of mapred-site.xml in Hive join query. Suppose for map reduce job we override using -D , how to do it with in hive query. Regards Abhishek Sent from my iPhone

Fwd: How to override a property with in a hive query

2012-07-02 Thread Abhishek
Hi all, Can I know, how to override a property of mapred-site.xml in Hive join query. Suppose for map reduce job we override using -D , how to do it with in hive query. Regards Abhishek. Begin forwarded message: > From: Abhishek > Date: July 2, 2012 8:10:47 PM EDT > To: "user@hive.apache.org

Re: How to override a property with in a hive query

2012-07-02 Thread Tim Havens
Before your query type SET = ; On Mon, Jul 2, 2012 at 7:13 PM, Abhishek wrote: > Hi all, > > Can I know, how to override a property of mapred-site.xml in Hive join > query. > Suppose for map reduce job we override using -D , how > to do it with in hive query. > > Regards > Abhishek. > > > Begin

Re: How to override a property with in a hive query

2012-07-02 Thread Abhishek
Hi Tim, Is this the only way, or if we have any other ways. Sent from my iPhone On Jul 2, 2012, at 8:49 PM, Tim Havens wrote: > Before your query type SET = ; > > On Mon, Jul 2, 2012 at 7:13 PM, Abhishek wrote: > Hi all, > > Can I know, how to override a property of mapred-site.xml in Hive