You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "chiranjeevi (Jira)" <ji...@apache.org> on 2023/04/27 05:24:00 UTC
[jira] [Created] (HIVE-27301) Bucketed Non-partitioned table is not bucketed on insert overwrite/insert into select
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)