[
https://issues.apache.org/jira/browse/HIVE-20183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547223#comment-16547223
]
Hive QA commented on HIVE-20183:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12931930/HIVE-20183.2.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:green}SUCCESS:{color} +1 due to 14664 tests passed
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/12661/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12661/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12661/
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
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12931930 - PreCommit-HIVE-Build
> Inserting from bucketed table can cause data loss, if the source table
> contains empty buckets
> ---------------------------------------------------------------------------------------------
>
> Key: HIVE-20183
> URL: https://issues.apache.org/jira/browse/HIVE-20183
> Project: Hive
> Issue Type: Bug
> Components: Operators
> Reporter: Peter Vary
> Assignee: Peter Vary
> Priority: Major
> Attachments: HIVE-20183.2.patch, HIVE-20183.patch
>
>
> Could be reproduced by the following:
> {code}
> set hive.enforce.bucketing=true;
> set hive.enforce.sorting=true;
> set hive.optimize.bucketingsorting=true;
> create table bucket1 (id int, val string) clustered by (id) sorted by (id
> ASC) INTO 4 BUCKETS;
> insert into bucket1 values (1, 'abc'), (3, 'abc');
> select * from bucket1;
> +-------------+--------------+
> | bucket1.id | bucket1.val |
> +-------------+--------------+
> | 3 | abc |
> | 1 | abc |
> +-------------+--------------+
> create table bucket2 like bucket1;
> insert overwrite table bucket2 select * from bucket1;
> select * from bucket2;
> +-------------+--------------+
> | bucket2.id | bucket2.val |
> +-------------+--------------+
> | 1 | abc |
> +-------------+--------------+
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
