?????? How to migrate a table of a Hive database to another database

[qq]

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&gt;; 
????????: 2019??10??30??(??????) ????3:59
??????: "user"<user@hive.apache.org&gt;; "user"<user@hive.apache.org&gt;; 
????: ????: How to migrate a table of a Hive database to another database



think you very much
---????????---
??????:"Pau&nbsp;Tallada"<tall...@pic.es&gt;;
????????:2019??10??30??(??????) ????3:22
??????:"user"<user@hive.apache.org&gt;;
????: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&gt; wrote:

Hello:
&nbsp; &nbsp; &nbsp; &nbsp;How to migrate a table of a Hive database to another 
database?
&nbsp; &nbsp; &nbsp; &nbsp;For example:
&nbsp; &nbsp; &nbsp; &nbsp;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?
&nbsp; &nbsp; &nbsp; &nbsp;thinks.
&nbsp; &nbsp; &nbsp; &nbsp;I am looking forward to your reply??