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

[newUserForTesting]

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]

@newUserForTesting pls review opensearch-project/sql#182

[newUserForTesting]

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]

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 opensearch-project/sql#184 to track the progress.

[newUserForTesting]

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]

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