Elasticsearch Java api - Select query for searching text mixed with special characters(John-son)

Question

I have two users in my db collection and those names are john and john-son , now I am trying to select all records which are matching with my search text among all fields of db collection. For example my search text is john then my query is by using elasticsearch java api

QueryBuilder queryBuilderForUserSearch = QueryBuilders.must(
        QueryBuilders.fieldQuery("_all", "*" + q + "*"));

It's working fine. But when I am trying to search with special character text like john-son by this time it returns zero records. Can anybody please help me why it's happens and please provide the query for select text with special characters also.

Community · Accepted Answer · 2017-05-23 10:31:41Z

1

The problem you have is largely the same as in this question: Elasticsearch wildcard search on not_analyzed field

First, you really don't want to have leading wildcards in your query. Lucene will have to go through every term in your index's dictionary to find terms. This is O(n) in the number of terms, which gets prohibitively expensive. See this article for more details: http://www.found.no/foundation/elasticsearch-from-the-bottom-up/

What's probably happening here is that john-son is tokenized to john and son via the standard-analyzer. Therefore, there is no john-son term in the dictionary for your wildcard query to match.

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Jan 24, 2014 at 15:38

Alex Brasetvik

11.8k2 gold badges40 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Elasticsearch Java api - Select query for searching text mixed with special characters(John-son)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related