Deepesh Khandelwal created HIVE-18631:
-----------------------------------------
Summary: Hive metastore schema initialization failing on mysql
Key: HIVE-18631
URL: https://issues.apache.org/jira/browse/HIVE-18631
Project: Hive
Issue Type: Bug
Components: Metastore
Affects Versions: 3.0.0
Reporter: Deepesh Khandelwal
Assignee: Deepesh Khandelwal
Hive metastore schema on mysql is broken after the commit for HIVE-18546.
Following error is seen during schema initialization:
{noformat}
0: jdbc:mysql://localhost.localdomain> CREATE TABLE IF NOT EXISTS `TBLS`
( `TBL_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `DB_ID`
bigint(
20) DEFAULT NULL, `LAST_ACCESS_TIME` int(11) NOT NULL, `OWNER` varchar(767)
CHAR
ACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `RETENTION` int(11) NOT NULL,
`SD_ID` bigint(20) DEFAULT NULL, `TBL_NAME` varchar(256) CHARACTER SET latin1
CO
LLATE latin1_bin DEFAULT NULL, `TBL_TYPE` varchar(128) CHARACTER SET latin1
COLL
ATE latin1_bin DEFAULT NULL, `VIEW_EXPANDED_TEXT` mediumtext,
`VIEW_ORIGINAL_TEX
T` mediumtext, `IS_REWRITE_ENABLED` bit(1) NOT NULL DEFAULT 0 PRIMARY KEY
(`TBL_
ID`), UNIQUE KEY `UNIQUETABLE` (`TBL_NAME`,`DB_ID`), KEY `TBLS_N50` (`SD_ID`),
K
EY `TBLS_N49` (`DB_ID`), CONSTRAINT `TBLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES
`SDS` (`SD_ID`), CONSTRAINT `TBLS_FK2` FOREIGN KEY (`DB_ID`) REFERENCES `DBS`
(`
DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
Error: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '(`TBL_ID`),
UNIQUE KEY `UNIQUETABLE` (`TBL_NAME`,`DB_ID`), KEY `TBLS_N50` (`SD_I' at line 1
(state=42000,code=1064)
Closing: 0:
jdbc:mysql://localhost.localdomain/hivedb?createDatabaseIfNotExist=true
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization
FAILED! Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization
FAILED! Metastore state would be inconsistent !!
at
org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:586)
at
org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:559)
at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1183)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:304)
at org.apache.hadoop.util.RunJar.main(RunJar.java:218)
Caused by: java.io.IOException: Schema script failed, errorcode 2
at
org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:957)
at
org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:935)
at
org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:582)
... 8 more
*** schemaTool failed ***{noformat}
In the file metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql one of
the column definitions in the `TBLS` table is missing a comma at the end
{code:java}
`IS_REWRITE_ENABLED` bit(1) NOT NULL DEFAULT 0{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
