Laszlo Pinter created HIVE-21086:
------------------------------------
Summary: Fetch task and MR job give back different results when
multiple partitions point to the same location
Key: HIVE-21086
URL: https://issues.apache.org/jira/browse/HIVE-21086
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 4.0.0
Reporter: Laszlo Pinter
Assignee: Laszlo Pinter
Fix For: 4.0.0
Create a table with 2 partitions where both partitions share the same location
and inserting a single line to one of them.
{code:sql}
create table test (i int) partitioned by (j int);
alter table test add partition (j=1);
alter table test add partition (j=2) location '<<location of partition j=1>>';
insert into table test partition (j=1) values (1);{code}
Make sure *hive.fetch.task.conversion=more*.
{code:sql}
set hive.fetch.task.conversion=more;{code}
The result of a simple select * test:
+-----------+-------+
|test.i |test.j |
+-----------+-------+
|1 |1 |
|1 |2 |
+-----------+-------+
Change the *hive.fetch.task.conversion=none;*
{code:sql}
set hive.fetch.task.conversion=none;
{code}
The result of a simple select * test:
+-----------+-------+
|test.i |test.j |
+-----------+-------+
|1 |2 |
+-----------+-------+
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
