Spring Data api (Containing or startwith) not working with SPACE which has wildcard

Question

I am using Elastic Search with Spring Data .

I have a simple method in repository:

findByUserNameContaining("a b");

This method not giving expecting result because of SPACE.

Error getting:

"Cannot constructQuery '"a b"'. Use expression or multiple clauses instead." EXCEPTION="org.springframework.dao.InvalidDataAccessApiUsageException: Cannot constructQuery '"a b"'. Use expression or multiple clauses instead.

For stopping creation of multiple tokens because of Space. I have mapping:

"userName": {
    "type": "string",
    "index": "not_analyzed"
},

I am totally surprised that I am getting this issue after "index": "not_analyzed" in mapping .

Please help me. Thanks in advance!

Hi, when you make your field not analyzed you're actually storing the "raw" field in elasticsearch as you probably know. This error you're getting is "before" your query even being sent to elasticsearch, it's a spring data validation applied for wildcard query methods as you can see at: https://github.com/spring-projects/spring-data-elasticsearch/blob/7f995b38f9a932ba59c3f82e8775161d28139748/src/main/java/org/springframework/data/elasticsearch/core/query/Criteria.java — groo, Apr 03 '17 at 12:13
Hi ,Thanks for your response , cant we avoid this exception ? I need to use containing method with string having space . — Vijay, Apr 04 '17 at 05:50
You're probably looking for a match phrase query that would do what you want: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-query-phrase.html But AFAIK this is not available out of the box in spring-data-elasticsearch so you need to implement a custom method: http://docs.spring.io/spring-data/elasticsearch/docs/current/reference/html/#repositories.custom-implementations where you have access to elastic java API and can implement what you need. If you post a bit more information about your mapping and need I might be able to do an answer with code — groo, Apr 04 '17 at 06:03

score 3 · Accepted Answer · answered Apr 10 '17 at 11:27

Actually Spring data apis (containing or startWith) does not work with space in String . I have implemented same with Elastic core api.

NativeSearchQueryBuilder aNativeSearchQueryBuilder = new NativeSearchQueryBuilder();
        aNativeSearchQueryBuilder.withIndices(indexName).withTypes(type);
        final BoolQueryBuilder aQuery = new BoolQueryBuilder();

            aQuery.must(QueryBuilders.queryStringQuery("a b").defaultField("UserName"));

NativeSearchQuery nativeSearchQuery = aNativeSearchQueryBuilder.withQuery(aQuery).build();
        List<Object> aDatas = elasticsearchTemplate.queryForList(nativeSearchQuery, Object.class);

When I use this and search for `b`, no results appear. Only when I search for `a` or `a b`, results appear. Seems like query works for a prefix match. — Shubham A., Jun 02 '17 at 10:07

Ant · Answer 2 · 2017-10-12T10:42:57.863

0

You have to mask the spaces:

findByUserNameContaining("a\\ b");

edited Oct 12 '17 at 10:42

answered Oct 12 '17 at 07:53

Ant

1
1

score 0 · Answer 3 · answered Jan 22 '21 at 03:57

0

In my case I just needed to url encode the string so when searching for "a b" just encode it so it becomes "a%20b" then query will be built.

I am using latest springboot version 2.3.*

answered Jan 22 '21 at 03:57

mark ortiz

659
1
6
13

score 0 · Answer 4 · answered Feb 16 '21 at 15:27

This can be implemented using the expression method in Criteria API

with quotes around the search text for an exact match

criteria.and(new Criteria("FieldName").expression("\"" + SEARCH_TEXT_WITH_SPACE + "\""));

with asterisk around the search text for the wild card match

criteria.and(new Criteria("FieldName").expression("*" + SEARCH_TEXT_WITH_SPACE + "*"));

Spring Data api (Containing or startwith) not working with SPACE which has wildcard

4 Answers4

Linked