Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive column encryption

Highlighted

Hive column encryption

New Contributor

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

Re: Hive column encryption

New Contributor

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

Re: Hive column encryption

Mentor

@Adi Jabkowsky

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

Re: Hive column encryption

New Contributor

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.