hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shrijeet Paliwal (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1902) create script for the metastore upgrade due to HIVE-78
Date Thu, 03 Mar 2011 02:36:36 GMT

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

Shrijeet Paliwal commented on HIVE-1902:
----------------------------------------

Stumbled upon one issue while running meta store upgrade script. Steps to reproduce: 
1. Have hive 0.6 metastore with no partitioned tables.
2. Run meta store script upgrade-0.7.0.mysql.sql

Get an error : 
{noformat}
ERROR 1005 (HY000) at line 64: Can't create table 'hive_meta_data.PART_COL_PRIVS' (errno:
150)
{noformat}

I think the table 'PARTITIONS' is created when you have your first partition registered. Hence
following action while creating PART_COL_PRIVS fails: 
{code}
CONSTRAINT `PART_COL_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
{code}

Another (minor) issue is with following entry in script :
{code}
ALTER TABLE `DBS` DROP COLUMN `PARAMETERS`;
{code}
The DBS table has not column PARAMETERS (at-least in 0.6). 

> create script for the metastore upgrade due to HIVE-78
> ------------------------------------------------------
>
>                 Key: HIVE-1902
>                 URL: https://issues.apache.org/jira/browse/HIVE-1902
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>            Reporter: Namit Jain
>            Assignee: Arvind Prabhakar
>            Priority: Blocker
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1902.1.patch.txt
>
>


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

        

Mime
View raw message