I'm comparing ES search results with SQL.
ES version is 2.4.2.
Is there exactly same query with SQL LIKE clause?
I use wildcatd with * but it returns lots of similar words, not only exact partial match.
I'm using it in Japanese.
I'm comparing ES search results with SQL.
ES version is 2.4.2.
Is there exactly same query with SQL LIKE clause?
I use wildcatd with * but it returns lots of similar words, not only exact partial match.
I'm using it in Japanese.
You need to understand first how elasticsearch is working behind the scene.
I'd encourage you reading https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-analysis.html
Then, don't use wildcard unless you really have a use case for it.
Use match queries and provide the right analyzer for your use case.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.