ql/src/test/queries/clientpositive/encryption_load_data_to_encrypted_tables.q

DROP TABLE IF EXISTS encrypted_table_n0 PURGE;

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

-- Create encryption key and zone;
crypto create_key --keyName key1;
crypto create_zone --keyName key1 --path ${hiveconf:hive.metastore.warehouse.dir}/encrypted_table;

-- Test loading data from the local filesystem;
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE encrypted_table_n0;
SELECT * FROM encrypted_table_n0;

-- Test loading data from the hdfs filesystem;
dfs -mkdir hdfs:///tmp;
dfs -copyFromLocal -f ../../data/files/kv1.txt hdfs:///tmp/kv1.txt;
LOAD DATA INPATH '/tmp/kv1.txt' OVERWRITE INTO TABLE encrypted_table_n0;
SELECT * FROM encrypted_table_n0;

DROP TABLE encrypted_table_n0 PURGE;

crypto delete_key --keyName key1;