H3_INVALID_RESOLUTION_VALUE error class

SQLSTATE: 22023

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

Parameters

• 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).

Explanation

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.

Examples

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

Functions emitting this error class

• 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

Related

• h3_resolution function