[jira] [Commented] (HIVE-6855) A couple of errors in MySQL db creation script for transaction tables

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-6855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13962077#comment-13962077 ] 

Ashutosh Chauhan commented on HIVE-6855:
----------------------------------------

Seems like we also need to update hive-schema-0.14.0.mysql.sql

> 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)