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 <hadooph...@gmail.com> 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