Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 19 Mar 2011 00:24:29 +0000 (UTC)
From: "Carl Steinbach (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <1731948850.13226.1300494269819.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <973225001.2311.1298916636888.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] Issue Comment Edited: (HIVE-2011) upgrade-0.6.0.mysql.sql
 script attempts to increase size of PK COLUMNS.TYPE_NAME to 4000
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Carl Steinbach edited comment on HIVE-2011 at 3/19/11 12:24 AM:
----------------------------------------------------------------

HIVE-2011.4.patch.txt:

* Fix capitalization of table names in MySQL schema dumps.

@John: I created these schemas using DataNucleus's schematool utility. I think this capitalization issue is actually a bug in DataNucleus.


      was (Author: cwsteinbach):
    HIVE-2011.4.patch.txt:

* Fix capitalization of table names in MySQL schema dumps.

@John: I created these schema's using DataNucleus's schematool utility. I think this capitalization issue is actually a bug in DataNucleus.

  
> upgrade-0.6.0.mysql.sql script attempts to increase size of PK COLUMNS.TYPE_NAME to 4000
> ----------------------------------------------------------------------------------------
>
>                 Key: HIVE-2011
>                 URL: https://issues.apache.org/jira/browse/HIVE-2011
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.6.0
>            Reporter: Carl Steinbach
>            Assignee: Carl Steinbach
>            Priority: Blocker
>             Fix For: 0.7.0
>
>         Attachments: HIVE-2011.1.patch.txt, HIVE-2011.2.patch.txt, HIVE-2011.2.patch.txt, HIVE-2011.3.patch.txt, HIVE-2011.4.patch.txt
>
>
> {code}
> # mysql flumenewresearch < upgrade-0.6.0.mysql.sql 
> ERROR 1071 (42000) at line 16: Specified key was too long; max key length is 767 bytes
> {code}
> Here's the cause of the problem from upgrade-0.6.0.mysql.sql:
> {code}
> ...
> ALTER TABLE `COLUMNS` MODIFY `TYPE_NAME` VARCHAR(4000);
> ...
> ALTER TABLE `COLUMNS` DROP PRIMARY KEY;
> ALTER TABLE `COLUMNS` ADD PRIMARY KEY (`SD_ID`, `COLUMN_NAME`);
> ...
> {code}
> We need to make sure that the PK on COLUMNS.TYPE_NAME is dropped before the size of the column is bumped to 4000.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira