Denys Kuzmenko created HIVE-27436:
-------------------------------------

             Summary: Alter table schema fails when partition spec contains 
columns not in the lower registry
                 Key: HIVE-27436
                 URL: https://issues.apache.org/jira/browse/HIVE-27436
             Project: Hive
          Issue Type: Task
            Reporter: Denys Kuzmenko


Steps to repro
{code}
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);
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to