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

Showing content from https://docs.databricks.com/aws/en/error-messages/h3-invalid-resolution-value-error-class below:

H3_INVALID_RESOLUTION_VALUE error class | Databricks Documentation

SQLSTATE: 22023

H3 resolution <r> must be between <minR> and <maxR>, inclusive

• h3Cell: An input value that was expected to correspond to a valid H3 cell ID.
• r: The actual resolution value (an INTEGER), passed to the SQL function.
• minR: The minimum acceptable resolution (an INTEGER) in the context of the SQL function (usually 0).
• maxR: The maximum acceptable resolution (an INTEGER) in the context of the SQL function (usually 15).

Functions that emit this error expect a valid H3 resolution value. Valid H3 resolution values are between 0 and 15. Some SQL functions may restrict the range even further based on the function's context.

SQL

-- Invoking h3_longlatash3 with a resolution that is out of the valid range.
> SELECT h3_longlatash3(40, -120, 16);
  [H3_INVALID_RESOLUTION_VALUE] H3 resolution 16 must be between 0 and 15, inclusive

-- Invoking h3_toparent with a resolution that is larger than the input cell's resolution.
> SELECT h3_toparent(599686042433355775, h3_resolution(599686042433355775) + 1);
  [H3_INVALID_RESOLUTION_VALUE] H3 resolution 6 must be between 0 and 5, inclusive

• h3_coverash3 function
• h3_coverash3string function
• h3_longlatash3 function
• h3_longlatash3string function
• h3_maxchild function
• h3_minchild function
• h3_pointash3 function
• h3_pointash3string function
• h3_polyfillash3 function
• h3_polyfillash3string function
• h3_tessellateaswkb function
• h3_tochildren function
• h3_toparent function
• h3_try_coverash3 function
• h3_try_coverash3string function
• h3_try_tessellateaswkb function
• h3_uncompact function

• h3_resolution 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