hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6329) Support column level encryption/decryption
Date Tue, 07 Oct 2014 01:32:34 GMT

    [ 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)

Mime
View raw message