[jira] [Created] (HIVE-20183) Inserting from bucketed table can cause data loss, if the source table contains empty buckets

["Peter Vary (JIRA)" <ji...@apache.org>]

Peter Vary created HIVE-20183:
---------------------------------

             Summary: 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


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)