Skip to main content

H3_DISTANCE

Returns the grid distance between the the given two H3 indexes.

Syntax

H3_DISTANCE(h3, a_h3)

Examples

SELECT H3_DISTANCE(599119489002373119, 599119491149856767);

┌─────────────────────────────────────────────────────┐
│ h3_distance(599119489002373119, 599119491149856767)
├─────────────────────────────────────────────────────┤
1
└─────────────────────────────────────────────────────┘
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