[
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
