# Geo Distance Query - Exception-query\_shard\_exception, reason:Failed to parse query \[SOLVED\]

**URL:** https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399
**Category:** Kibana
**Created:** [June 6, 2017, 10:39am UTC](https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399 "2017-06-06T10:39:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Rahul\_Lao](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@Rahul\_Lao](https://discuss.elastic.co/u/Rahul_Lao)
#### Post date: [June 6, 2017, 10:39am UTC](https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399/1 "2017-06-06T10:39:58Z")

</div>

Hi,

Please can someone suggest what's wrong in below query when i type this in **kibana** search bar

`"query":{"bool":{"must":{"match_all":{}},"filter":{"geo_distance":{"distance":"20km","location":{"lon":-23.965,"lat":65.555801}}}}}`

Sample documents that i have indexed are

`country:Iceland altitude:11 iato:PFJ airport_id:17 dst:N city:Patreksfjordur timezone:0 tz:Atlantic/Reykjavik source:OurAirports type:airport path:/home/vagrant/dataset/airports.csv @timestamp:May 16th 2017, 12:41:26.791 @version:1 name:Patreksfjörður Airport icao:BIPA location:{ "lon": -23.965, "lat": 65.555801 } _id:AVwQ2SvNCj46ZjiRHCsh _type:airport _index:flights_dataset _score:1`

`country:Papua New Guinea altitude:19 iato:WWK airport_id:6 dst:U city:Wewak timezone:10 tz:Pacific/Port_Moresby source:OurAirports type:airport path:/home/vagrant/dataset/airports.csv @timestamp:May 16th 2017, 12:41:26.747 @version:1 name:Wewak International Airport icao:AYWK location:{ "lon": 143.669006348, "lat": -3.58383011818 } _id:AVwQ2SvKCj46ZjiRHCsg _type:airport _index:flights_dataset _score:1`

`country:Iceland altitude:8 iato:IFJ airport_id:15 dst:N city:Isafjordur timezone:0 tz:Atlantic/Reykjavik source:OurAirports type:airport path:/home/vagrant/dataset/airports.csv @timestamp:May 16th 2017, 12:41:26.769 @version:1 name:Ísafjörður Airport icao:BIIS location:{ "lon": -23.135299682617188, "lat": 66.05809783935547 } _id:AVwQ2Sv-Cj46ZjiRHCsv _type:airport _index:flights_dataset _score:1`

```
country:Canada altitude:108 iato:YAY airport_id:24 dst:A city:St. Anthony timezone:-3.5 tz:America/St_Johns source:OurAirports type:airport path:/home/vagrant/dataset/airports.csv @timestamp:May 16th 2017, 12:41:27.106 @version:1 name:St. Anthony Airport icao:CYAY location:{ "lon": -56.083099365200006, "lat": 51.3918991089 } _id:AVwQ2SyxCj46ZjiRHCsy _type:airport _index:flights_dataset _score:1

```

Looking forward for reply.  
Thanks

---

<div class="post-metadata">

### Author: ![Rahul\_Lao](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@Rahul\_Lao](https://discuss.elastic.co/u/Rahul_Lao)
#### Post date: [June 6, 2017, 11:57am UTC](https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399/2 "2017-06-06T11:57:30Z")

</div>

Found the mistake.  
The correct one should be

`{"bool":{"must":{"match_all":{}},"filter":{"geo_distance":{"distance":"20km","location":{"lon":-23.965,"lat":65.555801}}}}}`

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [June 6, 2017, 4:18pm UTC](https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399/3 "2017-06-06T16:18:52Z")

</div>

Glad to hear you figured it out. Thanks for sharing your solution with the community!

---

<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 4, 2017, 4:18pm UTC](https://discuss.elastic.co/t/geo-distance-query-exception-query-shard-exception-reason-failed-to-parse-query-solved/88399/4 "2017-07-04T16:18:56Z")

</div>

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