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

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

h3_resolution function | Databricks Documentation

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above

Returns the resolution of the input H3 cell.

h3_resolution ( h3CellIdExpr )

• h3CellIdExpr: A BIGINT expression, or a hexadecimal STRING expression representing an H3 cell ID.

A value of whose type INT between 0 and 15, that is the resolution of the input H3 cell ID.

The function returns NULL if the input is NULL. The function does partial validation regarding whether the input argument is a valid H3 cell ID. A necessary, but not sufficient condition for a valid H3 ID is that its value is between 0x08001fffffffffff and 0x08ff3b6db6db6db6. The behavior of the function is undefined if the input cell ID is not a valid cell ID.

• If h3CellIdExpr is a STRING that cannot be converted to a BIGINT or corresponds to a BIGINT value that is smaller than 0x08001fffffffffff or larger than 0x08ff3b6db6db6db6, the function returns H3_INVALID_CELL_ID.

SQL

-- Simple example taking a long as input.
> SELECT h3_resolution(599686042433355775)
  5

-- Simple example taking a hexadecimal string as input.
> SELECT h3_resolution('85283473fffffff')
  5

-- Input is an invalid H3 cell ID.
> SELECT h3_resolution(0)
  [H3_INVALID_CELL_ID] 0 is not a valid H3 cell ID

• h3_maxchild function
• h3_minchild function
• h3_tochildren function
• h3_toparent 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