티스토리 뷰

공부

[Hive] How to copy table

승가비 2020. 11. 20. 23:55
728x90
CREATE TABLE NEWDB.NEW_TABLE1 AS select * from OLDDB.OLD_TABLE1;
CREATE TABLE NEWDB.NEW_TABLE2 AS select * from OLDDB.OLD_TABLE2;

https://stackoverflow.com/questions/26636839/how-to-copy-all-hive-table-from-one-database-to-other-database

 

How to copy all hive table from one Database to other Database

I have default db in hive table which contains 80 tables . I have created one more database and I want to copy all the tables from default DB to new Databases. Is there any way I can copy from One...

stackoverflow.com

 

728x90

'공부' 카테고리의 다른 글

[Spark] streaming throughput  (0) 2020.11.21
[Kafka] reset-offsets  (0) 2020.11.21
[Java] init HashMap()  (0) 2020.11.20
[SQL] ORDER BY RAND()  (0) 2020.11.20
[SQL] SHOW CREATE TABLE table;  (0) 2020.11.20
댓글