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

Copying a Hive metastore

2011-09-30 Thread Steven Wong
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 fronted by any Hive metastore server. My guess is Hive has some metasto