hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vaibhav Gumashta <vgumas...@hortonworks.com>
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: https://issues.apache.org/jira/browse/HIVE-10929

Thanks,
-Vaibhav

From: Gufran Mohammed Pathan <Gufran.Pathan1@mu-sigma.com<mailto:Gufran.Pathan1@mu-sigma.com>>
Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>>
Date: Wednesday, June 10, 2015 at 10:18 AM
To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>>
Subject: Empty Table in MR with "union all" (created in Tez)

Hi,

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 0.4.0.2.

Thanks,
Gufran Pathan| +91 7760913355|www.mu-sigma.com<http://www.mu-sigma.com/>|

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

Disclaimer: http://www.mu-sigma.com/disclaimer.html

Mime
View raw message