Skip to main content

H3_TO_CHILDREN

Returns the indexes contained by h3 at resolution child_res.

Syntax

H3_TO_CHILDREN(h3, child_res)

Examples

SELECT H3_TO_CHILDREN(635318325446452991, 14);

┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ h3_to_children(635318325446452991, 14)
├────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
[639821925073823431,639821925073823439,639821925073823447,639821925073823455,639821925073823463,639821925073823471,639821925073823479]
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today