[HIVE-10644] create SHA2 UDF

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: UDF
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 07/May/15 17:34
• Updated: 16/Feb/16 23:52
• Resolved: 20/May/15 06:28

Description

Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and SHA-512). The first argument is the cleartext string to be hashed. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either argument is NULL or the hash length is not one of the permitted values, the return value is NULL.

MySQL also has SHA2 function https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_sha2

Issue Links

• relates to: HIVE-1262 Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and aes_decrypt
• relates to: HIVE-10639 create SHA1 UDF
• links to: http://en.wikipedia.org/wiki/SHA-2
• links to: https://reviews.apache.org/r/33968/