Q01: How do you back up an external with Data? A01 You can use CTAS (i.e. CREATE TABLE AS SELECT ) statement as shown below.
1 2 3 4 | hive> CREATE TABLE mydb.my_table_20211117 AS SELECT * FROM mydb.my_table; |
Q02: What if the table you are backing up is partitioned? A02 You can…