Convert from hexadecimal to string

Supported in: Batch, Streaming

Inverse of hex, interprets each pair of characters as a hexadecimal number and converts to the utf-8 string of the byte representation of the number.

Expression categories: String

Declared arguments

• Expression - String column to unhex.
  Expression<String>

Output type: String

Examples

Example 1: Base case

Argument values:

• Expression: string_hex

---

Example 2: Null case

Argument values:

• Expression: null

---