hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15720) Bucketing: incorrect inserts with inserting from similarly bucketed table
Date Wed, 25 Jan 2017 02:37:26 GMT
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)

Mime
View raw message