How to access document id in a script in ElasticSearch?

Question

I'm trying to write a query that aggregates on document type. The thing is, the document type can be obtained from the document id - it's 4-5 first characters of the id, like BPR::fawL5CcPE72Wf3m93hUg2.
Here's the query I put together:

{
    "query": {
        "match_all": { }
    },
    "aggregations": {
        "by_document_type": {
            "script": {
                "script": "doc['_id'].value.substring(0, 3)",
                "order": { 
                    "_count": "desc" 
                }
            }
        }
    }
}

but it says Parse Failure [Could not find aggregator type [script] in [by_document_type]]];.

What did I do wrong?

Val · Accepted Answer · 2015-09-03 09:02:19Z

2

You simply need to use a terms aggregation and feed your script in it:

{
  "query": {
    "match_all": {}
  },
  "aggregations": {
    "by_document_type": {
      "terms": {
        "script": "doc['_id'].value.substring(0, 3)",
        "order": {
          "_count": "desc"
        }
      }
    }
  }
}

edited Sep 3, 2015 at 9:02

answered Sep 3, 2015 at 8:54

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

chester89 Over a year ago

it gives me 'Parse Failure [Unknown key for a START_OBJECT in [by_document_type]'

Val Over a year ago

Whoops, my bad, you had one too many "script". I've removed it, please check again. So basically, just replace your first script by terms and you're fine.

Collectives™ on Stack Overflow

How to access document id in a script in ElasticSearch?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related