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
HI @Adi Jabkowsky
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.
hope this helps
That Jira you are pointing to is unresolved hence not a solution, For centralized authorization, you should look at Ranger .
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.