bziobrowski opened a new pull request, #14628:
URL: https://github.com/apache/pinot/pull/14628

   PR fixes H3IndexFilterOperator's accuracy when used with ST_Distance 
function.
   
   Calculations in master branch are inaccurate because:
   - hexagon size in is not constant per level, so using average value could 
lead to including too many points without verifying actual distances 
   - distance between given point (e.g.hexagon center) and center's of n-th 
ring or hexagons is not uniform and varies greatly for large values of N
   
   Example: 
   ```sql
   SELECT COUNT(*) 
   FROM testTable 
   WHERE ST_Distance(indexed_point, ST_Point(-122, 37.5, 1)) <  10000
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org

Reply via email to