We recently had some issues with ElasticSearch over at 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 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
--