[
https://issues.apache.org/jira/browse/IMPALA-14081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18039842#comment-18039842
]
ASF subversion and git services commented on IMPALA-14081:
----------------------------------------------------------
Commit f12bb87d421bd197ad27da9686a138db84a4bcc3 in impala's branch
refs/heads/master from Csaba Ringhofer
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=f12bb87d4 ]
IMPALA-14081: (addendum) add ';' to CREATE part in dataload
The missing ';' can cause problems for the next created
table.
Change-Id: I719872de23941bf81289340ce246d25ee113223a
Reviewed-on: http://gerrit.cloudera.org:8080/23704
Reviewed-by: Daniel Vanko <[email protected]>
Reviewed-by: Noemi Pap-Takacs <[email protected]>
Tested-by: Csaba Ringhofer <[email protected]>
> Support create/drop paimon table for impala
> -------------------------------------------
>
> Key: IMPALA-14081
> URL: https://issues.apache.org/jira/browse/IMPALA-14081
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: jichen
> Assignee: jichen
> Priority: Minor
> Labels: paimon
>
> this patch mainly implement the creation/drop of paimon table through impala.
> syntax for creating paimon table:
> CREATE [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name
> (
> [col_name data_type ,...]
> [PRIMARY KEY (col1,col2)]
> )
> [PARTITIONED BY (col_name data_type [COMMENT 'col_comment'], ...)]
> STORED AS PAIMON
> [LOCATION 'hdfs_path']
> [TBLPROPERTIES (
> 'primary-key'='col1,col2',
> 'file.format' = 'orc/parquet',
> 'bucket' = '2',
> 'bucket-key' = 'col3',
> ];
> two types of paimon catalogs are supported.
> (1) create table with hive catalog:
> CREATE TABLE paimon_hive_cat(userid INT,movieId INT)
> STORED AS PAIMON;
> (2) create table with hadoop catalog:
> CREATE EXTERNAL TABLE paimon_hadoop_cat
> STORED AS PAIMON
> TBLPROPERTIES('paimon.catalog'='hadoop',
> 'paimon.catalog_location'='/path/to/paimon_hadoop_catalog',
> 'paimon.table_identifier'='paimondb.paimontable');
> SHOW TABLE STAT/SHOW COLUMN STAT/SHOW PARTITIONS/SHOW FILES/SHOW CREATE TABLE
> statements are also supported.
> Testing:
> - Add test cases in metadata/test_show_create_table.py.
> - Add custom cluster test test_paimon.py.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
