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
;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
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