Monday 12 September 2022

Hive: hex(string): Convert each character into hexa format

Signature

hex(string)

 

hive> SELECT hex('A');
OK
_c0
41
Time taken: 0.053 seconds, Fetched: 1 row(s)
hive> SELECT hex('AB');
OK
_c0
4142
Time taken: 0.058 seconds, Fetched: 1 row(s)
hive> SELECT hex('ABC');
OK
_c0
414243
Time taken: 0.042 seconds, Fetched: 1 row(s)

 

 

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment