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

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 2.3.0
    • CLI
    • 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.0.patch
          16 kB
          Ádám Szita
        2. HIVE-13780.1.patch
          20 kB
          Ádám Szita
        3. HIVE-13780.3.patch
          20 kB
          Ádám Szita

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: