Hello,
I'm getting the error No field found for [idling_points] in mapping with types [] when I'm trying to execute a query with script_fields
My query:
curl -X POST -H "Content-Type: application/json" -H "Cache-Control: no-cache" -d '{
"query": {
"match_all": {}
},
"script_fields": {
"total_idling": {
"script": {
"lang": "painless",
"inline": "doc.idling_points.length"
}
}
}
}' "http://127.0.0.1:9200/_search"
My mapping template creation is here: https://gist.github.com/mauriciofs/3cbe65b64acba2b0e199a4e59e0809d8
And the document has this structure:
{
"_index": "journeys-2016-12",
"_type": "journeys",
"_id": "357464034784170-1482391814",
"_score": 1,
"_source": {
"tracker_uid": 824,
"driver_id": "",
"start_location": "[Route_4.1_BS 1-93] 200 Jugback Ln, Castlefarm, Swords, Co. Dublin, Ireland",
"stop_location": "Cloghran, Dublin, Ireland",
"company_id": 27009,
"vehicle_id": 1025,
"start_date_time": "2016-12-22 07:30:14",
"end_date_time": "2016-12-22 08:10:36",
"speed_max_kph": 59,
"journey_time_secs": 2422,
"created_at": "2016-12-22 08:08:23",
"stop_point": {
"lon": -6.3601,
"lat": 53.41
},
"distance_km": 17.78,
"start_point": {
"lat": 53.464,
"lon": -6.22312
},
"speed_average_kph": 26,
"idling_time_secs": 924,
"journeys_per_hour": [],
"idling_points": [
{
"start": {
"acquisition_time": 1482391814,
"location": {
"lat": 53.464,
"lon": -6.22312
}
},
"end": {
"acquisition_time": 1482392581,
"location": {
"lat": 53.464,
"lon": -6.22312
}
}
},
{
"start": {
"acquisition_time": 1482392783,
"location": {
"lat": 53.46686,
"lon": -6.23842
}
},
"end": {
"acquisition_time": 1482392790,
"location": {
"lat": 53.46692,
"lon": -6.23873
}
}
},
{
"start": {
"acquisition_time": 1482392858,
"location": {
"lat": 53.45954,
"lon": -6.24207
}
},
"end": {
"acquisition_time": 1482392889,
"location": {
"lat": 53.45943,
"lon": -6.2423
}
}
},
{
"start": {
"acquisition_time": 1482393584,
"location": {
"lat": 53.42337,
"lon": -6.32573
}
},
"end": {
"acquisition_time": 1482393703,
"location": {
"lat": 53.42343,
"lon": -6.32904
}
}
}
],
"tracker_id": "357464034784170",
"vehicle_details": {
"registration": "08D69271",
"description": "WI Gerry Maguire",
"label": "WI.Gerry Maguire",
"label_color": "blue_label",
"icon": "caddy",
"model": "Caddy 2.0 D 51KW DSD 6DR",
"fuel_type": "diesel",
"type": "van",
"make": "Volkswagen "
},
"start_date": "2016-12-22",
"start_time": "07:30:14",
"end_date": "2016-12-22",
"end_time": "08:10:36",
"start_location_group": "null",
"stop_location_group": "",
"start_location_name": "Route_4.1_BS 1-93",
"stop_location_name": "",
"driver_details": {}
}
}
idling_points it's an array of objects which is a nested type, am I doing the query wrong?
Elastic search 5.1 Lucene version 6.4.0