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

SHOW CREATE TABLE broken for unpartitioned Kudu tables

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.10.0
    • Fix Version/s: Impala 2.11.0
    • Component/s: Infrastructure
    • Labels:
      None
    • Epic Color:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: