Re: Migration of metastore tables from mysql to oracle.

2014-10-21 Thread Sanjay Subramanian 
First question, Why are u migrating to Oracle ? Since u never store data on 
Hive Metastore MYSQL is a great choice. 

I have done a MYSQL to MYSQL transfer From the source DB mysql dump, it should 
be possible  to mod any Oracle required syntax right ?


  From: hadoop hive 
 To: user@hive.apache.org 
 Sent: Tuesday, October 21, 2014 2:36 AM
 Subject: Migration of metastore tables from mysql to oracle.
   
Hi folks,I have a requirement where I need to migrate metastore tables from 
mysql to oracle.Is there any who already performed this kind of activity.Any 
help will be appreciatedThanks
Vikas Srivastava

Migration of metastore tables from mysql to oracle.

2014-10-21 Thread hadoop hive 
Hi folks,

I have a requirement where I need to migrate metastore tables from mysql to
oracle.

Is there any who already performed this kind of activity.

Any help will be appreciated

Thanks
Vikas Srivastava