Most likely its : HIVE-3226 (HIVE-1901) Workaround: set hive.optimize.cp=false
On Sat, Jan 26, 2013 at 10:40 AM, Mark Grover <grover.markgro...@gmail.com>wrote: > Hi John, > Thanks for reporting this. > > Can you please take a look at the Lateral View issues here: > > https://issues.apache.org/jira/issues/?jql=project%20%3D%20HIVE%20AND%20text%20~%20%22lateral%20view%22 > > and create a new JIRA with the details if one previously doesn't exist? > > Thanks again, > Mark > > > On Fri, Jan 25, 2013 at 6:38 PM, John Omernik <j...@omernik.com> wrote: > >> Anyone else seeing this >> >> >> select col1, col2, col3, excol >> from sometablewithanarrayfield >> LATERAL VIEW explode(arcol) artab as excol >> >> >> Works just fine >> >> select col1, excol, count(1) as excount from ( >> select col1, col2, col3, excol >> from sometablewithanarrayfield >> LATERAL VIEW explode(arcol) artab as excol >> ) a >> group by col1, excol >> >> Fails instantly with a weird java error >> >> Known bug? Need more details? >> >> > -- "...:::Aniket:::... Quetzalco@tl"