blob: 911583af08badbb90e64fb00c02a796e54671637 [file] [log] [blame]
DROP TABLE IF EXISTS dve_encrypted_table PURGE;
CREATE TABLE dve_encrypted_table (key INT, value STRING) LOCATION '${hiveconf:hive.metastore.warehouse.dir}/default/dve_encrypted_table';
CRYPTO CREATE_KEY --keyName key_128 --bitLength 128;
CRYPTO CREATE_ZONE --keyName key_128 --path ${hiveconf:hive.metastore.warehouse.dir}/default/dve_encrypted_table;
CREATE VIEW dve_view AS SELECT * FROM dve_encrypted_table;
DROP VIEW dve_view;