[ https://issues.apache.org/jira/browse/HIVE-21086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laszlo Pinter updated HIVE-21086: --------------------------------- Attachment: HIVE-21086.01.patch > 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 > > Attachments: HIVE-21086.01.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 (v7.6.3#76005)