[ 
https://issues.apache.org/jira/browse/IMPALA-10184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17388588#comment-17388588
 ] 

Quanlong Huang commented on IMPALA-10184:
-----------------------------------------

commit a5019eb12e7842e196f6dfed744eb8495e758776
Author: Gabor Kaszab <[email protected]>
Date:   Wed Sep 23 17:04:19 2020 +0200

    IMPALA-10184: Add PARTITON BY SPEC to SHOW CREATE TABLE for Iceberg Tables
    
    A SHOW CREATE TABLE output didn't contain the PARTITION BY SPEC section
    for partitioned Iceberg tables. This patch addresses this shortcoming.
    
    Change-Id: Ie4c43b75057807ab513a220d348155be2487e714
    Reviewed-on: http://gerrit.cloudera.org:8080/16512
    Reviewed-by: Impala Public Jenkins <[email protected]>
    Tested-by: Impala Public Jenkins <[email protected]>

> Iceberg PARTITION SPEC missing from SHOW CREATE TABLE
> -----------------------------------------------------
>
>                 Key: IMPALA-10184
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10184
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>            Reporter: Gabor Kaszab
>            Assignee: Gabor Kaszab
>            Priority: Major
>              Labels: impala-iceberg
>             Fix For: Impala 4.0.0
>
>
> The PARTITION SPEC is missing from the SHOW CREATE TABLE output for Iceberg 
> tables.
> This is how I created a table:
> {code:java}
> create table iceberg_tmp2 (
>   i int, 
>   s string, 
>   p1 string,
>   p2 timestamp
> ) 
> partition by spec (
>   p1 identity, 
>   p2 Day
> ) 
> stored as iceberg;
> {code}
> And this is the output of SHOW CREATE TABLE for the same table:
> {code:java}
> +-----------------------------------------------------------+
> | CREATE EXTERNAL TABLE default.iceberg_tmp2 (
> |   i INT,
> |   s STRING, 
> |   p1 STRING,
> |   p2 TIMESTAMP
> | )
> | STORED AS ICEBERG 
> | LOCATION 'hdfs://localhost:20500/test-warehouse/iceberg_tmp2'               
>                                          | TBLPROPERTIES 
> ('OBJCAPABILITIES'='EXTREAD,EXTWRITE', 'external.table.purge'='TRUE', 
> 'iceberg_file_format'='parquet')
> +----------------------------------------------------------------------+
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to