that advice is way over complicating something that is very easy. instead, please take this approach.
1. run the ddl to create the table on the new cluster 2. distcp the hdfs data into the appropriate hdfs directory. 3. run "msck repair table <table>" in hive to discover the partitions and populate the metastore accordingly. On Fri, Feb 28, 2014 at 1:41 PM, Abdelrahman Shettia < ashet...@hortonworks.com> wrote: > If you are using Mysql as a database, you need to take a mysql dump of the > metastore database and search/replace the old namenode hostname with the > new namenode hostname. Once that is completed, import the metastore > database. > > Thanks > > > On Fri, Feb 28, 2014 at 12:59 AM, shashwat shriparv < > dwivedishash...@gmail.com> wrote: > >> Where was your meta data in derby or MySql? >> >> >> *Warm Regards_**∞_* >> * Shashwat Shriparv* >> [image: >> http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image: >> https://twitter.com/shriparv] <https://twitter.com/shriparv>[image: >> https://www.facebook.com/shriparv] <https://www.facebook.com/shriparv>[image: >> http://google.com/+ShashwatShriparv]<http://google.com/+ShashwatShriparv>[image: >> http://www.youtube.com/user/sShriparv/videos]<http://www.youtube.com/user/sShriparv/videos>[image: >> http://profile.yahoo.com/SWXSTW3DVSDTF2HHSRM47AV6DI/]<shrip...@yahoo.com> >> >> >> >> On Fri, Feb 28, 2014 at 1:28 PM, soniya B <soniya.bigd...@gmail.com>wrote: >> >>> Hi, >>> >>> I have moved warehouse file to another cluster. but still i didn't see >>> the tables on the other cluster. How to rebulid the metadata? >>> >>> Thanks >>> Soniya >>> >>> On Fri, Feb 28, 2014 at 9:26 AM, Krishnan K <kkrishna...@gmail.com>wrote: >>> >>>> 1. you can use distcp to copy the files to the new cluster >>>> 2. rebuild metadata >>>> >>>> >>>> On Thu, Feb 27, 2014 at 8:07 PM, soniya B <soniya.bigd...@gmail.com>wrote: >>>> >>>>> Dear experts, >>>>> >>>>> I want to move my hive tables from one cluster to another cluster. how >>>>> can i do it? >>>>> >>>>> Thanks >>>>> Soniya. >>>>> >>>> >>>> >>> >> > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You.
