Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13780

Allow user to update AVRO table schema via command even if table's definition was defined through schema file

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.3.0
    • Component/s: CLI
    • Labels:
      None

      Description

      If a table is defined as below:

      CREATE TABLE test
      STORED AS AVRO 
      TBLPROPERTIES ('avro.schema.url'='/tmp/schema.json');
      

      if user tries to run command:

      ALTER TABLE test CHANGE COLUMN col1 col1 STRING COMMENT 'test comment';
      

      The query will return without any warning, but has no affect to the table.

      It would be good if we can allow user to ALTER table (add/change column, update comment etc) even though the schema is defined through schema file.

        Attachments

        1. HIVE-13780.3.patch
          20 kB
          Ádám Szita
        2. HIVE-13780.1.patch
          20 kB
          Ádám Szita
        3. HIVE-13780.0.patch
          16 kB
          Ádám Szita

          Issue Links

            Activity

              People

              • Assignee:
                szita Ádám Szita
                Reporter:
                ericlin Eric Lin
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: