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

Support column level encryption/decryption

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Patch Available
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      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.

      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

              • Assignee:
                navis Navis Ryu
                Reporter:
                navis Navis Ryu
              • Votes:
                4 Vote for this issue
                Watchers:
                17 Start watching this issue

                Dates

                • Created:
                  Updated: