hex function
Applies to: 
Databricks SQL Databricks Runtime
Converts expr to hexadecimal.
Syntax
hex(expr)
Arguments
expr: A BIGINT, BINARY, or STRING expression.
Returns
A STRING.
The function returns the hexadecimal representation of the argument.
Examples
SQL
> SELECT hex(17);
11
> SELECT hex('Spark SQL');
537061726B2053514C