[HIVE-27301] Bucketed Non-partitioned table is not bucketed on insert overwrite/insert into select for external tables

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Hive
• Labels: bucketing overwriteExisting
• Assignee: Indhumathi Muthumurugesh
• Reporter: chiranjeevi
• Created: 27/Apr/23 05:23
• Updated: 27/Apr/23 05:49

Description

Steps to Reproduce ;

1)create table test_eb_true_bucket_wopart_none (a int, b int) clustered by (a) into 2 buckets stored as ORC ;
2)insert into test_eb_true_bucket_wopart_none values(1,2),(1,3),(1,4),(2,2),(2,3),(2,4);
insert into test_eb_true_bucket_wopart_none values(3,2),(4,3),(3,4);

3)insert overwrite table test_eb_true_bucket_wopart_none select * from test_eb_true_bucket_wopart_none;

Result;

The data is not bucketed on insert overwrite 

 

As per hdfs the data is not bucketed 

Before insert overwrite to table 

 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000000_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000000_0_copy_1
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000000_0_copy_2
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000001_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000001_0_copy_1
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000001_0_copy_2

After insert overwrite to table 

 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000000_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000001_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000002_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000003_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000004_0
 /warehouse/tablespace/external/hive/db1.db/test_eb_true_bucket_wopart_none/000005_0