BINARY
type
Applies to: Databricks SQL Databricks Runtime
Represents byte sequence values.
Limits
The type supports byte sequences of any length greater or equal to 0.
Literals
X { 'num [ ... ]' | "num [ ... ]" }
num
: Any hexadecimal number from 0 to F.
The prefix X
is case insensitive.
If the hexadecimal string literal has an odd length the parser prepends a 0.
Examples
> SELECT X'1';
[01]
> SELECT X'1ABF';
[1A BF]
> SELECT X'';
[ ]
> SELECT CAST('Spark' AS BINARY);
[53 70 61 72 6B]