Support Questions

Find answers, ask questions, and share your expertise

Hive column encryption

Explorer

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

3 REPLIES 3

Explorer

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

Mentor

@Adi Jabkowsky

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

Explorer

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.