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