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)