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

Complete 'ALTER' DDL command support for Kudu

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Kudu_Impala
    • Fix Version/s: Impala 2.8.0
    • Component/s: Catalog
    • Labels:
    • Docs Text:
      Hide
      - ALTER TABLE tbl_name ADD COLUMNS (col_spec [,... col_spec])
      col_spec: col_name col_type [[NOT] NULL] [DEFAULT val]
      - ALTER TABLE tbl_name DROP COLUMN col_name
      - ALTER TABLE tbl_name CHANGE col_name new_col_name col_type; Column rename. Cannot change the type of Kudu column; new column must have the same type as the column it is renamed.
      - ALTER TABLE tbl_name REPLACE is not supported
      - ALTER TALBE tbl_name SET TBLPROPERTIES('kudu.table_name'='kudu_tbl_name); Rename the underlying Kudu table or make an external table point to a different Kudu table.
      - ALTER TABLE tbl_name ADD RANGE PARTITION range_partition (see IMPALA-3719 for definition of range_partition)
      - ALTER TABLE tbl_name DROP RANGE PARTITION range_partition

      - Cannot change default value, nullability, encoding, compression and block size of existing Kudu columns

      - ALTER TABLE tbl_name RENAME TO new_tbl_name; Renames the HMS-backed table.
      Show
      - ALTER TABLE tbl_name ADD COLUMNS (col_spec [,... col_spec]) col_spec: col_name col_type [[NOT] NULL] [DEFAULT val] - ALTER TABLE tbl_name DROP COLUMN col_name - ALTER TABLE tbl_name CHANGE col_name new_col_name col_type; Column rename. Cannot change the type of Kudu column; new column must have the same type as the column it is renamed. - ALTER TABLE tbl_name REPLACE is not supported - ALTER TALBE tbl_name SET TBLPROPERTIES('kudu.table_name'='kudu_tbl_name); Rename the underlying Kudu table or make an external table point to a different Kudu table. - ALTER TABLE tbl_name ADD RANGE PARTITION range_partition (see IMPALA-3719 for definition of range_partition) - ALTER TABLE tbl_name DROP RANGE PARTITION range_partition - Cannot change default value, nullability, encoding, compression and block size of existing Kudu columns - ALTER TABLE tbl_name RENAME TO new_tbl_name; Renames the HMS-backed table.
    • Target Version:

      Description

      Supported operations should include:

      • add column
        • nullable columns may have null or non-null defaults
      • drop column
      • rename column
      • rename table
      • add/drop range partitions

        Issue Links

          Activity

          Hide
          caseyc casey added a comment -

          I'm going to use target version "Kudu_Impala" for now. We are still working out prioritizing requests, not sure when this will be ready.

          Show
          caseyc casey added a comment - I'm going to use target version "Kudu_Impala" for now. We are still working out prioritizing requests, not sure when this will be ready.
          Hide
          mjacobs Matthew Jacobs added a comment -

          Supported operations should include:

          • add [nullable] column
          • drop column
          • rename column
          • rename table
          Show
          mjacobs Matthew Jacobs added a comment - Supported operations should include: add [nullable] column drop column rename column rename table
          Hide
          tlipcon Todd Lipcon added a comment -

          We also support adding a column with a default value that is not NULL.

          You might find that we are missing one or more of these operations in the Java API - I seem to recall we are a little incomplete here. So if you don't see something that looks like it should be there, let us know and we'll add it.

          Show
          tlipcon Todd Lipcon added a comment - We also support adding a column with a default value that is not NULL. You might find that we are missing one or more of these operations in the Java API - I seem to recall we are a little incomplete here. So if you don't see something that looks like it should be there, let us know and we'll add it.
          Hide
          dtsirogiannis Dimitris Tsirogiannis added a comment -

          Change-Id: I04bc87e04e05da5cc03edec79d13cedfd2012896
          Reviewed-on: http://gerrit.cloudera.org:8080/5136
          Reviewed-by: Dimitris Tsirogiannis <dtsirogiannis@cloudera.com>
          Tested-by: Internal Jenkins

          Show
          dtsirogiannis Dimitris Tsirogiannis added a comment - Change-Id: I04bc87e04e05da5cc03edec79d13cedfd2012896 Reviewed-on: http://gerrit.cloudera.org:8080/5136 Reviewed-by: Dimitris Tsirogiannis <dtsirogiannis@cloudera.com> Tested-by: Internal Jenkins

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              hammer Jeff Hammerbacher
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development