I want to convert ascii value to its character in hive.Is there any existing function in a hive (like we have char function in SQL server).Does anyone knows how to achieve this in a hive?
For Example: For 65 , result would be A.
Thanks in advance.
This is possible by combining a few of the built in functions:
Select decode(unhex(hex(65)), 'US-ASCII');
hex
changes the int value to a Hexadecimal string, while unhex
changes this to binary. then decode
interprets the binary as ASCII data.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With