hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkatesh Kavuluri <vkavul...@outlook.com>
Subject RE: Hive 0.7.1 with MySQL 5.5 as metastore
Date Mon, 05 Nov 2012 23:37:53 GMT
Sorry for the confusion, the problem is not with the MySQL version upgrade - I have indeed
performed the upgrade by doing a mysqldump and restoring the data.
The problem is with how Hive 0.7.1 is interacting with the same metastore data on a different
version of MySQL server.

> Date: Mon, 5 Nov 2012 18:31:37 -0500
> Subject: Re: Hive 0.7.1 with MySQL 5.5 as metastore
> From: edlinuxguru@gmail.com
> To: user@hive.apache.org
> 
> Moving underlying data files around is not the correct way to perform
> an upgrade.
> 
> https://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html
> 
> I would do a mysqldump and then re-insert the data for maximum comparability.
> 
> On Mon, Nov 5, 2012 at 6:21 PM, Venkatesh Kavuluri
> <vkavuluri@outlook.com> wrote:
> > I am working on copying existing Hive metadata (Hive 0.7.1 with MySQL 5.1)
> > to a new cluster environment (Hive 0.7.1 with MySQL 5.5). I copied over the
> > metastore tables and modified the data under SDS (sub-directories) table to
> > reflect the new data path. However I am getting MySQL integrity constraint
> > violation against SDS.SD_ID column while trying to create new Hive tables.
> > Is this a problem with the MySQL version I am using ? Does Hive 0.7.1
> > support MySQL 5.5 as the metastore.
> >
> > Thanks,
> > Venkatesh
 		 	   		  
Mime
View raw message