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:25:00 UTC
[jira] [Updated] (HIVE-27301) Bucketed Non-partitioned table is not bucketed on insert overwrite/insert into select
[ https://issues.apache.org/jira/browse/HIVE-27301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chiranjeevi updated HIVE-27301:
-------------------------------
Labels: bucketing overwriteExisting (was: )
> 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
> Priority: Major
> Labels: bucketing, overwriteExisting
>
> *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)