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 "Quanlong Huang (Jira)" <ji...@apache.org> on 2021/07/28 08:40:00 UTC

[jira] [Commented] (IMPALA-10184) Iceberg PARTITION SPEC missing from SHOW CREATE TABLE

    [ 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 <ga...@cloudera.com>
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 <im...@cloudera.com>
    Tested-by: Impala Public Jenkins <im...@cloudera.com>

> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org