Query without using dynamic scripting

Question

I have the following query which currently uses dynamic scripting. I have since found that my host doesn't support this, as it has wider reaching security implications. How would I rewrite this script so that it doesn't use dynamic script?

{
  "size": 0,
  "aggs": {
    "filtered_cells": {
      "filter": {
        "geo_bounding_box": {
          "loc": {
            "top_left": "58.645976, -13.515625",
            "bottom_right": "50.524473, 2.436523"
          }
        }
      },
      "aggs": {
        "cells": {
          "geohash_grid": {
            "field": "loc",
            "precision": 2
          },
          "aggs": {
            "center_lat": {
              "avg": {
                "script": "doc['loc'].lat"
              }
            },
            "center_lon": {
              "avg": {
                "script": "doc['loc'].lon"
              }
            }
          }
        }
      }
    }
  },
  "query": {
    "match_all": {}
  }
}

Can you move the script to file? Or, better said, does your host allow you to place .groovy files inside the ES installation directory? — Andrei Stefan
– Andrei Stefan, Commented May 28, 2015 at 11:45

Val · Accepted Answer · 2015-05-28 12:19:52Z

2

+50

You can store your scripts on the file system and reference them from within your query/aggregations.

Create a file named config/scripts/lat.groovy with the following content

 doc['loc'].lat

Create another file named config/scripts/lon.groovy with the following content

 doc['loc'].lon

Then change your query to this:

{
  "size": 0,
  "aggs": {
    "filtered_cells": {
      "filter": {
        "geo_bounding_box": {
          "loc": {
            "top_left": "58.645976, -13.515625",
            "bottom_right": "50.524473, 2.436523"
          }
        }
      },
      "aggs": {
        "cells": {
          "geohash_grid": {
            "field": "loc",
            "precision": 2
          },
          "aggs": {
            "center_lat": {
              "avg": {
                "script_file": "lat"
              }
            },
            "center_lon": {
              "avg": {
                "script_file": "lon"
              }
            }
          }
        }
      }
    }
  },
  "query": {
    "match_all": {}
  }
}

edited May 28, 2015 at 12:19

answered May 28, 2015 at 11:47

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrei Stefan Over a year ago

"Indexing your scripts" will not work if dynamic scripting is disabled ;-).

Community · Accepted Answer · 2017-05-23 12:30:02Z

1

Apart from placing the actual script on a .groovy file, like I mentioned (more details here), you could define a native script. More involved than the groovy-on-file approach but is much more flexible. In your case, the script is really simple :-) and you don't need the flexibility though, but the option exists (implementation sample from yours truly): ElasticSearch: aggregation on _score field w/ Groovy disabled

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered May 28, 2015 at 11:55

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

Collectives™ on Stack Overflow

Query without using dynamic scripting

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related