[
https://issues.apache.org/jira/browse/HIVE-6329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14110938#comment-14110938
]
Larry McCay commented on HIVE-6329:
-----------------------------------
Hi [~navis] - It seems to me that we need to have some sort of AES encryption
with proper key management and initialization capabilities in order to consider
this ready for inclusion in Apache. If this is already being done then I may
just be missing where it is in the patch. You made comments earlier on the jira
about acquiring private keys over SSL - I don't see these being acquired or
used in the patch either.
Is there a companion jira that I need to see?
Perhaps, a high level design document would be helpful in communicating your
intent and in teasing out all of the requirements for key management,
initialization and usage for this feature?
> 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.2#6252)
