[
https://issues.apache.org/jira/browse/HIVE-21086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laszlo Pinter reassigned HIVE-21086:
------------------------------------
> 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
> Priority: Major
> 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)
