[ https://issues.apache.org/jira/browse/HIVE-6855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13962113#comment-13962113 ]
Alan Gates commented on HIVE-6855: ---------------------------------- The transaction tables aren't currently in hive-schema-0.14.0.mysql.sql because we wanted to figure out a better method than adding them by hand for 0.14. > A couple of errors in MySQL db creation script for transaction tables > --------------------------------------------------------------------- > > Key: HIVE-6855 > URL: https://issues.apache.org/jira/browse/HIVE-6855 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.13.0 > Reporter: Alan Gates > Assignee: Alan Gates > Attachments: HIVE-6855.patch > > > There are a few small issues in the database creation scripts for mysql. A > couple of the tables don't set the engine to InnoDB. None of the tables set > default character set to latin1. And the syntax "CREATE INDEX...USING HASH" > doesn't work on older versions of MySQL. Instead the index creation should > be done without specifying a method (no USING clause). -- This message was sent by Atlassian JIRA (v6.2#6252)