# Query for excluding |' '| blank column throwing error on elasticsearch 2.0

**URL:** <https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862>\
**Category:** Elasticsearch\
**Created:** [November 30, 2015, 6:32am UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862 "2015-11-30T06:32:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Saket\_Kumar](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Saket\_Kumar](https://discuss.elastic.co/u/Saket_Kumar)\
**Post date:** [November 30, 2015, 6:32am UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862/1 "2015-11-30T06:32:54Z")

</div>

Request to Elasticsearch failed: {"error":{"root\_cause":[{"type":"illegal\_argument\_exception","reason":"unexpected end-of-string"}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query","grouped":true,"failed\_shards":[{"shard":0,"index":"logstash-csv-wpt","node":"ZQCutKHOQOCHEg\_wL5QHSQ","reason":{"type":"illegal\_argument\_exception","reason":"unexpected end-of-string"}}]}}

Elasticsearch 1.x version was working fine when query contains |' '| which actually excludes the blank columns. I don't know how it will work with 2.x. Any idea?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 30, 2015, 6:50am UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862/2 "2015-11-30T06:50:43Z")

</div>

Hard to say without seeing the query.

---

<div class="post-metadata">

**Author:** ![Saket\_Kumar](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@Saket\_Kumar](https://discuss.elastic.co/u/Saket_Kumar)\
**Post date:** [November 30, 2015, 6:55am UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862/3 "2015-11-30T06:55:14Z")

</div>

Hope this works...

{"title":"${\_\_property(ProjectN)}-ContentType-RequestBreakDown-${keyword}-${TestID}","visState":"{"type":"histogram","params":{"shareYAxis":true,"addTooltip":true,"addLegend":true,"mode":"grouped","defaultYExtents":false},"aggs":[{"id":"1","type":"count","schema":"metric","params":{}},{"id":"2","type":"terms","schema":"segment","params":{"field":"Content\_Type.raw","exclude":{"pattern":"Content Type|' '|"},"size":20,"order":"asc","orderBy":"1"}},{"id":"3","type":"filters","schema":"group","params":{"filters":[{"input":{"query":{"query\_string":{"query":"${RunID} AND FirstView","analyze\_wildcard":true}}}},{"input":{"query":{"query\_string":{"query":"${RunID} AND RepeatView","analyze\_wildcard":true}}}}]}}],"listeners":{}}","description":"","version":1,"kibanaSavedObjectMeta":{"searchSourceJSON":"{"index":"logstash-csv-${\_\_property(ProjectN)}","query":{"query\_string":{"query":"\*","analyze\_wildcard":true}},"filter":[]}"}}

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 30, 2015, 7:19am UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862/4 "2015-11-30T07:19:30Z")

</div>

What is that?

---

<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:** [July 5, 2017, 11:34pm UTC](https://discuss.elastic.co/t/query-for-excluding-blank-column-throwing-error-on-elasticsearch-2-0/35862/5 "2017-07-05T23:34:56Z")

</div>