search

opendistro-for-elasticsearch / sql

🔍 Open Distro SQL Plugin
https://opendistro.github.io/for-elasticsearch/features/SQL%20Support.html
Apache License 2.0
621 stars 186 forks source link

Support for "fuzziness": "AUTO" in sql MATCH_QUERY #1137

Open newUserForTesting opened 3 years ago

newUserForTesting commented 3 years ago

Hello Experts,

This is urgent requirement of supporting "fuzziness": "AUTO" in sql MATCH_QUERY. Currently the Elasticsearch query being generated corresponding to sql query doesn't have "fuzziness": "AUTO" as default option and hence we are not able to perform fuzzy queries.

Requesting to please suggest a workaround for this.

Thanks!

anirudha commented 3 years ago

@newUserForTesting pls review https://github.com/opensearch-project/sql/issues/182

newUserForTesting commented 3 years ago

Thank You Experts! We really appreciate your help in providing more features in new query engine. We are using this project and we just love it! Any tentative timeline by when fuzziness support would be available in new query engine? Again really appreciate your prompt response on this!

chloe-zh commented 3 years ago

This project was started in implementation stage these days, this feature would be ready in our code base very soon, and this feature is good to use if you are fine to pull our latest artifact from the repository. The related issue is https://github.com/opensearch-project/sql/issues/184 to track the progress.

newUserForTesting commented 3 years ago

Our Production Clusters are running on OpenDistro version of Elasticsearch. We recently observed the new OpenSearch initiative. We can't wait to upgrade to OpenSearch version!

But since we have lots of existing Production Clusters and enormous amount of data within it, it wouldn't be happening in immediate near future.

We were thinking of following approach Experts. Please let us know if this could work: On Application Side (client side), we use https://github.com/opensearch-project/sql which has latest features (and upcoming new features as well), convert our sql query to Elasticsearch query on the client side itself (without hitting Elasticsearch since its still on OpenDistro version), and then use the Elasticsearch query to send request to Elasticsearch. Is this approach possible Experts? We really appreciate your help!

newUserForTesting commented 3 years ago

Could someone please assist in the above query? Really appreciate your help.