Hi Yupeng, Girish mentioned that you are working on Geo Spatial Indexing in Pinot. Would love to setup a time to brainstorm/discuss.

hey Kishore, yes, i’m looking into it, and had some chat with Xiang, who generously gave me some help

I am adding range Index this week, I will try to simplify the process of adding new Indexes

i did some preliminary research on the geo the support, and will build a simple prototype to determine an appropriate design

then i can share a design proposal with the community

oh, cool. glad to hear that

👍

@User I have a design draft https://docs.google.com/document/d/1Mkm5RHS_tof-vIUt5-UNeOgRYSBAN6M_pN-hedV6Q0g/edit#heading=h.j6a8v4nhmjvn please take a look, and i plan to send it out to the community if it looks good to you

Cool

Will look into it a bit

Hi all, I'm working on creating a schema for a realtime table (using Kafka) and have a geo column which is already formatted in the kafka topic

"location_st_point":{"wkb":"AQEAACDmEAAArS5MS1GXXcD0lychov5AQA==","srid":4326}

Do I need to do a transform on this in the schema?

{
            "dataType": "BYTES",
            "name": "location_st_point",
            "transformFunction": "toSphericalGeography(point)"
         },

Since not a lot of ppl in here I hope it's okay for <!here>

If you do not transform it during ingestion, you can transform it at query time

Does anyone have a working example of using anything other than the stPoint & toSphericalGeography functions?