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?? ------------------ ???????? ------------------ ??????: "????????????"<[email protected]>; ????????: 2019??10??30??(??????) ????3:59 ??????: "user"<[email protected]>; "user"<[email protected]>; ????: ????: How to migrate a table of a Hive database to another database think you very much ---????????--- ??????:"Pau Tallada"<[email protected]>; ????????:2019??10??30??(??????) ????3:22 ??????:"user"<[email protected]>; ????: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 <[email protected]> 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??
