Naveen Gangam created HIVE-13048: ------------------------------------ Summary: Rogue SQL statement in an upgrade SQL file for oracle. Key: HIVE-13048 URL: https://issues.apache.org/jira/browse/HIVE-13048 Project: Hive Issue Type: Bug Reporter: Naveen Gangam Assignee: Naveen Gangam
metastore/scripts/upgrade/oracle/033-HIVE-12892.oracle.sql has VERSION_COMMENT VARCHAR(255) NOT NULL CREATE TABLE CHANGE_VERSION ( CHANGE_VERSION_ID NUMBER NOT NULL, VERSION NUMBER NOT NULL, TOPIC VARCHAR(255) NOT NULL ); ALTER TABLE CHANGE_VERSION ADD CONSTRAINT CHANGE_VERSION_PK PRIMARY KEY (CHANGE_VERSION_ID); CREATE UNIQUE INDEX UNIQUE_CHANGE_VERSION ON CHANGE_VERSION (TOPIC); The first line appears to be a typo and should not really be there. I noticed that in the METASTORE-Test precommit builds. -- This message was sent by Atlassian JIRA (v6.3.4#6332)