hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6855) A couple of errors in MySQL db creation script for transaction tables
Date Mon, 07 Apr 2014 18:07:15 GMT

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

Mime
View raw message