UNION ALL is supported on Tez 0.4 onwards. If any of the tables are empty, that could be an issue- refer HIVE-8227
Thanks Suma On Mon, Oct 6, 2014 at 12:51 PM, João Alves <j...@5dlab.com> wrote: > 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 <anusha.mang...@gmail.com> wrote: > > Its fixed. > > > - Union all is not yet supported on Tez > > > Thanks > > On Fri, Oct 3, 2014 at 9:23 AM, anusha Mangina <anusha.mang...@gmail.com> > 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 <nimar...@pssd.com> wrote: >> >>> Can you post the query you're trying to run and the log output? >>> >>> -----Original Message----- >>> From: Anusha [mailto:anusha.mang...@gmail.com] >>> Sent: Friday, October 03, 2014 9:28 AM >>> To: user@hive.apache.org >>> 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 >>> >> >> > >
