Deepesh Khandelwal created HIVE-15930:
-----------------------------------------
Summary: 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
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)
