HIVE字段简单加密

select 
  '123456789' t
  ,encode('123456789' ,'UTF-8') t1            -- 存储hadoop字段类型binary
  ,base64(cast('123456789' as binary)) t2     -- 存储hadoop字段类型string
  ,md5('123456789') t3                        -- 存储hadoop字段类型string
  ,sha2('123456789',256) t4                   -- 存储hadoop字段类型string
  ,sha2('123456789',224) t5                   -- 存储hadoop字段类型string
;