chiranjeevi created HIVE-27301:
----------------------------------
Summary: Bucketed Non-partitioned table is not bucketed on insert
overwrite/insert into select
Key: HIVE-27301
URL: https://issues.apache.org/jira/browse/HIVE-27301
Project: Hive
Issue Type: Bug
Components: Hive
Reporter: chiranjeevi
*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
h4. As per hdfs the data is not bucketed
h3. *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
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
