Thanks Navis! Clay
-----Original Message----- From: Navis류승우 [mailto:navis....@nexr.com] Sent: Thursday, March 13, 2014 11:51 PM To: user@hive.apache.org Subject: Re: ALTER TABLE RENAME TO fully qualified name HIVE-4064 is expected to solve this kind of problems in hive but not in progress even it's not that hard to implement. I'll take a look at it when I'm free. Thanks, Navis 2014-03-13 22:08 GMT+09:00 Clay McDonald <stuart.mcdon...@bateswhite.com>: > Hello everyone, I'm running Hive 0.12.0 and I thought that support for > moving tables between database was added by using ALTER TABLE RENAME > TO fully qualified name. Here is what I executing; > > > > ALTER TABLE default.sale_reports RENAME TO > sales_database.sale_reports; > > > > Thanks, Clay