BINARY
type
Applies to: Databricks SQL
Databricks Runtime
Represents byte sequence values.
Syntax
BINARY
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]
Related
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om