Re: Strange error in Hive - Insert INTO

2013-08-19 Thread Jérôme Verdier
AM > To: "user@hive.apache.org" > Subject: Re: Strange error in Hive - Insert INTO > > Hi Jerome, > That's a grandiose sql statement you got there! :)I find that if you > break up those nested queries into simple CTAS (Create Table AS) statements

Re: Strange error in Hive - Insert INTO

2013-08-14 Thread Sanjay Subramanian
;user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Wednesday, August 14, 2013 8:43 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: Strange error in Hive - Insert INT

Re: Strange error in Hive - Insert INTO

2013-08-14 Thread Stephen Sprague
Hi Jerome, That's a grandiose sql statement you got there! :)I find that if you break up those nested queries into simple CTAS (Create Table AS) statements and create a cascading effect of referring to the table in the previous step it makes debugging *so* much easier. In other SQL dialects li

Re: Strange error in hive

2013-07-16 Thread Jérôme Verdier
Hi, I have apply this patch but unfortunately, the error is still the same when i run the script. Thanks, 2013/7/16 Navis류승우 > patch -p0 -i would work. > > https://cwiki.apache.org/confluence/display/Hive/HowToContribute > > 2013/7/15 Jérôme Verdier : > > Hi, > > > > Thanks for your reply Na

Re: Strange error in hive

2013-07-15 Thread Navis류승우
patch -p0 -i would work. https://cwiki.apache.org/confluence/display/Hive/HowToContribute 2013/7/15 Jérôme Verdier : > Hi, > > Thanks for your reply Navis. > > I have downloaded the patch file, but, i don't know how to install this... > > is there a good tutorial for this ? > > > > 2013/7/10 Nav

Re: Strange error in hive

2013-07-15 Thread Jérôme Verdier
Hi, Thanks for your reply Navis. I have downloaded the patch file, but, i don't know how to install this... is there a good tutorial for this ? 2013/7/10 Navis류승우 > Attached patch for this in https://issues.apache.org/jira/browse/HIVE-4837 > > 2013/7/10 Navis류승우 : > > Could you try to remov

Re: Strange error in hive

2013-07-09 Thread Navis류승우
Attached patch for this in https://issues.apache.org/jira/browse/HIVE-4837 2013/7/10 Navis류승우 : > Could you try to remove "NULL as FLG_DEM_INC_PRX_CS_VAL"s in the query? > > It seemed not related to HIVE-4650 but still a bug (I'll book this) > > 2013/7/9 Jérôme Verdier : >> Hi, >> >> Thanks for yo

Re: Strange error in hive

2013-07-09 Thread Navis류승우
Could you try to remove "NULL as FLG_DEM_INC_PRX_CS_VAL"s in the query? It seemed not related to HIVE-4650 but still a bug (I'll book this) 2013/7/9 Jérôme Verdier : > Hi, > > Thanks for your help. > > You can see logs below : > > java.lang.RuntimeException: Error in configuring object > at >

Re: Strange error in hive

2013-07-09 Thread Jérôme Verdier
Hi, Thanks for your help. You can see logs below : java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64) at org.apache.hadoop.uti

Re: Strange error in hive

2013-07-08 Thread bejoy_ks
Hii Jerome Can you send the error log of the MapReduce task that failed? That should have some pointers which can help you troubleshoot the issue. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Jérôme Verdier Date: Mon, 8 Jul 2013 11:25:34 To