Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FT.SEARCH looks to have limitations to find points contained for Polygons with big number values of vertices (Redis Enterprise Software release notes 7.2.4-52 August 2023) #149

Closed
agrimaldi72 opened this issue Apr 26, 2024 · 6 comments
Assignees

Comments

@agrimaldi72
Copy link

agrimaldi72 commented Apr 26, 2024

Description:

  1. I created a Index
  2. I created a hash set for geoshape polygon (square) where vertices values are around 10000000
    HSET shape:6 t "this is in my house" g "POLYGON((10000000 10000000, 15000000 10000000, 15000000 30000000, 10000000 30000000, 10000000 10000000))"
  3. I tried FT.SEARCH and I didn't get expected result (it didn't get any polygon, I expected to see shape:6)
    FT.SEARCH polygon_idx "@g:[CONTAINS $point]" PARAMS 2 point 'POINT(10000002 10000002)' DIALECT 3
  4. I overwrote shape:6 to have vertices with lower numbers
    HSET shape:6 t "this is in my house" g "POLYGON((1000000 1000000, 1500000 1000000, 1500000 3000000, 1000000 3000000, 1000000 1000000))"
  5. I tried FT.SEARCH again and I got expected result (it got shape:6)
  6. I overwrote shape:6 to have a very small square with big number value for vertices in order to lower amount of points and I got no polygon (same as depicted in point 3)
    HSET shape:6 t "this is in my house" g "POLYGON((10000000 10000000, 10000010 10000000, 10000010 10000010, 10000000 10000010, 10000000 10000000))"
    FT.SEARCH polygon_idx "@g:[CONTAINS $point]" PARAMS 2 point 'POINT(10000002 10000002)' DIALECT 3

Scenario:
Running Redis Enterprise Server deployed from RHOCP Operator
Those big numbers for vertices came from trying to use datum Campo Inchauspe for geo
image

@mich-elle-luna
Copy link
Collaborator

Hi thank you for this report, do you have a documentation request? Happy to help if you can give a bit more information about what you need (an answer or an update to he documentation?) You can also use Redis Co-Pilot to ask your question here https://redis.io/chat or refer to https://redis.io/docs/latest/develop/data-types/geospatial/

@agrimaldi72
Copy link
Author

agrimaldi72 commented Apr 27, 2024

I posted the comment as a potential issue (unexpected behaviour), neither documentation nor copilot gave me hints about ft.search specific limitations regarding maximum values to use within geoshape polygons.

@dwdougherty
Copy link
Collaborator

Hey @adrianoamaral ... do you know or can you find out what the limit is for polygon points as related to search?

@dwdougherty dwdougherty self-assigned this May 8, 2024
@adrianoamaral
Copy link
Contributor

adrianoamaral commented May 8, 2024 via email

@dwdougherty
Copy link
Collaborator

@agrimaldi72 Per @adrianoamaral's comment above, please open an issue on the RediSearch repo. Then please close this ticket.

@dwdougherty
Copy link
Collaborator

Closing.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants