Scripts fields error Elastic 5.1


(MaurĂ­cio Ferreira Da Silva) #1

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


(system) #2

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