[ 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)