Convert Ascii value to Character in hive
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.