You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2015/01/05 17:32:23 UTC
svn commit: r1649581 - in /hive/branches/HIVE-8065/ql/src/test:
queries/clientpositive/encryption_insert_partition_dynamic.q
results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
Author: brock
Date: Mon Jan 5 16:32:23 2015
New Revision: 1649581
URL: http://svn.apache.org/r1649581
Log:
HIVE-9237 - enable the unit test for inserting into dynamically partitioned table with new crypto command (Dong Chen via Brock)
Modified:
hive/branches/HIVE-8065/ql/src/test/queries/clientpositive/encryption_insert_partition_dynamic.q
hive/branches/HIVE-8065/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
Modified: hive/branches/HIVE-8065/ql/src/test/queries/clientpositive/encryption_insert_partition_dynamic.q
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-8065/ql/src/test/queries/clientpositive/encryption_insert_partition_dynamic.q?rev=1649581&r1=1649580&r2=1649581&view=diff
==============================================================================
--- hive/branches/HIVE-8065/ql/src/test/queries/clientpositive/encryption_insert_partition_dynamic.q (original)
+++ hive/branches/HIVE-8065/ql/src/test/queries/clientpositive/encryption_insert_partition_dynamic.q Mon Jan 5 16:32:23 2015
@@ -6,48 +6,52 @@ set hive.enforce.bucketing=true;
-- SORT_QUERY_RESULTS
-- init
-drop table IF EXISTS encryptedWith128BitsKeyDB.encryptedTable;
+drop table IF EXISTS encryptedTable;
drop table IF EXISTS unencryptedTable;
-create table encryptedWith128BitsKeyDB.encryptedTable(value string)
- partitioned by (key string) clustered by (value) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true');
+create table encryptedTable(value string)
+ partitioned by (key string) clustered by (value) into 2 buckets stored as orc
+ location '/build/ql/test/data/warehouse/encryptedTable' TBLPROPERTIES ('transactional'='true');
+CRYPTO CREATE_KEY --keyName key_1 --bitLength 128;
+CRYPTO CREATE_ZONE --keyName key_1 --path /build/ql/test/data/warehouse/encryptedTable;
create table unencryptedTable(value string)
partitioned by (key string) clustered by (value) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true');
-- insert encrypted table from values
-explain extended insert into table encryptedWith128BitsKeyDB.encryptedTable partition (key) values
+explain extended insert into table encryptedTable partition (key) values
('val_501', '501'),
('val_502', '502');
-insert into table encryptedWith128BitsKeyDB.encryptedTable partition (key) values
+insert into table encryptedTable partition (key) values
('val_501', '501'),
('val_502', '502');
-select * from encryptedWith128BitsKeyDB.encryptedTable order by key;
+select * from encryptedTable order by key;
-- insert encrypted table from unencrypted source
explain extended from src
-insert into table encryptedWith128BitsKeyDB.encryptedTable partition (key)
+insert into table encryptedTable partition (key)
select value, key limit 2;
from src
-insert into table encryptedWith128BitsKeyDB.encryptedTable partition (key)
+insert into table encryptedTable partition (key)
select value, key limit 2;
-select * from encryptedWith128BitsKeyDB.encryptedTable order by key;
+select * from encryptedTable order by key;
-- insert unencrypted table from encrypted source
-explain extended from encryptedWith128BitsKeyDB.encryptedTable
+explain extended from encryptedTable
insert into table unencryptedTable partition (key)
select value, key;
-from encryptedWith128BitsKeyDB.encryptedTable
+from encryptedTable
insert into table unencryptedTable partition (key)
select value, key;
select * from unencryptedTable order by key;
-- clean up
-drop table encryptedWith128BitsKeyDB.encryptedTable;
+drop table encryptedTable;
+CRYPTO DELETE_KEY --keyName key_1;
drop table unencryptedTable;
\ No newline at end of file
Modified: hive/branches/HIVE-8065/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-8065/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out?rev=1649581&r1=1649580&r2=1649581&view=diff
==============================================================================
Binary files hive/branches/HIVE-8065/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out (original) and hive/branches/HIVE-8065/ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out Mon Jan 5 16:32:23 2015 differ