You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Laszlo Pinter (JIRA)" <ji...@apache.org> on 2019/01/04 13:13:00 UTC
[jira] [Assigned] (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 ]
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)