[ 
https://issues.apache.org/jira/browse/IMPALA-6173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Tauber-Marshall resolved IMPALA-6173.
--------------------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.11.0

commit 3a1073c87c6ea08d9e8e2367851775748495300f
Author: Thomas Tauber-Marshall <tmarsh...@cloudera.com>
Date:   Wed Nov 8 14:41:38 2017 -0800

    IMPALA-6173: Fix SHOW CREATE TABLE for unpartitioned Kudu tables
    
    IMPALA-5546 added the ability to create unpartitioned Kudu tables, but
    when SHOW CREATE TABLE is run on it still prints 'PARTITION BY' just
    without a partition clause. This patch removes the 'PARTITION BY' from
    the output.
    
    Testing:
    - Added test that runs SHOW CREATE on an unpartitioned Kudu table.
    
    Change-Id: Icc327266cfb8b5c05efec97348528cea6904bb20
    Reviewed-on: http://gerrit.cloudera.org:8080/8506
    Reviewed-by: Alex Behm <alex.b...@cloudera.com>
    Tested-by: Impala Public Jenkins

> SHOW CREATE TABLE broken for unpartitioned Kudu tables
> ------------------------------------------------------
>
>                 Key: IMPALA-6173
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6173
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Infrastructure
>    Affects Versions: Impala 2.10.0
>            Reporter: Thomas Tauber-Marshall
>            Assignee: Thomas Tauber-Marshall
>             Fix For: Impala 2.11.0
>
>
> IMPALA-5546 added the ability to create unpartitioned Kudu tables. When SHOW 
> CREATE TABLE is run for such a table, we still print the "PARTITION BY" just 
> without anything after it.
> {noformat}
> show create table tpch_kudu.region; 
> Query: show create table tpch_kudu.region
> +-------------------------------------------------------------------------------------------------------------+
> | result                                                                      
>                                 |
> +-------------------------------------------------------------------------------------------------------------+
> | CREATE TABLE tpch_kudu.region (                                             
>                                 |
> |   r_regionkey SMALLINT NOT NULL ENCODING AUTO_ENCODING COMPRESSION 
> DEFAULT_COMPRESSION,                     |
> |   r_name STRING NULL ENCODING AUTO_ENCODING COMPRESSION 
> DEFAULT_COMPRESSION,                                |
> |   r_comment STRING NULL ENCODING AUTO_ENCODING COMPRESSION 
> DEFAULT_COMPRESSION,                             |
> |   PRIMARY KEY (r_regionkey)                                                 
>                                 |
> | )                                                                           
>                                 |
> | PARTITION BY                                                                
>                                 |
> | STORED AS KUDU                                                              
>                                 |
> | TBLPROPERTIES ('STATS_GENERATED_VIA_STATS_TASK'='true', 
> 'kudu.master_addresses'='127.0.0.1', 'numRows'='5') |
> +-------------------------------------------------------------------------------------------------------------+
> {noformat}
> This prevents the stress test from running dml queries against Kudu because 
> we use the SHOW CREATE TABLE output to create copies of the input tables.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to