hi, I would like to index segments (linestring) in...
# generala
alon
07/01/2022, 5:13 AMhi, I would like to index segments (linestring) in pinot. and by given point search the closest segments. ( each segment have an id )
How to index my segements in the schema?
m
Mayank
07/01/2022, 2:44 PM
I am unclear, but sounds like you might be talking about GeoSpatial indexing? https://docs.pinot.apache.org/basics/indexing/geospatial-support
a
alon
07/03/2022, 6:30 AMyes I know 🙂
but pinot have only point indexing, and not Linestring for example,
am I right? or I misunderstood something?
In my use case I have road segments (Linestring) and I would like to index them , and make queries like.
by given point give all the segements in 5 meters raduis.
m
Mayank
07/04/2022, 11:25 AM
@Yupeng Fu ^^
y
Yupeng Fu
07/04/2022, 11:54 AMNot directly
Yupeng Fu
07/04/2022, 11:54 AMBut you can create h3 index per segment and use that for retrieval
a
alon
07/04/2022, 12:51 PMhow?
alon
07/04/2022, 12:51 PMwhat do you mean? how to create h3 index per segment? and how to save it in apache pinot? in what field type?
alon
07/04/2022, 12:52 PM@Yupeng Fu
y
Yupeng Fu
07/04/2022, 1:19 PMyou need to use h3 functions https://h3geo.org/docs/api/regions
a
alon
07/04/2022, 1:48 PMand? how I index it in pinot?
alon
07/04/2022, 1:50 PMas bytes? like here that?
and when I query this field how do pinot know this is geometry field that should be queried by h3 index?
alon
07/04/2022, 1:52 PManother question, this is only polygons, I need linestring.
alon
07/04/2022, 2:48 PM@Kishore G maybe you can have answers? 🙂