[HIVE-15930] Syntax error in the MySQL metastore schema definition

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Metastore
• Target Version/s: 2.2.0
• Assignee: Deepesh Khandelwal
• Reporter: Deepesh Khandelwal
• Created: 15/Feb/17 18:00
• Updated: 21/Jul/17 18:36
• Resolved: 15/Feb/17 21:41

Description

The MySQL metastore definition metastore/scripts/upgrade/mysql/hive-schema-2.2.0.mysql.sql contains a syntax error for the table NOTIFICATION_LOG:

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;

Notice a comma is missing after `MESSAGE_FORMAT` varchar(16).
This got introduced through HIVE-10562.

Issue Links

• relates to: HIVE-10562 Add versioning/format mechanism to NOTIFICATION_LOG entries, expand MESSAGE size