Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

Hive column encryption

avatar
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

avatar
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

avatar
Mentor

@Adi Jabkowsky

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

avatar
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.

Labels