what about recreating them on the proper database? no data movement is required
On Wed, Oct 30, 2019, 09:19 qq <987626...@qq.com> wrote: > hi! > Using this method to migrate Hive internal tables is normal, but an > error is reported when migrating Hive external tables. The error message is > as follows: > Error:Error while compiling statement:FAILED:SemanticException [Error > 10134]:ALTER TABLE cannot be used for a non-native table tablename > How to migrate Hive external tables? > > thinks. > I am looking forward to your reply！ > > > ------------------ 原始邮件 ------------------ > *发件人:* "我自己的邮箱"<987626...@qq.com>; > *发送时间:* 2019年10月30日(星期三) 下午3:59 > *收件人:* "user"<user@hive.apache.org>; "user"<user@hive.apache.org>; > *主题:* 回复: How to migrate a table of a Hive database to another database > > think you very much > ---原始邮件--- > 发件人:"Pau Tallada"<tall...@pic.es>; > 发送时间:2019年10月30日(星期三) 下午3:22 > 收件人:"user"<user@hive.apache.org>; > 主题:Re: How to migrate a table of a Hive database to another database > > hi! > > alter table db1.tablename rename to db2.tablename > > Cheers! > > On Wed, Oct 30, 2019, 08:16 qq <987626...@qq.com> wrote: > >> Hello: >> How to migrate a table of a Hive database to another database? >> For example: >> Hive contains two databases: databaseA and databaseB. I want to >> migrate tableA in databaseA to databaseB. What do I need to do? Can you >> give me detailed steps? >> thinks. >> I am looking forward to your reply！ >> >
