Hey Anusha, You sure about that?
The following works for me: set hive.execution.engine=tez; select A from table1 UNION ALL select A from table2; Best, João On 03 Oct 2014, at 17:01, anusha Mangina <[email protected]> wrote: > Its fixed. > > Union all is not yet supported on Tez > > Thanks > > On Fri, Oct 3, 2014 at 9:23 AM, anusha Mangina <[email protected]> > wrote: > Hey Nick, > > This is the query > > INSERT INTO TABLE abc > SELECT d.employee, max(d.employeesalary),d.employee_type FROM > (SELECT a.employee, a.employeesalary,a.dept as employee_type > from table1 a > UNION ALL > SELECT b.employee, b.value as employeesalary,b.dept as employee_type > from table2 b > UNION ALL > SELECT c.employee, c.value as employeesalary,c.dept as employee_type > from table2 c > ) d > GROUP BY d.employee,d.employee_type; > > > it runs fine with MR. I couldnt even see Yarn application being started .. I > couldnt see logs either.. But TEZ works fine with other queries. > > > > > On Fri, Oct 3, 2014 at 8:29 AM, Martin, Nick <[email protected]> wrote: > Can you post the query you're trying to run and the log output? > > -----Original Message----- > From: Anusha [mailto:[email protected]] > Sent: Friday, October 03, 2014 9:28 AM > To: [email protected] > Subject: Null Pointer Exception with tez > > Hi , > > I get Null Pointer Exception sometimes when I run queries with Tez as hive > execution engine .. But the same queries run fine with MR ( map reduce ) . Is > there any config changes I need to make .? > > > Kindest Regards, > Anusha > >
