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


(Saket Kumar) #1

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?


(David Pilato) #2

Hard to say without seeing the query.


(Saket Kumar) #3

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":[]}"}}


(David Pilato) #4

What is that?


(system) #5