You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2016/02/12 16:32:18 UTC
[jira] [Updated] (HIVE-13048) Rogue SQL statement in an upgrade SQL
file for oracle.
[ https://issues.apache.org/jira/browse/HIVE-13048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naveen Gangam updated HIVE-13048:
---------------------------------
Attachment: HIVE-13048.patch
> 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
> Attachments: HIVE-13048.patch
>
>
> 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)