Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6329

Support column level encryption/decryption

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Patch Available
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Receiving some requirements on encryption recently but hive is not supporting it. Before the full implementation via HIVE-8065, this might be useful for some cases.

      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> 
      

      Attachments

        1. HIVE-6329.1.patch.txt
          91 kB
          Navis Ryu
        2. HIVE-6329.10.patch.txt
          132 kB
          Navis Ryu
        3. HIVE-6329.11.patch.txt
          165 kB
          Navis Ryu
        4. HIVE-6329.2.patch.txt
          98 kB
          Navis Ryu
        5. HIVE-6329.3.patch.txt
          98 kB
          Navis Ryu
        6. HIVE-6329.4.patch.txt
          116 kB
          Navis Ryu
        7. HIVE-6329.5.patch.txt
          116 kB
          Navis Ryu
        8. HIVE-6329.6.patch.txt
          125 kB
          Navis Ryu
        9. HIVE-6329.7.patch.txt
          125 kB
          Navis Ryu
        10. HIVE-6329.8.patch.txt
          133 kB
          Navis Ryu
        11. HIVE-6329.9.patch.txt
          129 kB
          Navis Ryu

        Issue Links

          Activity

            People

              navis Navis Ryu
              navis Navis Ryu
              Votes:
              4 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated: