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

[BUG] SELECT, WHERE, and GROUP BY on geo_point, ip, ranges, shape, and knn_vector #1781

Open
acarbonetto opened this issue Jun 26, 2023 · 3 comments
Labels
bug Something isn't working

Comments

@acarbonetto
Copy link
Collaborator

What is the bug?
A clear and concise description of the bug.

How can one reproduce the bug?

What is the expected behavior?

We want to be able to SELECT on unsupported complex types (such as geo_point, ip, and knn_vector) so that we can read the data. Adding support for opensearch functions, but the user should be able to do a SELECT * on all datasets.

SELECT * FROM eCommerce 
SELECT geoip.location FROM eCommerce GROUP BY geoip.location

see:
https://github.com/opensearch-project/sql/blob/main/opensearch/src/main/java/org/opensearch/sql/opensearch/data/type/OpenSearchDataType.java

What is your host/environment?

  • OS: [e.g. iOS]
  • Version [e.g. 22]
  • Plugins

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.

@acarbonetto acarbonetto added bug Something isn't working untriaged labels Jun 26, 2023
@acarbonetto
Copy link
Collaborator Author

In triage: Need to figure out supported use cases for this.

@acarbonetto acarbonetto changed the title [BUG] SELECT, WHERE, and GROUP BY on geo_point, ip, and knn_vector [BUG] SELECT, WHERE, and GROUP BY on geo_point, ip, ranges, shape, and knn_vector Jun 26, 2023
@acarbonetto
Copy link
Collaborator Author

geo_point support is being added under #1910
This does not include geo_point objects that do not include lat/lon, such as well-known text (see: https://opensearch.org/docs/2.3/opensearch/supported-field-types/geo-point/)

@acarbonetto
Copy link
Collaborator Author

knn_vector is being supported under #1615

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants