How to load encrypted tables to encrypted table in Hive

Question

Hi. I have created two encrypted tables in Hive and now I want to load one table into another. How can I do this?

Answer 1

If the data is already encrypted, use the CREATE TABLE statement pointing LOCATION to the encrypted source directory containing the data. This is the fastest way to create encrypted tables.

CREATE TABLE encrypted_table [STORED AS] LOCATION ... AS SELECT * FROM <encrypted_source_directory>