[jira] [Created] (HIVE-15720) Bucketing: incorrect inserts with inserting from similarly bucketed table

["Gopal V (JIRA)" <ji...@apache.org>]

Gopal V created HIVE-15720:
------------------------------

             Summary: Bucketing: incorrect inserts with inserting from similarly bucketed table
                 Key: HIVE-15720
                 URL: https://issues.apache.org/jira/browse/HIVE-15720
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 2.2.0
            Reporter: Gopal V
            Priority: Critical


{code}
create temporary table foo(x int, y int) clustered by (x) sorted by (y) into 11 buckets stored as orc;
create temporary table bar like foo;
insert into foo values (23,2); insert into foo values(23,2); insert into foo values(23,2);
insert overwrite table bar select * from foo;
{code}

At this point, the table {{bar}} is incorrectly loaded.

{code}
hive> select x, regexp_replace(INPUT__FILE__NAME, '.*/','') from bar ;
OK
23      000000_0
23      000001_0
23      000002_0
Time taken: 0.22 seconds, Fetched: 3 row(s)

hive> select x, regexp_replace(INPUT__FILE__NAME, '.*/','') from foo;
OK
23      000001_0
23      000001_0_copy_1
23      000001_0_copy_2
Time taken: 0.329 seconds, Fetched: 3 row(s)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)