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

Iceberg: Alter table schema fails when partition spec contains columns not in the lower registry

    XMLWordPrintableJSON

Details

    Description

      Steps to repro

      CREATE EXTERNAL TABLE tbl_ice(ID INT, NAME STRING) 
      PARTITIONED BY (DEPT STRING) 
      STORED BY ICEBERG STORED AS PARQUET;
      
      INSERT INTO TABLE tbl_ice
      VALUES (1,'ONE','MATH'), (2, 'ONE','PHYSICS'), (3,'ONE','CHEMISTRY'), (4,'TWO','MATH'), (5, 'TWO','PHYSICS'), (6,'TWO','CHEMISTRY');
      
      ALTER TABLE tbl_ice ADD COLUMNS (emp_count int);
      

      Attachments

        Issue Links

          Activity

            People

              dkuzmenko Denys Kuzmenko
              dkuzmenko Denys Kuzmenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: