[ https://issues.apache.org/jira/browse/HIVE-15930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Deepesh Khandelwal updated HIVE-15930: -------------------------------------- Attachment: HIVE-15930.patch Attaching a patch with the fix. cc. [~sushanth] [~thejas] > Syntax error in the MySQL metastore schema definition > ----------------------------------------------------- > > Key: HIVE-15930 > URL: https://issues.apache.org/jira/browse/HIVE-15930 > Project: Hive > Issue Type: Bug > Components: Metastore > Reporter: Deepesh Khandelwal > Assignee: Deepesh Khandelwal > Priority: Critical > Attachments: HIVE-15930.patch > > > The MySQL metastore definition > metastore/scripts/upgrade/mysql/hive-schema-2.2.0.mysql.sql contains a syntax > error for the table NOTIFICATION_LOG: > {noformat} > CREATE TABLE IF NOT EXISTS `NOTIFICATION_LOG` > ( > `NL_ID` BIGINT(20) NOT NULL, > `EVENT_ID` BIGINT(20) NOT NULL, > `EVENT_TIME` INT(11) NOT NULL, > `EVENT_TYPE` varchar(32) NOT NULL, > `DB_NAME` varchar(128), > `TBL_NAME` varchar(128), > `MESSAGE` longtext, > `MESSAGE_FORMAT` varchar(16) > PRIMARY KEY (`NL_ID`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1; > {noformat} > Notice a comma is missing after {{`MESSAGE_FORMAT` varchar(16)}}. > This got introduced through HIVE-10562. -- This message was sent by Atlassian JIRA (v6.3.15#6346)