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

        Attachments

          Issue Links

            Activity

              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: