Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Geo function in aggregate query throws exception #1075

Open
dai-chen opened this issue Mar 16, 2021 · 0 comments
Open

Geo function in aggregate query throws exception #1075

dai-chen opened this issue Mar 16, 2021 · 0 comments
Labels
enhancement New feature or request SQL

Comments

@dai-chen
Copy link
Member

Because geo function support is missing in new engine, the following falls back to old engine which cannot handle. May need to add support for common geo functions.

SELECT sum(id) AS id FROM index WHERE GEO_INTERSECTS(geo, '\''POLYGON ((102 2, 103 2, 103 3, 102 3, 102 2))'\'')
{
  "error": {
    "reason": "Invalid SQL query",
    "details": "unsupported method: geo_intersects",
    "type": "SqlParseException"
  },
  "status": 400
}
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request SQL
Projects
None yet
Development

No branches or pull requests

1 participant