QUANTILE_STATE_FROM_BASE64

Description

Converts a base64 encoded string (usually generated by QUANTILE_STATE_TO_BASE64) to a QUANTILE_STATE type. Returns NULL if the input string is invalid or NULL.

Syntax

QUANTILE_STATE_FROM_BASE64(<input>)

Parameters

Parameter	Description
<input>	A base64 encoded string, usually generated by QUANTILE_STATE_TO_BASE64. Returns NULL if the string is invalid.

Return Value

Returns the quantile_state parsed from the base64 encoding. Returns NULL if the string is invalid.

Examples

select
  quantile_state_to_base64(
    quantile_state_from_base64(
      quantile_state_to_base64(to_quantile_state(1.0, 2048))
    )
  ) = quantile_state_to_base64(to_quantile_state(1.0, 2048)) AS equal_test;

+------------+
| equal_test |
+------------+
|          1 |
+------------+

select quantile_state_from_base64('not_base64!');

+-------------------------------------------+
| quantile_state_from_base64('not_base64!') |
+-------------------------------------------+
| NULL                                      |
+-------------------------------------------+

select quantile_state_from_base64(NULL);

+----------------------------------+
| quantile_state_from_base64(NULL) |
+----------------------------------+
| NULL                             |
+----------------------------------+