Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6173

SHOW CREATE TABLE broken for unpartitioned Kudu tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 2.10.0
    • Impala 2.11.0
    • Infrastructure
    • None
    • ghx-label-1

    Description

      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.

      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') |
      +-------------------------------------------------------------------------------------------------------------+
      

      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.

      Attachments

        Issue Links

          Activity

            People

              twmarshall Thomas Tauber-Marshall
              twmarshall Thomas Tauber-Marshall
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: