h3_validate
function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns the input value, that is of type BIGINT or STRING, if it corresponds to a valid H3 cell ID, or emits an error otherwise. In the case of STRING input, any leading zeros are trimmed.
Arguments
h3CellIdExpr
: A BIGINT expression, or a STRING expression that is expected to represent a valid H3 cell ID.
Returns
A value of the same type as the type of the h3CellIdExpr
expression, and equal to the value of the input h3CellIdExpr
expression. In the case of STRING input, any leading zeros are trimmed.
The function returns NULL if the input is NULL.
Error conditions
If
h3CellIdExpr
is not a valid H3 cell ID, the function returns H3_INVALID_CELL_ID.
Examples
-- Simple example taking a long as input.
> SELECT h3_validate(590112357393367039)
590112357393367039
-- Simple example taking a hexadecimal string as input.
> SELECT h3_validate('85283473fffffff')
85283473fffffff
-- Example taking a long as input that is not a valid H3 cell ID.
> SELECT h3_validate(599686042433355776)
[H3_INVALID_CELL_ID] 599686042433355776 is not a valid H3 cell ID
-- Example where the input is an invalid hexadecimal string.
> SELECT h3_validate('I am not an H3 cell id')
[H3_INVALID_CELL_ID] 'I am not an H3 cell id' is not a valid H3 cell ID