Spring-data-elasticsearch nested query not working

Question

Person.java

@Document(indexName = "person", type = "user")
public class Person {

    @Id
    private String id;

    @Field(type = FieldType.String)
    private String name;

    @Field(type = FieldType.Nested)
    private List<Car> cars;

// getter/setter

}

Car.java

public class Car {

    @Field(type = FieldType.String)
    private String name;

    @Field(type = FieldType.String)
    private String model;

// getter/setter
}

Indexing and Searching using main method

public class SpringElasticSearchTest {

    public static void main(String[] args) {

        ApplicationContext applicationContext = new FileSystemXmlApplicationContext(
                "src/main/webapp/WEB-INF/spring/applicationContext.xml");

        ElasticsearchTemplate est = (ElasticsearchTemplate) applicationContext
                .getBean("elasticsearchTemplate");

        Person pers = new Person();
        pers.setName("Manish");
        pers.setId("1");

        List<Car> cars = new ArrayList<Car>();
        Car subaru = new Car();
        subaru.setName("Tata");
        subaru.setModel("Safari");
        cars.add(subaru);
        pers.setCars(cars);

        IndexQuery indexQuery = new IndexQuery();
        indexQuery.setId(pers.getId());
        indexQuery.setObject(pers);

        est.deleteIndex("person");

        est.createIndex(Person.class);
        est.putMapping(Person.class);
        est.index(indexQuery);
        est.refresh(Person.class, true);

        QueryBuilder builder = nestedQuery(
                "cars",
                boolQuery().must(termQuery("cars.name", "Tata")).must(
                        termQuery("cars.model", "Safari")));
        SearchQuery searchQuery = new NativeSearchQueryBuilder().withQuery(
                builder).build();
        List<Person> persons = est.queryForList(searchQuery, Person.class);
        System.out.println("Person List : " + persons);

    }

Indexing is working fine but searching functionally is not working.
I am getting the following output:

Person List : []

Please suggest. Thanks in advance.

Manish Kumar · Accepted Answer · 2015-02-06 02:56:20Z

3

Finally I find the solution, The query I have built while searching

termQuery("cars.name", "Tata")

should be in lower case so the correct query would be -

QueryBuilder builder = nestedQuery(
                "cars",
                boolQuery().must(termQuery("cars.name", "tata")).must(
                        termQuery("cars.model", "safari")));

answered Feb 6, 2015 at 2:56

Manish Kumar

1433 silver badges12 bronze badges

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

Comments

jbelis · Accepted Answer · 2015-09-29 09:00:09Z

0

Another option would have been to use a matchQuery, which is case-insensitive by default:

QueryBuilders.matchQuery("cars.name", "Tata")

Or you can use an analyzer that does not lower case, unlike the standard one.

related discussion here: https://discuss.elastic.co/t/how-to-do-case-insensitive-search-on-terms/19790

answered Sep 29, 2015 at 9:00

jbelis

7152 gold badges7 silver badges17 bronze badges

Collectives™ on Stack Overflow

Spring-data-elasticsearch nested query not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related