hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vaibhav Gumashta <>
Subject Re: Empty Table in MR with "union all" (created in Tez)
Date Thu, 11 Jun 2015 02:12:59 GMT
Might be related to:


From: Gufran Mohammed Pathan <<>>
Reply-To: "<>" <<>>
Date: Wednesday, June 10, 2015 at 10:18 AM
To: "<>" <<>>
Subject: Empty Table in MR with "union all" (created in Tez)


I'm unable to retrieve rows from a table created in Tez when using MR as execution engine.
This happens only when the create table statement has "union all".

Here's a way to reproduce the issue:

set hive.execution.engine=tez;

create table test_table as
select "1" from table1
union all
select "1" from table2 ;

select * from test_table;  --gives correct roles

set hive.execution.engine=mr;

select * from test_table;  --gives empty table

Any ideas on why this must be happening? This issue does not occur when I don't use a "union
all" query.

I'm using HDP 2.2 with Hive 0.14 and Tez

Gufran Pathan| +91 7760913355|<>|

Correlation does not imply causation, but it does waggle its eyebrows suggestively and gesture
furtively while mouthing "look over there." -Randall Munroe


View raw message