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