# ElasticSearch mapping and search issue **URL:** \ **Category:** Elasticsearch\ **Created:** [November 7, 2012, 6:22pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604 "2012-11-07T18:22:08Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Nick\_Pirollo](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@Nick\_Pirollo](https://discuss.elastic.co/u/Nick_Pirollo)\ **Post date:** [November 7, 2012, 6:22pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/1 "2012-11-07T18:22:08Z")
We recently had some issues with ElasticSearch over at [cliqsearch.com](http://cliqsearch.com) and managed to get things back for searching. Our only issue is that GeoPoint filtering is now causing errors when we search even though all mappings seem to be there it is saying it cannot find out geo\_point location\_latlon. Below is the error as well as the mapping from our ES server, and if you search on [cliqsearch.com](http://cliqsearch.com) you can reproduce the error by typing a search with a city or town after (ie. fun in philly or yogurt philly, etc.) Mapping for snowball2: { "pages-snowball2" : { "properties" : { "tags" : { "type" : "string" }, "phone" : { "type" : "string" }, "date\_indexed" : { "format" : "dateOptionalTime", "type" : "date" }, "location\_zip" : { "type" : "string" }, "website" : { "type" : "string" }, "metro" : { "type" : "string" }, "category1" : { "type" : "string" }, "location\_latlon" : { "dynamic" : "true", "properties" : { "lon" : { "type" : "double" }, "lat" : { "type" : "double" } } }, "category3" : { "type" : "string" }, "location\_city" : { "type" : "string" }, "category2" : { "type" : "string" }, "id" : { "type" : "string" }, "location\_state" : { "type" : "string" }, "location\_street2" : { "type" : "string" }, "phone\_bare" : { "type" : "string" }, "description" : { "type" : "string" }, "name" : { "type" : "string" }, "location\_street" : { "type" : "string" } } } } error per search: SearchPhaseExecutionException[Failed to execute phase [query], total failure; shardFailures {[YzlaeRMESNuywR\_RlnomKg][fb][1]: SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; nested: QueryParsingException[[fb] failed to find geo\_point field [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][0]: SearchParseException[[fb][0]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; nested: QueryParsingException[[fb] failed to find geo\_point field [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][4]: SearchParseException[[fb][4]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; nested: QueryParsingException[[fb] failed to find geo\_point field [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][2]: SearchParseException[[fb][2]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; nested: QueryParsingException[[fb] failed to find geo\_point field [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][1]: SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; nested: QueryParsingException[[fb] failed to find geo\_point field [location\_latlon]]; }] Thank you and feel free to let me know if more info is needed. Nick -- ---
**Author:** ![Jerome\_Gagnon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jerome_gagnon/32/2178_2.png) [@Jerome\_Gagnon](https://discuss.elastic.co/u/Jerome_Gagnon)\ **Post date:** [November 7, 2012, 6:25pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/2 "2012-11-07T18:25:31Z")
Your location fields need to be type geo\_point, like this: "location\_latlong":{"type":"geo\_point", lat\_lon:true} On Wednesday, November 7, 2012 1:22:08 PM UTC-5, Nick Pirollo wrote: > We recently had some issues with Elasticsearch over at [cliqsearch.com](http://cliqsearch.com) and > managed to get things back for searching. Our only issue is that GeoPoint > filtering is now causing errors when we search even though all mappings > seem to be there it is saying it cannot find out geo\_point location\_latlon. > Below is the error as well as the mapping from our ES server, and if you > search on [cliqsearch.com](http://cliqsearch.com) you can reproduce the error by typing a search > with a city or town after (ie. fun in philly or yogurt philly, etc.) > > Mapping for snowball2: > > { > "pages-snowball2" : { > "properties" : { > "tags" : { > "type" : "string" > }, > "phone" : { > "type" : "string" > }, > "date\_indexed" : { > "format" : "dateOptionalTime", > "type" : "date" > }, > "location\_zip" : { > "type" : "string" > }, > "website" : { > "type" : "string" > }, > "metro" : { > "type" : "string" > }, > "category1" : { > "type" : "string" > }, > "location\_latlon" : { > "dynamic" : "true", > "properties" : { > "lon" : { > "type" : "double" > }, > "lat" : { > "type" : "double" > } > } > }, > "category3" : { > "type" : "string" > }, > "location\_city" : { > "type" : "string" > }, > "category2" : { > "type" : "string" > }, > "id" : { > "type" : "string" > }, > "location\_state" : { > "type" : "string" > }, > "location\_street2" : { > "type" : "string" > }, > "phone\_bare" : { > "type" : "string" > }, > "description" : { > "type" : "string" > }, > "name" : { > "type" : "string" > }, > "location\_street" : { > "type" : "string" > } > } > } > } > > error per search: > SearchPhaseExecutionException[Failed to execute phase [query], total > failure; shardFailures {[YzlaeRMESNuywR\_RlnomKg][fb][1]: > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > nested: QueryParsingException[[fb] failed to find geo\_point field > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][0]: > SearchParseException[[fb][0]: from[-1],size[-1]: Parse Failure [Failed to > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > nested: QueryParsingException[[fb] failed to find geo\_point field > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][4]: > SearchParseException[[fb][4]: from[-1],size[-1]: Parse Failure [Failed to > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > nested: QueryParsingException[[fb] failed to find geo\_point field > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][2]: > SearchParseException[[fb][2]: from[-1],size[-1]: Parse Failure [Failed to > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > nested: QueryParsingException[[fb] failed to find geo\_point field > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][1]: > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > nested: QueryParsingException[[fb] failed to find geo\_point field > [location\_latlon]]; }] > > Thank you and feel free to let me know if more info is needed. > Nick -- ---
**Author:** ![Nick\_Pirollo](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@Nick\_Pirollo](https://discuss.elastic.co/u/Nick_Pirollo)\ **Post date:** [November 7, 2012, 6:27pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/3 "2012-11-07T18:27:22Z")
Thank you Jerome, when i try to change the mapping i get the issue of: {"error":"MergeMappingException[Merge failed with failures {[Can't merge a non object mapping [location\_latlon] with an object mapping [location\_latlon]]}]","status":400} is there documentation on modifying a mapping with merge errors? On Wednesday, November 7, 2012 1:25:32 PM UTC-5, Jérôme Gagnon wrote: > Your location fields need to be type geo\_point, like > this: "location\_latlong":{"type":"geo\_point", lat\_lon:true} > > On Wednesday, November 7, 2012 1:22:08 PM UTC-5, Nick Pirollo wrote: > > > We recently had some issues with Elasticsearch over at cliqsearch.comand managed to get things back for searching. Our only issue is that > > GeoPoint filtering is now causing errors when we search even though all > > mappings seem to be there it is saying it cannot find out geo\_point > > location\_latlon. Below is the error as well as the mapping from our ES > > server, and if you search on [cliqsearch.com](http://cliqsearch.com) you can reproduce the error > > by typing a search with a city or town after (ie. fun in philly or yogurt > > philly, etc.) > > > > Mapping for snowball2: > > > > { > > "pages-snowball2" : { > > "properties" : { > > "tags" : { > > "type" : "string" > > }, > > "phone" : { > > "type" : "string" > > }, > > "date\_indexed" : { > > "format" : "dateOptionalTime", > > "type" : "date" > > }, > > "location\_zip" : { > > "type" : "string" > > }, > > "website" : { > > "type" : "string" > > }, > > "metro" : { > > "type" : "string" > > }, > > "category1" : { > > "type" : "string" > > }, > > "location\_latlon" : { > > "dynamic" : "true", > > "properties" : { > > "lon" : { > > "type" : "double" > > }, > > "lat" : { > > "type" : "double" > > } > > } > > }, > > "category3" : { > > "type" : "string" > > }, > > "location\_city" : { > > "type" : "string" > > }, > > "category2" : { > > "type" : "string" > > }, > > "id" : { > > "type" : "string" > > }, > > "location\_state" : { > > "type" : "string" > > }, > > "location\_street2" : { > > "type" : "string" > > }, > > "phone\_bare" : { > > "type" : "string" > > }, > > "description" : { > > "type" : "string" > > }, > > "name" : { > > "type" : "string" > > }, > > "location\_street" : { > > "type" : "string" > > } > > } > > } > > } > > > > error per search: > > SearchPhaseExecutionException[Failed to execute phase [query], total > > failure; shardFailures {[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > nested: QueryParsingException[[fb] failed to find geo\_point field > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][0]: > > SearchParseException[[fb][0]: from[-1],size[-1]: Parse Failure [Failed to > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > nested: QueryParsingException[[fb] failed to find geo\_point field > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][4]: > > SearchParseException[[fb][4]: from[-1],size[-1]: Parse Failure [Failed to > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > nested: QueryParsingException[[fb] failed to find geo\_point field > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][2]: > > SearchParseException[[fb][2]: from[-1],size[-1]: Parse Failure [Failed to > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > nested: QueryParsingException[[fb] failed to find geo\_point field > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > nested: QueryParsingException[[fb] failed to find geo\_point field > > [location\_latlon]]; }] > > > > Thank you and feel free to let me know if more info is needed. > > Nick -- ---
**Author:** ![Jerome\_Gagnon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jerome_gagnon/32/2178_2.png) [@Jerome\_Gagnon](https://discuss.elastic.co/u/Jerome_Gagnon)\ **Post date:** [November 7, 2012, 6:37pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/4 "2012-11-07T18:37:58Z")
I'm pretty sure you cannot change the mapping while it has been created... you can try to close the index then change it, but then again I offer no certitude. If you don't want to re-create your index, you can (I think) add a new field to your mapping. On Wednesday, November 7, 2012 1:27:22 PM UTC-5, Nick Pirollo wrote: > Thank you Jerome, > > when i try to change the mapping i get the issue of: > > {"error":"MergeMappingException[Merge failed with failures {[Can't merge a > non object mapping [location\_latlon] with an object mapping > [location\_latlon]]}]","status":400} > > is there documentation on modifying a mapping with merge errors? > > On Wednesday, November 7, 2012 1:25:32 PM UTC-5, Jérôme Gagnon wrote: > > > Your location fields need to be type geo\_point, like > > this: "location\_latlong":{"type":"geo\_point", lat\_lon:true} > > > > On Wednesday, November 7, 2012 1:22:08 PM UTC-5, Nick Pirollo wrote: > > > > > We recently had some issues with Elasticsearch over at cliqsearch.comand managed to get things back for searching. Our only issue is that > > > GeoPoint filtering is now causing errors when we search even though all > > > mappings seem to be there it is saying it cannot find out geo\_point > > > location\_latlon. Below is the error as well as the mapping from our ES > > > server, and if you search on [cliqsearch.com](http://cliqsearch.com) you can reproduce the error > > > by typing a search with a city or town after (ie. fun in philly or yogurt > > > philly, etc.) > > > > > > Mapping for snowball2: > > > > > > { > > > "pages-snowball2" : { > > > "properties" : { > > > "tags" : { > > > "type" : "string" > > > }, > > > "phone" : { > > > "type" : "string" > > > }, > > > "date\_indexed" : { > > > "format" : "dateOptionalTime", > > > "type" : "date" > > > }, > > > "location\_zip" : { > > > "type" : "string" > > > }, > > > "website" : { > > > "type" : "string" > > > }, > > > "metro" : { > > > "type" : "string" > > > }, > > > "category1" : { > > > "type" : "string" > > > }, > > > "location\_latlon" : { > > > "dynamic" : "true", > > > "properties" : { > > > "lon" : { > > > "type" : "double" > > > }, > > > "lat" : { > > > "type" : "double" > > > } > > > } > > > }, > > > "category3" : { > > > "type" : "string" > > > }, > > > "location\_city" : { > > > "type" : "string" > > > }, > > > "category2" : { > > > "type" : "string" > > > }, > > > "id" : { > > > "type" : "string" > > > }, > > > "location\_state" : { > > > "type" : "string" > > > }, > > > "location\_street2" : { > > > "type" : "string" > > > }, > > > "phone\_bare" : { > > > "type" : "string" > > > }, > > > "description" : { > > > "type" : "string" > > > }, > > > "name" : { > > > "type" : "string" > > > }, > > > "location\_street" : { > > > "type" : "string" > > > } > > > } > > > } > > > } > > > > > > error per search: > > > SearchPhaseExecutionException[Failed to execute phase [query], total > > > failure; shardFailures {[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][0]: > > > SearchParseException[[fb][0]: from[-1],size[-1]: Parse Failure [Failed to > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][4]: > > > SearchParseException[[fb][4]: from[-1],size[-1]: Parse Failure [Failed to > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][2]: > > > SearchParseException[[fb][2]: from[-1],size[-1]: Parse Failure [Failed to > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > [location\_latlon]]; }] > > > > > > Thank you and feel free to let me know if more info is needed. > > > Nick -- ---
**Author:** ![Nick\_Pirollo](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@Nick\_Pirollo](https://discuss.elastic.co/u/Nick_Pirollo)\ **Post date:** [November 7, 2012, 7:06pm UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/5 "2012-11-07T19:06:57Z")
Thanks Jerome For future references: you need to delete the mapping curl -XDELETE "localhost:9200/index/type/\_mapping" then you need to recreate the mapping. This has to be done while the index is open, the closed index locks all operations. curl -XPUT "localhost:9200/index/type/\_mapping" -d 'NEW MAPPING' i solved the issue of remembering it by copying and then modifying the output of curl -XGET "localhost:9200/index/type/\_mapping" On Wednesday, November 7, 2012 1:37:58 PM UTC-5, Jérôme Gagnon wrote: > I'm pretty sure you cannot change the mapping while it has been created... > you can try to close the index then change it, but then again I offer no > certitude. If you don't want to re-create your index, you can (I think) add > a new field to your mapping. > > On Wednesday, November 7, 2012 1:27:22 PM UTC-5, Nick Pirollo wrote: > > > Thank you Jerome, > > > > when i try to change the mapping i get the issue of: > > > > {"error":"MergeMappingException[Merge failed with failures {[Can't merge > > a non object mapping [location\_latlon] with an object mapping > > [location\_latlon]]}]","status":400} > > > > is there documentation on modifying a mapping with merge errors? > > > > On Wednesday, November 7, 2012 1:25:32 PM UTC-5, Jérôme Gagnon wrote: > > > > > Your location fields need to be type geo\_point, like > > > this: "location\_latlong":{"type":"geo\_point", lat\_lon:true} > > > > > > On Wednesday, November 7, 2012 1:22:08 PM UTC-5, Nick Pirollo wrote: > > > > > > > We recently had some issues with Elasticsearch over at cliqsearch.comand managed to get things back for searching. Our only issue is that > > > > GeoPoint filtering is now causing errors when we search even though all > > > > mappings seem to be there it is saying it cannot find out geo\_point > > > > location\_latlon. Below is the error as well as the mapping from our ES > > > > server, and if you search on [cliqsearch.com](http://cliqsearch.com) you can reproduce the > > > > error by typing a search with a city or town after (ie. fun in philly or > > > > yogurt philly, etc.) > > > > > > > > Mapping for snowball2: > > > > > > > > { > > > > "pages-snowball2" : { > > > > "properties" : { > > > > "tags" : { > > > > "type" : "string" > > > > }, > > > > "phone" : { > > > > "type" : "string" > > > > }, > > > > "date\_indexed" : { > > > > "format" : "dateOptionalTime", > > > > "type" : "date" > > > > }, > > > > "location\_zip" : { > > > > "type" : "string" > > > > }, > > > > "website" : { > > > > "type" : "string" > > > > }, > > > > "metro" : { > > > > "type" : "string" > > > > }, > > > > "category1" : { > > > > "type" : "string" > > > > }, > > > > "location\_latlon" : { > > > > "dynamic" : "true", > > > > "properties" : { > > > > "lon" : { > > > > "type" : "double" > > > > }, > > > > "lat" : { > > > > "type" : "double" > > > > } > > > > } > > > > }, > > > > "category3" : { > > > > "type" : "string" > > > > }, > > > > "location\_city" : { > > > > "type" : "string" > > > > }, > > > > "category2" : { > > > > "type" : "string" > > > > }, > > > > "id" : { > > > > "type" : "string" > > > > }, > > > > "location\_state" : { > > > > "type" : "string" > > > > }, > > > > "location\_street2" : { > > > > "type" : "string" > > > > }, > > > > "phone\_bare" : { > > > > "type" : "string" > > > > }, > > > > "description" : { > > > > "type" : "string" > > > > }, > > > > "name" : { > > > > "type" : "string" > > > > }, > > > > "location\_street" : { > > > > "type" : "string" > > > > } > > > > } > > > > } > > > > } > > > > > > > > error per search: > > > > SearchPhaseExecutionException[Failed to execute phase [query], total > > > > failure; shardFailures {[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][0]: > > > > SearchParseException[[fb][0]: from[-1],size[-1]: Parse Failure [Failed to > > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][4]: > > > > SearchParseException[[fb][4]: from[-1],size[-1]: Parse Failure [Failed to > > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][2]: > > > > SearchParseException[[fb][2]: from[-1],size[-1]: Parse Failure [Failed to > > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > > [location\_latlon]]; }{[YzlaeRMESNuywR\_RlnomKg][fb][1]: > > > > SearchParseException[[fb][1]: from[-1],size[-1]: Parse Failure [Failed to > > > > parse source [{"query":{"filtered":{"query":{"query\_string":{"query":"funny > > > > philly","fields":["name","description","location\_city^4","location\_state","location\_zip","category1^3","category2^3","category3^3","tags^4"]}},"filter":{"geo\_bounding\_box":{"location\_latlon":{"top\_left":{"lat":"40.1851042914763","lon":"-75.6488143721204"},"bottom\_right":{"lat":"39.6978282085237","lon":"-74.909490874075"}}}}}}}]]]; > > > > nested: QueryParsingException[[fb] failed to find geo\_point field > > > > [location\_latlon]]; }] > > > > > > > > Thank you and feel free to let me know if more info is needed. > > > > Nick -- ---
**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, 3:05am UTC](https://discuss.elastic.co/t/elasticsearch-mapping-and-search-issue/9604/6 "2017-07-06T03:05:38Z")