hadoop - Transferring hive table from one database to another -


I need to move a hive table from one database to another. How can I do this?

Any person please help

From 0.14, you can see the same metastore To move a table from one database to another, you can use the following statement:

  Use the old_database; Change the table table to rename new_database.table_a   

If table_a is a managed table, then the above statements also move the table data on the hdfs Will give

Comments

Popular posts from this blog

Verilog Error: output or inout port "Q" must be connected to a structural net expression -

jasper reports - How to center align barcode using jasperreports and barcode4j -

c# - ASP.NET MVC - Attaching an entity of type 'MODELNAME' failed because another entity of the same type already has the same primary key value -