[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys

2014-12-30 Thread Brock Noland (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-8816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14261586#comment-14261586
 ] 

Brock Noland commented on HIVE-8816:


HI [~spena],

Thank you for updating the patch with the new changes! Since [~Ferd] was 
already working on this I am going to keep it assigned to him. I see there is 
an additional fix {{keyProvider.flush();}} in this patch? Could you fix that in 
a separate issue?

[~Ferd] - could you review Sergio's update and let me know what you think. 

 Create unit test join of two encrypted tables with different keys
 -

 Key: HIVE-8816
 URL: https://issues.apache.org/jira/browse/HIVE-8816
 Project: Hive
  Issue Type: Sub-task
Reporter: Brock Noland
Assignee: Sergio Peña
 Fix For: encryption-branch

 Attachments: HIVE-8816.1.patch, HIVE-8816.3.patch, HIVE-8816.patch


 NO PRECOMMIT TESTS
 The results should be inserted into a third table encrypted with a separate 
 key.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys

2014-12-30 Thread Brock Noland (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-8816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14261592#comment-14261592
 ] 

Brock Noland commented on HIVE-8816:


[~Ferd] FYI I just committed HIVE-9231 to branch thus the {{keyprovider.flush}} 
will need to be removed from this patch.

 Create unit test join of two encrypted tables with different keys
 -

 Key: HIVE-8816
 URL: https://issues.apache.org/jira/browse/HIVE-8816
 Project: Hive
  Issue Type: Sub-task
Reporter: Brock Noland
Assignee: Ferdinand Xu
 Fix For: encryption-branch

 Attachments: HIVE-8816.1.patch, HIVE-8816.3.patch, HIVE-8816.patch


 NO PRECOMMIT TESTS
 The results should be inserted into a third table encrypted with a separate 
 key.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys

2014-12-30 Thread Ferdinand Xu (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-8816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14261731#comment-14261731
 ] 

Ferdinand Xu commented on HIVE-8816:


[~brocknoland], I am working on this jira and blocking by the encryption zones 
inconsistent issue. In details, the encryption zone list is empty when I try to 
get it in Hive.java. I am think it may be related to HIVE-9231. I will rebase 
my code and have a try again.

 Create unit test join of two encrypted tables with different keys
 -

 Key: HIVE-8816
 URL: https://issues.apache.org/jira/browse/HIVE-8816
 Project: Hive
  Issue Type: Sub-task
Reporter: Brock Noland
Assignee: Ferdinand Xu
 Fix For: encryption-branch

 Attachments: HIVE-8816.1.patch, HIVE-8816.3.patch, HIVE-8816.patch


 NO PRECOMMIT TESTS
 The results should be inserted into a third table encrypted with a separate 
 key.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys

2014-12-18 Thread Brock Noland (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-8816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14252225#comment-14252225
 ] 

Brock Noland commented on HIVE-8816:


Thank you! I think we want to do:

{noformat}
EXPLAIN EXTENDED SELECT * FROM 
encryptedWith256BitsKeyDB.encryptedTableIn256BitsKey t1
JOIN encryptedWith128BitsKeyDB.encryptedTableIn128BitsKey t2 WHERE t1.key = 
t2.key;
{noformat}

then in the same q-file:

actually execute the join:
{noformat}
SELECT * FROM encryptedWith256BitsKeyDB.encryptedTableIn256BitsKey t1
JOIN encryptedWith128BitsKeyDB.encryptedTableIn128BitsKey t2 WHERE t1.key = 
t2.key;
{noformat}

Also please add {{--SORT_QUERY_RESULTS}} since different JVM's or execution 
engines could order results differently.

 Create unit test join of two encrypted tables with different keys
 -

 Key: HIVE-8816
 URL: https://issues.apache.org/jira/browse/HIVE-8816
 Project: Hive
  Issue Type: Sub-task
Reporter: Brock Noland
Assignee: Ferdinand Xu
 Fix For: encryption-branch

 Attachments: HIVE-8816.1.patch, HIVE-8816.patch


 NO PRECOMMIT TESTS
 The results should be inserted into a third table encrypted with a separate 
 key.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys

2014-12-16 Thread Brock Noland (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-8816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14248504#comment-14248504
 ] 

Brock Noland commented on HIVE-8816:


Can we add {{explain extended}} and then verify in the {{.out.orig}} file that 
the {{.hive-staging}} used is inside the table with the stronger key?

 Create unit test join of two encrypted tables with different keys
 -

 Key: HIVE-8816
 URL: https://issues.apache.org/jira/browse/HIVE-8816
 Project: Hive
  Issue Type: Sub-task
Reporter: Brock Noland
Assignee: Ferdinand Xu
 Fix For: encryption-branch

 Attachments: HIVE-8816.patch


 NO PRECOMMIT TESTS
 The results should be inserted into a third table encrypted with a separate 
 key.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)