zstd_decompress function

Applies to: Databricks SQL Databricks Runtime 15.2 and above

Returns value decompressed with Zstandard compression. On decompression failure, it throws an exception.

Syntax

zstd_decompress ( value )

Arguments

• value: The binary value compressed with Zstandard that needs to be decompressed.

Returns

Decompressed value of type BINARY.

If value is not a valid ZSTD compressed value, Azure Databricks raises INVALID_PARAMETER_VALUE.ZSTD_DECOMPRESS_INPUT. To return NULL instead, use the try_zstd_decompress function.

Common error conditions

• INVALID_PARAMETER_VALUE.ZSTD_DECOMPRESS_INPUT

Examples

> SELECT string(zstd_decompress(unbase64("KLUv/SCCpQAAaEFwYWNoZSBTcGFyayABABLS+QU=")));
  Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark Apache Spark
> SELECT string(zstd_decompress(zstd_compress("Apache Spark")));
  Apache Spark
> SELECT zstd_decompress(x'DEADBEEF');
  Error: INVALID_PARAMETER_VALUE.ZSTD_DECOMPRESS_INPUT

Related functions

• zstd_compress function
• try_zstd_decompress function