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

SHOW CREATE TABLE broken for unpartitioned Kudu tables

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment