Return-Path: Delivered-To: apmail-hive-dev-archive@www.apache.org Received: (qmail 37880 invoked from network); 7 Mar 2011 12:30:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Mar 2011 12:30:21 -0000 Received: (qmail 75004 invoked by uid 500); 7 Mar 2011 12:30:21 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 74974 invoked by uid 500); 7 Mar 2011 12:30:21 -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 74966 invoked by uid 500); 7 Mar 2011 12:30:21 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 74963 invoked by uid 99); 7 Mar 2011 12:30:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Mar 2011 12:30:21 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Mar 2011 12:30:20 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id A321C39B6B7 for ; Mon, 7 Mar 2011 12:29:59 +0000 (UTC) Date: Mon, 7 Mar 2011 12:29:59 +0000 (UTC) From: "Carl Steinbach (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <1314899111.812.1299500999664.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <973225001.2311.1298916636888.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] Updated: (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 X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-2011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2011: --------------------------------- Attachment: HIVE-2011.1.patch.txt > 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 > > > {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