[
https://issues.apache.org/jira/browse/HIVE-18631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353373#comment-16353373
]
Deepesh Khandelwal commented on HIVE-18631:
-------------------------------------------
[~jcamachorodriguez] can you review the patch?
> 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
> Priority: Blocker
> Attachments: HIVE-18631.patch
>
>
> 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)
