[ https://issues.apache.org/jira/browse/HIVE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13745443#comment-13745443 ]
Arup Malakar commented on HIVE-4911: ------------------------------------ I thought I will add the performance numbers I have seen here for reference. In my testing I have observed that with auth-conf the amount of time taken to transfer data is {color:red}~2.3 times{color} the time it takes without encryption. In my test I have a table of size *1GB*, and I did "select *" on the table using the jdbc driver once with encryption and once without encryption. Time taken: * No encryption: *~9 minutes* * Encryption: *~20 minutes* I was wondering if anyone has experience with SASL encryption, if it is possible to tune any JVM/SASL settings to bring down this time. I am also interested in understanding if it is advisable to use a different crypto provider than the default one that ships with the JDK. If this much overhead is to be expected with encryption methods I would like to know that too. I am using patched version of _hive-10_ with _Hive Server 2_ on _hadoop 23/jdk 1.7/RHEL 5_. PS: This comment is a repost of a mail I sent out to hive-dev mailing list. > Enable QOP configuration for Hive Server 2 thrift transport > ----------------------------------------------------------- > > Key: HIVE-4911 > URL: https://issues.apache.org/jira/browse/HIVE-4911 > Project: Hive > Issue Type: New Feature > Reporter: Arup Malakar > Assignee: Arup Malakar > Fix For: 0.12.0 > > Attachments: 20-build-temp-change-1.patch, > 20-build-temp-change.patch, HIVE-4911-trunk-0.patch, HIVE-4911-trunk-1.patch, > HIVE-4911-trunk-2.patch, HIVE-4911-trunk-3.patch > > > The QoP for hive server 2 should be configurable to enable encryption. A new > configuration should be exposed "hive.server2.thrift.rpc.protection". This > would give greater control configuring hive server 2 service. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira