[jira] [Commented] (HIVE-8816) Create unit test join of two encrypted tables with different keys
[ 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
[ 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
[ 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
[ 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
[ 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)