Re: Copying a Hive metastore

2011-10-10 Thread Jander g
g [mailto:jande...@gmail.com] > Sent: Saturday, October 08, 2011 10:54 PM > To: user@hive.apache.org > Subject: Re: Copying a Hive metastore > > Yes, you are right. I had merged two hive metastore several months > ago. I restored one metastore to HQL and run this hql file to finish &

RE: Copying a Hive metastore

2011-10-10 Thread Steven Wong
How do you generate an HQL file from a metastore? -Original Message- From: Jander g [mailto:jande...@gmail.com] Sent: Saturday, October 08, 2011 10:54 PM To: user@hive.apache.org Subject: Re: Copying a Hive metastore Yes, you are right. I had merged two hive metastore several months

Re: Copying a Hive metastore

2011-10-08 Thread Jander g
Sent: Friday, September 30, 2011 3:16 PM > To: user@hive.apache.org > Subject: Re: Copying a Hive metastore > > > On Fri, Sep 30, 2011 at 5:05 PM, Steven Wong > mailto:sw...@netflix.com>> wrote: > Hi, > > What is a good way to copy the entire content of a Hive metasto

RE: Copying a Hive metastore

2011-09-30 Thread Steven Wong
l.com] Sent: Friday, September 30, 2011 3:16 PM To: user@hive.apache.org Subject: Re: Copying a Hive metastore On Fri, Sep 30, 2011 at 5:05 PM, Steven Wong mailto:sw...@netflix.com>> wrote: Hi, What is a good way to copy the entire content of a Hive metastore and insert it into a

Re: Copying a Hive metastore

2011-09-30 Thread Edward Capriolo
On Fri, Sep 30, 2011 at 5:05 PM, Steven Wong wrote: > Hi, > > > > What is a good way to copy the entire content of a Hive metastore and > insert it into another Hive metastore? The second metastore contains > existing metadata that needs to be preserved. Both metastores are in MySQL, > not fronte