Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D084A1070F for ; Mon, 7 Apr 2014 18:01:31 +0000 (UTC) Received: (qmail 46826 invoked by uid 500); 7 Apr 2014 18:01:25 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 46762 invoked by uid 500); 7 Apr 2014 18:01:25 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 46736 invoked by uid 500); 7 Apr 2014 18:01:23 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 46725 invoked by uid 99); 7 Apr 2014 18:01:23 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Apr 2014 18:01:23 +0000 Date: Mon, 7 Apr 2014 18:01:23 +0000 (UTC) From: "Alan Gates (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-6855) A couple of errors in MySQL db creation script for transaction tables MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-6855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated HIVE-6855: ----------------------------- Status: Patch Available (was: Open) NO PRECOMMIT TESTS Updated the mysql scripts. > 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)