Hi there,
We're just getting started with ELK and are using:
Elasticsearch 1.4.4
Kibana 4.0
on
Ubuntu 14.04
We needed to create a scripted field to calculate the ratio between two
numeric fields. These fields are not on all events and only started
appearing at all a day ago (so older indexes don't have it at all).
name: ads_per_page
script: doc['ads_found'].value / max(1, doc['pages_parsed'].value)
It seemed to be working great at first but now Kibana has been resurfacing
these elasticsearch errors constantly and I can't seem to find any
information about it online (too new?).
This repeats for every shard as far as I can tell (there are about 2 weeks
of indexes there. Any suggestions would be appreciated.
Shard Failures
The following shard failures ocurred:
Index: logstash-2015.02.21 Shard: 0 Reason: SearchParseException[[logstash-2015.02.21][0]:
query[ConstantScore(BooleanFilter(+cache(@timestamp:[1425571563220 TO
1425657963220])))],from[-1],size[500],sort[<custom:"@timestamp":
org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@4c1942d3>!]:
Parse Failure [Failed to parse source
[{"size":500,"sort":{"@timestamp":"desc"},"query":{"filtered":{"query":{"query_string":{"analyze_wildcard":true,"query":""}},"filter":{"bool":{"must":[{"range":{"@timestamp":{"gte":1425571563220,"lte":1425657963220}}}],"must_not":[]}}}},"highlight":{"pre_tags":["@kibana-highlighted-field@"],"post_tags":["@/kibana-highlighted-field@"],"fields":{"":{}}},"aggs":{"2":{"date_histogram":{"field":"@timestamp","interval":"30m","pre_zone":"-08:00","pre_zone_adjust_large_interval":true,"min_doc_count":0,"extended_bounds":{"min":1425571563220,"max":1425657963220}}}},"fields":["*","_source"],"script_fields":{"ads_per_page":{"script":"doc['ads_found'].value
/ max(1,
doc['pages_parsed'].value)","lang":"expression"}},"fielddata_fields":["@timestamp"]}]]];
nested: ExpressionScriptCompilationException[Field [ads_found] used in
expression does not exist in mappings];
Does anyone here happen to know what the best practice way of addressing
these indices without the mapping in question? I'd really hate to have to
go through and hand update them all to have the mapping
On Friday, March 6, 2015 at 8:27:48 AM UTC-8, Alex Schokking wrote:
Hi there,
We're just getting started with ELK and are using:
Elasticsearch 1.4.4
Kibana 4.0
on
Ubuntu 14.04
We needed to create a scripted field to calculate the ratio between two
numeric fields. These fields are not on all events and only started
appearing at all a day ago (so older indexes don't have it at all).
name: ads_per_page
script: doc['ads_found'].value / max(1, doc['pages_parsed'].value)
It seemed to be working great at first but now Kibana has been resurfacing
these elasticsearch errors constantly and I can't seem to find any
information about it online (too new?).
This repeats for every shard as far as I can tell (there are about 2 weeks
of indexes there. Any suggestions would be appreciated.
Shard Failures
The following shard failures ocurred:
Index: logstash-2015.02.21 Shard: 0 Reason: SearchParseException[[logstash-2015.02.21][0]:
query[ConstantScore(BooleanFilter(+cache(@timestamp:[1425571563220 TO
1425657963220])))],from[-1],size[500],sort[<custom:"@timestamp":
org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@4c1942d3>!]:
Parse Failure [Failed to parse source
[{"size":500,"sort":{"@timestamp":"desc"},"query":{"filtered":{"query":{"query_string":{"analyze_wildcard":true,"query":""}},"filter":{"bool":{"must":[{"range":{"@timestamp":{"gte":1425571563220,"lte":1425657963220}}}],"must_not":[]}}}},"highlight":{"pre_tags":["@kibana-highlighted-field@"],"post_tags":["@/kibana-highlighted-field@"],"fields":{"":{}}},"aggs":{"2":{"date_histogram":{"field":"@timestamp","interval":"30m","pre_zone":"-08:00","pre_zone_adjust_large_interval":true,"min_doc_count":0,"extended_bounds":{"min":1425571563220,"max":1425657963220}}}},"fields":["*","_source"],"script_fields":{"ads_per_page":{"script":"doc['ads_found'].value
/ max(1,
doc['pages_parsed'].value)","lang":"expression"}},"fielddata_fields":["@timestamp"]}]]];
nested: ExpressionScriptCompilationException[Field [ads_found] used in
expression does not exist in mappings];
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.