Hi all,
I have encountered a weird behaviour. I trying to execute same query twice
and it returns me different scoring of same document.
This is affecting the order of the result returned as what i need is sort
by relevancy.
*The query : *
{
"from" : 0,
"size" : 100,
"explain" : true,
"query" : {
"filtered" : {
"query" : {
"multi_match": {
"query": "happy",
"fields": [ "DISPLAY_NAME^6" ]
}
},
"filter" : {
"query" : {
"bool" : {
"must" : {
"term" : {
"CHANNEL_ID" : "1"
}
}
}
}
}
}
}
}
*Result on first run : *
"_shard": 2,
"_node": "h3g1u4jzT1KdJXDQF06qyA",
"_index": "jdbc_dev",
"_type": "media",
"_id": "*15939*",
"_score": *10.882705*,
"_source": {
"DISPLAY_NAME": "*Happy*",
"PRICE": 1.5,
"AUDIO":
"http://musicube.thecube.my/base/preview/054/540152/540152-MP3-CMT-P.mp3";,
"CHANNEL_ID": 1,
"CAT_PARENT": 557,
"MEDIA_ID": 15939,
"GENRE": "Happy",
"MEDIA_PKEY": "540152",
"COMPOSER": null,
"PLAYER": null,
"CATMEDIA_NAME": "Happy",
"FTID": null,
"VIEW_ID": 241,
"POSITION": 6162,
"ITEMCODE": "147237",
"CAT_ID": 558,
"PRIORITY": 100,
"CKEY": 533868,
"CATMEDIA_RANK": 3,
"BILLINGTYPE_ID": 1,
"CAT_NAME": "POP",
"KEYWORDS": null,
"LONG_DESCRIPTION": null,
"SHORT_DESCRIPTION": null,
"TYPE_ID": 76,
"ARTIST_GENDER": null,
"PERFORMER": "Diandra Arjunaidi",
"MAPPINGS": "1_241_558_POP_557_6162_1.5",
"SHORTCODE": "0401119513",
"CATMEDIA_CDATE": "2014-01-26T20:04:11.000Z",
"LANG_ID": 1
},
"_explanation": {
"value": 10.882705,
"description": "weight(DISPLAY_NAME:happy in 853)
[PerFieldSimilarity], result of:",
"details": [
{
"value": 10.882705,
"description": "fieldWeight in 853, product
of:",
"details": [
{
"value": 1,
"description": "tf(freq=1.0), with freq
of:",
"details": [
{
"value": 1,
"description": "termFreq=1.0"
}
]
},
{
"value": 10.882705,
"description": "idf(docFreq=63,
maxDocs=1253673)"
},
{
"value": 1,
"description": "fieldNorm(doc=853)"
}
]
}
]
}
*Result on second run : *
"_shard": 2,
"_node": "UOjX2lxhR6mzfjHHmTm3cQ",
"_index": "jdbc_dev",
"_type": "media",
"_id": "*15939*",
"_score": *10.388683*,
"_source": {
"DISPLAY_NAME": "*Happy*",
"PRICE": 1.5,
"AUDIO":
"http://musicube.thecube.my/base/preview/054/540152/540152-MP3-CMT-P.mp3";,
"CHANNEL_ID": 1,
"CAT_PARENT": 557,
"MEDIA_ID": 15939,
"GENRE": "Happy",
"MEDIA_PKEY": "540152",
"COMPOSER": null,
"PLAYER": null,
"CATMEDIA_NAME": "Happy",
"FTID": null,
"VIEW_ID": 241,
"POSITION": 6162,
"ITEMCODE": "147237",
"CAT_ID": 558,
"PRIORITY": 100,
"CKEY": 533868,
"CATMEDIA_RANK": 3,
"BILLINGTYPE_ID": 1,
"CAT_NAME": "POP",
"KEYWORDS": null,
"LONG_DESCRIPTION": null,
"SHORT_DESCRIPTION": null,
"TYPE_ID": 76,
"ARTIST_GENDER": null,
"PERFORMER": "Diandra Arjunaidi",
"MAPPINGS": "1_241_558_POP_557_6162_1.5",
"SHORTCODE": "0401119513",
"CATMEDIA_CDATE": "2014-01-26T20:04:11.000Z",
"LANG_ID": 1
},
"_explanation": {
"value": 10.388683,
"description": "weight(DISPLAY_NAME:happy in 12392)
[PerFieldSimilarity], result of:",
"details": [
{
"value": 10.388683,
"description": "fieldWeight in 12392, product
of:",
"details": [
{
"value": 1,
"description": "tf(freq=1.0), with freq
of:",
"details": [
{
"value": 1,
"description": "termFreq=1.0"
}
]
},
{
"value": 10.388683,
"description": "idf(docFreq=107,
maxDocs=1290854)"
},
{
"value": 1,
"description": "fieldNorm(doc=12392)"
}
]
}
]
}
*The mapping :*
{
"media": {
"properties": {
"AUDIO": {
"type": "string"
},
"BILLINGTYPE_ID": {
"type": "long"
},
"CATMEDIA_CDATE": {
"type": "date",
"format": "dateOptionalTime"
},
"CATMEDIA_NAME": {
"type": "string"
},
"CATMEDIA_RANK": {
"type": "long"
},
"CAT_ID": {
"type": "long"
},
"CAT_NAME": {
"type": "string",
"analyzer": "string_lowercase",
"include_in_all": true
},
"CAT_PARENT": {
"type": "long"
},
"CHANNEL_ID": {
"type": "long"
},
"CKEY": {
"type": "long"
},
"*DISPLAY_NAME*": {
"type": "string"
},
"FTID": {
"type": "string"
},
"GENRE": {
"type": "string"
},
"ITEMCODE": {
"type": "string"
},
"KEYWORDS": {
"type": "string"
},
"LANG_ID": {
"type": "long"
},
"LONG_DESCRIPTION": {
"type": "string"
},
"MAPPINGS": {
"type": "string",
"analyzer": "string_lowercase",
"include_in_all": true
},
"MEDIA_ID": {
"type": "long"
},
"MEDIA_PKEY": {
"type": "string"
},
"PERFORMER": {
"type": "string"
},
"PLAYER": {
"type": "string"
},
"POSITION": {
"type": "long"
},
"PRICE": {
"type": "double"
},
"PRIORITY": {
"type": "long"
},
"SHORTCODE": {
"type": "string"
},
"SHORT_DESCRIPTION": {
"type": "string"
},
"TYPE_ID": {
"type": "long"
},
"VIEW_ID": {
"type": "long"
}
}
}
}
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/3507a1ac-3451-44f0-afd5-f16db6865fb1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
