Spring Data ElasticSearch using QueryDSL | Java Techie

Amazing video again! Thank you for that! Could you upload a video about parsing a JSON file using spring boot? Thank you!

Amazing Job!
I have one question that why you did not use Spring Boot 2? There is no node builder in the latest elastic version and there is no other way to do the same stuff with the latest elasticsearch and spring boot 2??

Nice tutorial. You should make a extended course on Udemy

sir my program executed .there was a problem in spring suite .but now when I send POST in postman it is giving 404 not found error ./Getindex..please helpppppop

Hi ,How to achieve the Facet ,When I search I need to get highlighted,and I need to get the suggestions

It's possible make a "query + aggregations" using Spring data elasticsearch?

Very nice tutorial.
but how can we connect to the datasource to get data in elasticsearch??

hey in the last video why did we not need the config class?

I followed your tutorial thoughrouhy but at the time of running the program it's showing application couldn't start i think because of version changing of my spring boot can you tell me any alternative so that i can get rid of this my version is 2.2.4

Thank you, brother, you are super

Thank you !

can we connect to the datasource to get data in elasticsearch and perform search operations .. Please tell me @javaTechie

Why jna dependency is required !

Can make video for JPA projections , JPA transaction and JPA query DSL . please

Sir how it is done using latest spring version ? I mean full text search ,

what is the alternate solution if we don't want to lower spring version

Hello Sir,

Could you please create a video for below use case, I need your help for below use case. By watching your videos got some clarity on spring data elastic search.

Use case :-

Say, We have a movie booking application where I want to fetch the movies in sorted order based on most visited / search movies by user and most visited global movies with out user login.

For this may need to implement logic to get max score and document wise scores but I am not aware with this how to do in springboot.

Thanks in Advance

so there is no need to create indexes?

thanks bhai

Very helpful video< Thanks keep it up

I am using Spring Boot 2.2.7.RELEASE and Java 8, which version of elastic search we should be using ?

How to enable elastic query logs?

With Spring Boot 2 there is some changes required :

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.elasticsearch.core.SearchHits;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;


@RestController
public class QueryDSLController {


@Autowired
private QueryDSLService service;

@GetMapping("/serachMultiField/{firstname}/{age}")
public SearchHits<Customer> serachByMultiField(@PathVariable String firstname, @PathVariable int age) {
return service.searchMultiField(firstname, age);
}

@GetMapping("/customSearch/{firstName}")
public SearchHits<Customer> getCustomerByField(@PathVariable String firstName) {
return service.getCustomerSerachData(firstName);
}

@GetMapping("/search/{text}")
public SearchHits<Customer> doMultimatchQuery(@PathVariable String text) {
return service.multiMatchQuery(text);
}

}

-----------------------------------

import org.elasticsearch.index.query.MultiMatchQueryBuilder;
import org.elasticsearch.index.query.QueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.elasticsearch.core.ElasticsearchRestTemplate;
import org.springframework.data.elasticsearch.core.SearchHits;
import org.springframework.data.elasticsearch.core.query.NativeSearchQuery;
import org.springframework.data.elasticsearch.core.query.NativeSearchQueryBuilder;
import org.springframework.stereotype.Service;



@Service public class QueryDSLService {

@Autowired private ElasticsearchRestTemplate template;

public SearchHits<Customer> searchMultiField(String firstname, int age) {

QueryBuilder query = QueryBuilders.boolQuery().must(QueryBuilders.matchQuery("firstname", firstname))
.must(QueryBuilders.matchQuery("age", age));

NativeSearchQuery nativeSearchQuery = new NativeSearchQueryBuilder().withQuery(query).build();
SearchHits<Customer> customers = template.search(nativeSearchQuery, Customer.class);
return customers;
}

public SearchHits<Customer> getCustomerSerachData(String input) {
String search = ".*" + input + ".*";
NativeSearchQuery searchQuery = new NativeSearchQueryBuilder()
.withFilter(QueryBuilders.regexpQuery("firstname", search)).build();
SearchHits<Customer> customers = template.search(searchQuery, Customer.class);
return customers;

}

public SearchHits<Customer> multiMatchQuery(String text) {

NativeSearchQuery searchQuery = new NativeSearchQueryBuilder().withQuery(QueryBuilders.multiMatchQuery(text)
.field("firstname").field("lastname").type(MultiMatchQueryBuilder.Type.BEST_FIELDS)).build();
SearchHits<Customer> customers = template.search(searchQuery, Customer.class);
return customers;
}

}
----------------------------------------------
import org.elasticsearch.client.RestHighLevelClient;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.elasticsearch.client.ClientConfiguration;
import org.springframework.data.elasticsearch.client.RestClients;
import org.springframework.data.elasticsearch.core.ElasticsearchOperations;
import org.springframework.data.elasticsearch.core.ElasticsearchRestTemplate;
import org.springframework.data.elasticsearch.repository.config.EnableElasticsearchRepositories;


@Configuration
@EnableElasticsearchRepositories(basePackages = "com.subrat.ELK.repository")
public class EsConfig {


@Bean
public RestHighLevelClient client() {
ClientConfiguration clientConfiguration
= ClientConfiguration.builder()
.connectedTo("localhost:9200")
.build();

return RestClients.create(clientConfiguration).rest();
}

@Bean
public ElasticsearchOperations elasticsearchTemplate() {
return new ElasticsearchRestTemplate(client());
}

}

Okay

Elastic search is unstructured right ? for a example in customer documents, one document has five field and another has 9 fields in that case the Customer Model defined in the Java wont fit right ?how to handle such thing pls explain

Amazing Tutorial !

How we can use IN/NOT-IN like oracle..?
e.g: fieldName IN ("val1", "val2","val3")

can u pls explain with multiple conditions...?
e.g: like, IN/NOT-IN, equal, greaterThan, lessThan etc with a single query..

Hi sir ,I am getting status: 500 and nonodeavailableexception throwing sir pls help me sir to solve this pblm

Nice tutorial. I have a question on how can I add other elasticsearch features such as highlight or autocomplete here?

You are the best in spring boot

Amazing Video ... Can you please upload a video on sum and group by with multiple columns in elastic search. That will be a great help. If you have already done, you can share me the link

Hi Basant can you update this example with new versions of spring boot and elasticsearch...

Great Video, appreciate your efforts! :)

Nice video, I have one doubt. Why you use net.java.dev.jna

Awesome man

NodeBuilder is deprecated pls make another video using QueryDSL

this native search query builder and some methods are deprecated one
so can you please make a another video explaining newer things

Nice video , Sir i want to write fuzzy query in java and not able to write it would you tell me what will be query for it

Awesome Explanation Basant !!!Thanks!!!

How to manage schema migration in elasticsearch similar to what liquibase does for relational databases?