--! qt:dataset:src
-- SORT_QUERY_RESULTS;

set hive.cli.errors.ignore=true;

DROP TABLE IF EXISTS encrypted_table;
DROP DATABASE IF EXISTS encrypted_db;

-- create database encrypted_db in its default warehouse location {hiveconf:hive.metastore.warehouse.dir}/encrypted_db.db
CREATE DATABASE encrypted_db LOCATION '${hiveconf:hive.metastore.warehouse.dir}/encrypted_db.db';
CRYPTO CREATE_KEY --keyName key_128 --bitLength 128;
CRYPTO CREATE_ZONE --keyName key_128 --path ${hiveconf:hive.metastore.warehouse.dir}/encrypted_db.db;

CREATE TABLE encrypted_db.encrypted_table (key INT, value STRING) LOCATION '${hiveconf:hive.metastore.warehouse.dir}/encrypted_db.db/encrypted_table';;

INSERT OVERWRITE TABLE encrypted_db.encrypted_table SELECT * FROM src;

DROP TABLE encrypted_db.encrypted_table;

DROP DATABASE encrypted_db;
CRYPTO DELETE_KEY --keyName key_128;