Hello,
I have imported 0.7 million records in elasticsearch using logstash , find below the mapping details. <
{
"mappings":{
"properties":{
"date_time": {
"type": "date",
"format": "yyyyMMddHHmmss",
"index": false
},
"terminal_id": {
"type": "keyword",
"index": false
},
"host_date_time": {
"type": "date",
"format": "yyyyMMddHHmmss",
"index": false
},
"job_number": {
"type": "keyword",
"index": true
}
}
/>
When I try to search records based on job_number it results in incorrect resultset i.e. sometime it returns duplicate value or sometime it only return partial results.
Query which I'm using
<
{
"query": {
"term": {
"job_number": "706491"
}
}
}
/>
Ideally the above search result should return 2 results but inactual it only returns 1.