CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseAtualizado 01/11/2024
BINARY
type Applies to: Databricks SQL Databricks Runtime
Represents byte sequence values.
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.
> SELECT X'1';
[01]
> SELECT X'1ABF';
[1A BF]
> SELECT X'';
[ ]
> SELECT CAST('Spark' AS BINARY);
[53 70 61 72 6B]