You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/10/07 03:32:34 UTC
[jira] [Commented] (HIVE-6329) Support column level
encryption/decryption
[ https://issues.apache.org/jira/browse/HIVE-6329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14161328#comment-14161328 ]
Navis commented on HIVE-6329:
-----------------------------
[~Huang Xiaomeng] Sorry to miss this. I should unsubscribe some mailing lists.
bq. if you use Base64WriteOnly to encode your values, then how to get the plaintext?
It's not for generic use. Just for showing it's encoded properly for qtest result.
bq. If this approach make sense to you
I really wish I had enough knowledge to say something on your good suggestion. On security related issues like this, [~thejas] might have some plan.
> Support column level encryption/decryption
> ------------------------------------------
>
> Key: HIVE-6329
> URL: https://issues.apache.org/jira/browse/HIVE-6329
> Project: Hive
> Issue Type: New Feature
> Components: Security, Serializers/Deserializers
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-6329.1.patch.txt, HIVE-6329.10.patch.txt, HIVE-6329.11.patch.txt, HIVE-6329.2.patch.txt, HIVE-6329.3.patch.txt, HIVE-6329.4.patch.txt, HIVE-6329.5.patch.txt, HIVE-6329.6.patch.txt, HIVE-6329.7.patch.txt, HIVE-6329.8.patch.txt, HIVE-6329.9.patch.txt
>
>
> Receiving some requirements on encryption recently but hive is not supporting it. Before the full implementation via HIVE-5207, this might be useful for some cases.
> {noformat}
> hive> create table encode_test(id int, name STRING, phone STRING, address STRING)
> > ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
> > WITH SERDEPROPERTIES ('column.encode.columns'='phone,address', 'column.encode.classname'='org.apache.hadoop.hive.serde2.Base64WriteOnly') STORED AS TEXTFILE;
> OK
> Time taken: 0.584 seconds
> hive> insert into table encode_test select 100,'navis','010-0000-0000','Seoul, Seocho' from src tablesample (1 rows);
> ......
> OK
> Time taken: 5.121 seconds
> hive> select * from encode_test;
> OK
> 100 navis MDEwLTAwMDAtMDAwMA== U2VvdWwsIFNlb2Nobw==
> Time taken: 0.078 seconds, Fetched: 1 row(s)
> hive>
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)