hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gufran Mohammed Pathan <>
Subject Empty Table in MR with "union all" (created in Tez)
Date Wed, 10 Jun 2015 17:18:53 GMT

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