# Does Discover page support elastic query DSL in Kibana 4.6?

**URL:** <https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725>\
**Category:** Kibana\
**Created:** [September 28, 2016, 4:22pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725 "2016-09-28T16:22:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![satheeshravir](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@satheeshravir](https://discuss.elastic.co/u/satheeshravir)\
**Post date:** [September 28, 2016, 4:22pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/1 "2016-09-28T16:22:41Z")

</div>

I am new to Kibana and ES. I am using Kibana 4.6 . I have read the Kibana 4.6 documentation and it says Discover page in Kibana supports full JSON DSL queries ([Discover | Kibana Guide [8.11] | Elastic](https://www.elastic.co/guide/en/kibana/current/discover.html)). But when I enter json query with aggregation it shows "Parse queries failed error". Can someone help me out? I am trying to visualize my search query but this error is blocking me. I am trying to run the following query. It runs fine in Sense.

> {  
> "query": {  
> "regexp": {  
> "body.message": "._ended._"  
> }  
> },  
> "aggs": {  
> "group\_device": {  
> "terms": {  
> "field": "serialNumber"  
> },  
> "aggs": {  
> "group\_state": {  
> "terms": {  
> "script": {  
> "lang": "groovy",  
> "file": "extract\_state"  
> }  
> },  
> "aggs": {  
> "group\_time": {  
> "avg": {  
> "script": {  
> "lang": "groovy",  
> "file": "extract\_time"  
> }  
> }  
> }  
> }  
> }  
> }  
> }  
> }, "size" : 0  
> }

---

<div class="post-metadata">

**Author:** ![Joshua\_Rich](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshua_rich/32/44953_2.png) [@Joshua\_Rich](https://discuss.elastic.co/u/Joshua_Rich)\
**Post date:** [September 28, 2016, 5:42pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/2 "2016-09-28T17:42:00Z")

</div>

Can you capture a screenshot of the error and also check the Elasticsearch log to see what is the parse exception that is thrown?

---

<div class="post-metadata">

**Author:** ![satheeshravir](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@satheeshravir](https://discuss.elastic.co/u/satheeshravir)\
**Post date:** [September 28, 2016, 5:50pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/3 "2016-09-28T17:50:51Z")

</div>

> [@satheeshravir](#):
>
> {  
> "query": {  
> "regexp": {  
> "body.message": ".ended."  
> }  
> },  
> "aggs": {  
> "group\_device": {  
> "terms": {  
> "field": "serialNumber"  
> },  
> "aggs": {  
> "group\_state": {  
> "terms": {  
> "script": {  
> "lang": "groovy",  
> "file": "extract\_state"  
> }  
> },  
> "aggs": {  
> "group\_time": {  
> "avg": {  
> "script": {  
> "lang": "groovy",  
> "file": "extract\_time"  
> }  
> }  
> }  
> }  
> }  
> }  
> }  
> }, "size" : 0  
> }

 ![](https://us1.discourse-cdn.com/elastic/original/2X/0/019d32d26cbe66cc685497c5e95dcf5f0024594c.png)

ES Logs

> [2016-09-28 10:48:24,027][DEBUG][action.search] [Penance II] [logs\_test][1], node[SbDY-QgkTlm2O15ot4Z2Jw], [P], v[8], s[STARTED], a[id=5MfhOwekTH6rPWW56u33Nw]: Failed to execute [org.elasticsearch.action.search.SearchRequest@14fad732] lastShard [true]  
> RemoteTransportException[[Penance II][127.0.0.1:9300][indices:data/read/search[phase/query]]]; nested: SearchParseException[failed to parse search source [{"size":500,"sort":[{"\_score":{"order":"desc","unmapped\_type":"boolean"}}],"query":{"query":{"regexp":{"body.message":"._ended._"}},"aggs":{"group\_device":{"terms":{"field":"serialNumber"},"aggs":{"group\_state":{"terms":{"script":{"lang":"groovy","file":"extract\_state"}},"aggs":{"group\_time":{"avg":{"script":{"lang":"groovy","file":"extract\_time"}}}}}}}},"size":0},"highlight":{"pre\_tags":["@kibana-highlighted-field@"],"post\_tags":["@/kibana-highlighted-field@"],"fields":{"_":{}},"require\_field\_match":false,"fragment\_size":2147483647},"fields":["_","\_source"],"script\_fields":{},"fielddata\_fields":["createdAt","updatedAt"]}]]; nested: ElasticsearchParseException[failed to parse search source. expected field name but got [START\_OBJECT]];  
> Caused by: SearchParseException[failed to parse search source [{"size":500,"sort":[{"\_score":{"order":"desc","unmapped\_type":"boolean"}}],"query":{"query":{"regexp":{"body.message":"._ended._"}},"aggs":{"group\_device":{"terms":{"field":"serialNumber"},"aggs":{"group\_state":{"terms":{"script":{"lang":"groovy","file":"extract\_state"}},"aggs":{"group\_time":{"avg":{"script":{"lang":"groovy","file":"extract\_time"}}}}}}}},"size":0},"highlight":{"pre\_tags":["@kibana-highlighted-field@"],"post\_tags":["@/kibana-highlighted-field@"],"fields":{"_":{}},"require\_field\_match":false,"fragment\_size":2147483647},"fields":["_","\_source"],"script\_fields":{},"fielddata\_fields":["createdAt","updatedAt"]}]]; nested: ElasticsearchParseException[failed to parse search source. expected field name but got [START\_OBJECT]];  
> at org.elasticsearch.search.SearchService.parseSource(SearchService.java:873)  
> at org.elasticsearch.search.SearchService.createContext(SearchService.java:667)  
> at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:633)  
> at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:377)  
> at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:368)  
> at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:365)  
> at org.elasticsearch.transport.TransportRequestHandler.messageReceived(TransportRequestHandler.java:33)  
> at org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:77)  
> at org.elasticsearch.transport.TransportService$4.doRun(TransportService.java:376)  
> at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37)  
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)  
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)  
> at java.lang.Thread.run(Thread.java:745)  
> Caused by: ElasticsearchParseException[failed to parse search source. expected field name but got [START\_OBJECT]]  
> at org.elasticsearch.search.SearchService.parseSource(SearchService.java:861)  
> ... 12 more

---

<div class="post-metadata">

**Author:** ![Joshua\_Rich](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshua_rich/32/44953_2.png) [@Joshua\_Rich](https://discuss.elastic.co/u/Joshua_Rich)\
**Post date:** [September 28, 2016, 6:14pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/4 "2016-09-28T18:14:07Z")

</div>

It looks like you've only got part of your query in the Kibana query bar? This exception usually indicates you've got a malformed query but I can't see anything wrong with the full query you've shown and it appears to parse correctly in a JSON linter.

---

<div class="post-metadata">

**Author:** ![satheeshravir](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@satheeshravir](https://discuss.elastic.co/u/satheeshravir)\
**Post date:** [September 28, 2016, 6:17pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/5 "2016-09-28T18:17:55Z")

</div>

Thank you for the response. I have given entire query in the query bar, but only part is captured in screenshot. I am not sure what's wrong, it runs fine in sense. It would be really helpful, if you can give a sample aggregation query that runs in Kibana query bar,

---

<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 6, 2017, 1:37pm UTC](https://discuss.elastic.co/t/does-discover-page-support-elastic-query-dsl-in-kibana-4-6/61725/6 "2017-07-06T13:37:53Z")

</div>


