BINARY type

  • Article

Applies to: check marked yes Databricks SQL check marked yes 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]