[jira] [Commented] (HIVE-21086) Fetch task and MR job give back different results when multiple partitions point to the same location

["Hive QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-21086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16738236#comment-16738236 ] 

Hive QA commented on HIVE-21086:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12954306/HIVE-21086.01.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 15695 tests executed
*Failed tests:*
{noformat}
TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=251)
TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=251)
TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=251)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15561/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15561/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15561/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 3 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12954306 - PreCommit-HIVE-Build

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