# Failed to create query

**URL:** <https://discuss.elastic.co/t/failed-to-create-query/182125>\
**Category:** Elasticsearch\
**Created:** [May 22, 2019, 5:49am UTC](https://discuss.elastic.co/t/failed-to-create-query/182125 "2019-05-22T05:49:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Poonam1](https://avatars.discourse-cdn.com/v4/letter/p/ecd19e/32.png) [@Poonam1](https://discuss.elastic.co/u/Poonam1)\
**Post date:** [May 22, 2019, 5:49am UTC](https://discuss.elastic.co/t/failed-to-create-query/182125/1 "2019-05-22T05:49:14Z")

</div>

Hi All,

I am getting the following exception.

Can anyone help with the possible reason?

org.elasticsearch.transport.RemoteTransportException: [EI3\_UVO][127.0.0.1:9300][indices:data/read/search[phase/dfs]]  
Caused by: org.elasticsearch.index.query.QueryShardException: failed to create query: {  
"bool" : {  
"must" : [  
{  
"bool" : {  
"should" : [  
{  
"match" : {  
"client\_id" : {  
"query" : 1,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 2,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 13,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 10,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 8,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 9,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 7,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 12,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 3,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 5,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 11,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 4,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 6,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 14,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},  
{  
"match" : {  
"client\_id" : {  
"query" : 15,  
"operator" : "OR",  
"prefix\_length" : 0,  
"max\_expansions" : 50,  
"fuzzy\_transpositions" : true,  
"lenient" : false,  
"zero\_terms\_query" : "NONE",  
"boost" : 1.0  
}  
}  
},

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 19, 2019, 5:49am UTC](https://discuss.elastic.co/t/failed-to-create-query/182125/2 "2019-06-19T05:49:15Z")

</div>

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