You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by qq <98...@qq.com> on 2019/10/30 07:07:18 UTC
How to migrate a table of a Hive database to another database
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!
Re: How to migrate a table of a Hive database to another database
Posted by Pau Tallada <ta...@pic.es>.
what about recreating them on the proper database?
no data movement is required
On Wed, Oct 30, 2019, 09:19 qq <98...@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!
>
>
> ------------------ 原始邮件 ------------------
> *发件人:* "我自己的邮箱"<98...@qq.com>;
> *发送时间:* 2019年10月30日(星期三) 下午3:59
> *收件人:* "user"<us...@hive.apache.org>; "user"<us...@hive.apache.org>;
> *主题:* 回复: How to migrate a table of a Hive database to another database
>
> think you very much
> ---原始邮件---
> 发件人:"Pau Tallada"<ta...@pic.es>;
> 发送时间:2019年10月30日(星期三) 下午3:22
> 收件人:"user"<us...@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 <98...@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!
>>
>
回复: How to migrate a table of a Hive database to another database
Posted by qq <98...@qq.com>.
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!
------------------ 原始邮件 ------------------
发件人: "我自己的邮箱"<987626311@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"<tallada@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 <987626311@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!
回复: How to migrate a table of a Hive database to another database
Posted by qq <98...@qq.com>.
think you very much
---原始邮件---
发件人:"Pau Tallada"<ta...@pic.es>;
发送时间:2019年10月30日(星期三) 下午3:22
收件人:"user"<us...@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 <98...@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!
Re: How to migrate a table of a Hive database to another database
Posted by Pau Tallada <ta...@pic.es>.
hi!
alter table db1.tablename rename to db2.tablename
Cheers!
On Wed, Oct 30, 2019, 08:16 qq <98...@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!
>