hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@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
Date Mon, 07 Mar 2011 12:34:59 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Carl Steinbach updated HIVE-2011:
---------------------------------

    Status: Patch Available  (was: Open)

This is a patch for HIVE-2011 and HIVE-2010:

* Change the name of the upgrade scripts from 'upgrade-x.y.z.<dbname>.sql' to 'upgrade-x.y.z-to-a.b.c.<dbname>.sql'
* Splits the contents of the upgrade-x.y.z.<dbname>.sql files into individual SQL files
corresponding to each Hive ticket.
* Fixes HIVE-2011 by rearranging the order of DDL statements in 004-HIVE-1364.<dbname>.sql


> 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

Mime
View raw message