Hive column encryption

[#1]

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

[#2]

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.

apache-ranger-and-hive-column-level-security

hope this helps

[#3]

@Adi Jabkowsky

That Jira you are pointing to is unresolved hence not a solution, For centralized authorization, you should look at Ranger .

[#4]

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.