Created 12-24-2018 05:16 PM
I'm looking for a way to encrypt a column in hive. I know that using kms I can encrypt entire tables and/or data on hdfs, but looking for an efficient way to encrypt a specific column.
I came across this https://issues.apache.org/jira/plugins/servlet/mobile#issue/HIVE-8049
Has anyone tried this or familiar with encrypting a column in hive?
Thanks in advance
Created 12-25-2018 07:08 AM
i found the following post "data-encryption-on-hive-table-using-ranger-kms" this document describes a kms/spark/hive data flow.
i also know that ranger can restrict user access to a column and masking the data in a few ways. a good guide can be found here.
apache-ranger-and-hive-column-level-security
hope this helps
Created 12-25-2018 07:24 AM
That Jira you are pointing to is unresolved hence not a solution, For centralized authorization, you should look at Ranger .
Created 12-25-2018 07:55 AM
Thank you both for your insights!
Using Ranger i can mask data in hive but it's different than actual encryption so Ranger as-is is not a solution for my scenario.
@Raymond Honderdors thank you for that flow, i will give it a deeper thought.