Elasticsearch Query and ElasticsearchCrudRepository Different pageable results
1
I have this query in elasticsearch which is giving correct results as expected but when I am trying to search via ElasticsearchCrudRepository using springboot, it is giving different results in random order
I searched on github, other stackoverflow questions some said it was version issue but I am using same version of spring-data-elasticsearch as well my elasticsearch
ElasticsearchCrudRepository Query :
@Component
public interface MedicineRepository extends ElasticsearchCrudRepository<Medicine, String> {
@Query("{ "function_score" :{ "query":{ "bool": { "must_not": [ { "match": { "status": "Inactive" } }, { "match": { "status": "Pending" } } ], "must": [ { "match": { "location": "?1" } }, { "bool": { "should": [ { "multi_match": { "query": "?0", "type": "best_fields", "fields": [ "name^5", "brand_name^3" ], "boost": 1, "fuzziness": "AUTO", "prefix_length": 2 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "name^5", "brand_name^3" ], "boost": 3 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "sku" ], "boost": 5 } } ] } } ] } }, "boost": "2", "functions": [ { "filter": { "match": { "status": "Active" } }, "weight": 2 } ], "max_boost": 10, "score_mode": "max", "boost_mode": "sum", "min_score" : 0 } }")
Page<Medicine> findByLocationAnd_SkuOrNameOrBrand(String query, String location, Pageable pageable);
}
Normal ElasticSearch Query :
{
"query" :
{
"function_score" :{
"query":{
"bool": {
"must_not": [
{
"match": {
"status": "Inactive"
}
},
{
"match": {
"status": "Pending"
}
}
],
"must": [
{
"match": {
"location": "Jaipur"
}
},
{
"bool": {
"should": [
{
"multi_match": {
"query": "crozin",
"type": "best_fields",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 1,
"fuzziness": "AUTO",
"prefix_length": 2
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 3
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"sku"
],
"boost": 5
}
}
]
}
}
]
}
},
"boost": "2",
"functions": [
{
"filter": { "match": { "status": "Active" } },
"weight": 2
}
],
"max_boost": 10,
"score_mode": "max",
"boost_mode": "sum",
"min_score" : 0
}
}
}
spring-boot elasticsearch spring-data-elasticsearch
asked Nov 22 '18 at 6:23
karans123karans123
363
add a comment |
1
I have this query in elasticsearch which is giving correct results as expected but when I am trying to search via ElasticsearchCrudRepository using springboot, it is giving different results in random order
I searched on github, other stackoverflow questions some said it was version issue but I am using same version of spring-data-elasticsearch as well my elasticsearch
ElasticsearchCrudRepository Query :
@Component
public interface MedicineRepository extends ElasticsearchCrudRepository<Medicine, String> {
@Query("{ "function_score" :{ "query":{ "bool": { "must_not": [ { "match": { "status": "Inactive" } }, { "match": { "status": "Pending" } } ], "must": [ { "match": { "location": "?1" } }, { "bool": { "should": [ { "multi_match": { "query": "?0", "type": "best_fields", "fields": [ "name^5", "brand_name^3" ], "boost": 1, "fuzziness": "AUTO", "prefix_length": 2 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "name^5", "brand_name^3" ], "boost": 3 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "sku" ], "boost": 5 } } ] } } ] } }, "boost": "2", "functions": [ { "filter": { "match": { "status": "Active" } }, "weight": 2 } ], "max_boost": 10, "score_mode": "max", "boost_mode": "sum", "min_score" : 0 } }")
Page<Medicine> findByLocationAnd_SkuOrNameOrBrand(String query, String location, Pageable pageable);
}
Normal ElasticSearch Query :
{
"query" :
{
"function_score" :{
"query":{
"bool": {
"must_not": [
{
"match": {
"status": "Inactive"
}
},
{
"match": {
"status": "Pending"
}
}
],
"must": [
{
"match": {
"location": "Jaipur"
}
},
{
"bool": {
"should": [
{
"multi_match": {
"query": "crozin",
"type": "best_fields",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 1,
"fuzziness": "AUTO",
"prefix_length": 2
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 3
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"sku"
],
"boost": 5
}
}
]
}
}
]
}
},
"boost": "2",
"functions": [
{
"filter": { "match": { "status": "Active" } },
"weight": 2
}
],
"max_boost": 10,
"score_mode": "max",
"boost_mode": "sum",
"min_score" : 0
}
}
}
spring-boot elasticsearch spring-data-elasticsearch
asked Nov 22 '18 at 6:23
karans123karans123
363
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33
add a comment |
1
1
1
I have this query in elasticsearch which is giving correct results as expected but when I am trying to search via ElasticsearchCrudRepository using springboot, it is giving different results in random order
I searched on github, other stackoverflow questions some said it was version issue but I am using same version of spring-data-elasticsearch as well my elasticsearch
ElasticsearchCrudRepository Query :
@Component
public interface MedicineRepository extends ElasticsearchCrudRepository<Medicine, String> {
@Query("{ "function_score" :{ "query":{ "bool": { "must_not": [ { "match": { "status": "Inactive" } }, { "match": { "status": "Pending" } } ], "must": [ { "match": { "location": "?1" } }, { "bool": { "should": [ { "multi_match": { "query": "?0", "type": "best_fields", "fields": [ "name^5", "brand_name^3" ], "boost": 1, "fuzziness": "AUTO", "prefix_length": 2 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "name^5", "brand_name^3" ], "boost": 3 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "sku" ], "boost": 5 } } ] } } ] } }, "boost": "2", "functions": [ { "filter": { "match": { "status": "Active" } }, "weight": 2 } ], "max_boost": 10, "score_mode": "max", "boost_mode": "sum", "min_score" : 0 } }")
Page<Medicine> findByLocationAnd_SkuOrNameOrBrand(String query, String location, Pageable pageable);
}
Normal ElasticSearch Query :
{
"query" :
{
"function_score" :{
"query":{
"bool": {
"must_not": [
{
"match": {
"status": "Inactive"
}
},
{
"match": {
"status": "Pending"
}
}
],
"must": [
{
"match": {
"location": "Jaipur"
}
},
{
"bool": {
"should": [
{
"multi_match": {
"query": "crozin",
"type": "best_fields",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 1,
"fuzziness": "AUTO",
"prefix_length": 2
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 3
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"sku"
],
"boost": 5
}
}
]
}
}
]
}
},
"boost": "2",
"functions": [
{
"filter": { "match": { "status": "Active" } },
"weight": 2
}
],
"max_boost": 10,
"score_mode": "max",
"boost_mode": "sum",
"min_score" : 0
}
}
}
spring-boot elasticsearch spring-data-elasticsearch
asked Nov 22 '18 at 6:23
karans123karans123
363
I have this query in elasticsearch which is giving correct results as expected but when I am trying to search via ElasticsearchCrudRepository using springboot, it is giving different results in random order
I searched on github, other stackoverflow questions some said it was version issue but I am using same version of spring-data-elasticsearch as well my elasticsearch
ElasticsearchCrudRepository Query :
@Component
public interface MedicineRepository extends ElasticsearchCrudRepository<Medicine, String> {
@Query("{ "function_score" :{ "query":{ "bool": { "must_not": [ { "match": { "status": "Inactive" } }, { "match": { "status": "Pending" } } ], "must": [ { "match": { "location": "?1" } }, { "bool": { "should": [ { "multi_match": { "query": "?0", "type": "best_fields", "fields": [ "name^5", "brand_name^3" ], "boost": 1, "fuzziness": "AUTO", "prefix_length": 2 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "name^5", "brand_name^3" ], "boost": 3 } }, { "multi_match": { "query": "?0", "type": "phrase_prefix", "fields": [ "sku" ], "boost": 5 } } ] } } ] } }, "boost": "2", "functions": [ { "filter": { "match": { "status": "Active" } }, "weight": 2 } ], "max_boost": 10, "score_mode": "max", "boost_mode": "sum", "min_score" : 0 } }")
Page<Medicine> findByLocationAnd_SkuOrNameOrBrand(String query, String location, Pageable pageable);
}
Normal ElasticSearch Query :
{
"query" :
{
"function_score" :{
"query":{
"bool": {
"must_not": [
{
"match": {
"status": "Inactive"
}
},
{
"match": {
"status": "Pending"
}
}
],
"must": [
{
"match": {
"location": "Jaipur"
}
},
{
"bool": {
"should": [
{
"multi_match": {
"query": "crozin",
"type": "best_fields",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 1,
"fuzziness": "AUTO",
"prefix_length": 2
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"name^5",
"brand_name^3"
],
"boost": 3
}
},
{
"multi_match": {
"query": "crozin",
"type": "phrase_prefix",
"fields": [
"sku"
],
"boost": 5
}
}
]
}
}
]
}
},
"boost": "2",
"functions": [
{
"filter": { "match": { "status": "Active" } },
"weight": 2
}
],
"max_boost": 10,
"score_mode": "max",
"boost_mode": "sum",
"min_score" : 0
}
}
}
spring-boot elasticsearch spring-data-elasticsearch
spring-boot elasticsearch spring-data-elasticsearch
asked Nov 22 '18 at 6:23
karans123karans123
363
asked Nov 22 '18 at 6:23
karans123karans123
363
asked Nov 22 '18 at 6:23
karans123karans123
363
asked Nov 22 '18 at 6:23
karans123karans123
363
asked Nov 22 '18 at 6:23
karans123karans123
363
363
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33
add a comment |
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53424972%2felasticsearch-query-and-elasticsearchcrudrepository-different-pageable-results%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53424972%2felasticsearch-query-and-elasticsearchcrudrepository-different-pageable-results%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Are you able to log the query generated from the repository?
– Patrick
Nov 22 '18 at 7:25
yep, since it is native query so it is same, i am calling medicineRepository.findByLocationAnd_SkuOrNameOrBrand(query, location, pageable);
– karans123
Nov 22 '18 at 7:33