You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2022/11/25 09:08:00 UTC
[jira] [Commented] (IMPALA-3119) DDL support for bucketed tables
[ https://issues.apache.org/jira/browse/IMPALA-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17638584#comment-17638584 ]
ASF subversion and git services commented on IMPALA-3119:
---------------------------------------------------------
Commit 2733d039ad4a830a1ea34c1a75d2b666788e39a9 in impala's branch refs/heads/master from xiabaike
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=2733d039a ]
IMPALA-3119: DDL support for bucketed tables
Add syntactic support for creating bucketed table.
The specific syntax in the create table statement is as follows:
[CLUSTERED BY (column[, column ...]) [SORT BY (column[, column ...])]
INTO 24 BUCKETS]
Example:
CREATE TABLE tbl (i int COMMENT 'hello', s string)
CLUSTERED BY (i) INTO 24 BUCKETS;
CREATE TABLE tbl (i int COMMENT 'hello', s string)
CLUSTERED BY (i) SORT BY (s) INTO 24 BUCKETS;
Instructions:
1. The bucket partitioning algorithm is the hash function used
in Hive's bucketed tables;
2. Create Bucketed Table statements currently don't support Kudu and
Iceberg tables;
3. In the current version, alter operations(add/drop/change/replace
columns) on bucketed tables are not supported;
4. Support dropping bucketed table;
This COMMIT is the first subtask of IMPALA-3118.
Change-Id: I919b4d4139bc3a7784fa6fdb6f064e25666d548e
Reviewed-on: http://gerrit.cloudera.org:8080/19055
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> DDL support for bucketed tables
> -------------------------------
>
> Key: IMPALA-3119
> URL: https://issues.apache.org/jira/browse/IMPALA-3119
> Project: IMPALA
> Issue Type: Sub-task
> Components: Backend, Frontend
> Reporter: Mostafa Mokhtar
> Assignee: Baike Xia
> Priority: Minor
> Labels: ramp-up
>
> Reference https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL+BucketedTables
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org