title: How to convert HEX value to Decimal in HIVE HQL
body: <p>I've got Hive 1.1, and I'm having trouble converting a HEX value into a Decimal or BIGINT.</p>
  
  <p>Using UNHEX('2BD1BCAE0501250E') should return= 3157512269357720846</p>
  
  <p>But instead, I'm getting something like WingDings= +Ѽ�%</p>
  
  <p>I've tried DECODE, ENCODE, BASE64...but nothing seems to be working. Has anyone else tried doing this?  Thanks</p>