Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/functions/h3_isvalid below:

h3_isvalid function | Databricks Documentation

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above

Returns true if the input BIGINT or STRING is a valid H3 cell ID.

• expr: A BIGINT expression, or a STRING expression.

A value of type BOOLEAN, indicating whether the input BIGINT or STRING corresponds to a valid H3 cell ID or not.

The function returns NULL if the input is NULL.

SQL

-- Simple example taking a long as input.
> SELECT h3_isvalid(599686042433355775)
  true

-- Simple example taking a valid hexadecimal string as input.
> SELECT h3_isvalid('85283473fffffff')
  true

-- Example taking a long as input that is not a valid H3 cell ID.
> SELECT h3_isvalid(599686042433355776)
  false

-- Example where the input is an invalid hexadecimal string.
> SELECT h3_isvalid('I am not an H3 cell ID')
  false

• h3_ispentagon function
• h3_try_validate function
• h3_validate function

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4