Otherwise if the number is a STRING, it converts each character into its hexadecimal representation and returns the resulting STRING. (See <a href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_hex,">http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_hex,</a> BINARY version as of Hive 0.12.0.)BINARYunhex(STRING a)Inverse of hex.