You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "László Pintér (Jira)" <ji...@apache.org> on 2020/02/24 08:55:00 UTC
[jira] [Updated] (HIVE-21086) Fetch task and MR job give back
different results when multiple partitions point to the same location
[ https://issues.apache.org/jira/browse/HIVE-21086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
László Pintér updated HIVE-21086:
---------------------------------
Resolution: Won't Fix
Status: Resolved (was: Patch Available)
> 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: László Pintér
> Assignee: László Pintér
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-21086.01.patch, HIVE-21086.02.patch, HIVE-21086.03.patch
>
>
> 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
(v8.3.4#803005)