Wildcard query with multiple must returns number format exception


(Mihir2402) #1

I am using bool must for having multiple queries and when I use wildcard it returns number format exception for using *

Query :
{
"query":{
"bool":{
"must":[
{
"wildcard":{
"response_code": "4*"
}
},
{
"range":{
"@timestamp":{
"from":"now-10m",
"to":"now"
}
}
}
]
}
}
}

Output:

{

"error": {
"root_cause": [
{
"type": "number_format_exception",
"reason": "For input string: "4*""
}
],
"type": "search_phase_execution_exception",
"reason": "all shards failed",
"phase": "query",
"grouped": true,
"failed_shards": [
{
"shard": 0,
"index": "stg_esd_rae-2017.05.09.11",
"node": "-M3nnkudTpitT8ZXnidYeg",
"reason": {
"type": "number_format_exception",
"reason": "For input string: "4*""
}
}
]
},
"status": 400
}


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.