FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedJan 5, '15 at 4:32p
activeJan 5, '15 at 4:32p
posts1
users1
websitehive.apache.org

1 user in discussion

Brock: 1 post

People

Translate

site design / logo © 2021 Grokbase