Elasticsearch Range Query with wildcard in field name

Question

I have a simple range query:

{
"query": {
    "range": {
        "unified_source.step_11.sizeIncome":  {
             "gte" : 10
        }
    }
}

}

But I need to apply this query to all nested objects, like this:

{
"query": {
    "range": {
        "unified_source.*.sizeIncome":  {
             "gte" : 10
        }
    }
}

}

This returns no hits.

Is that possible to use some wildcard there?

Can I 'combine' that query with Query String Query somehow? (In Query String wildcard can be used to search "within" specific inner elements of the document).

Thanks

Val · Accepted Answer · 2019-02-19 10:04:31Z

2

Yes, you can do range queries in a query_string query like this:

{
    "query": {
        "query_string": {
            "query": "unified_source.*.sizeIncome:>=10"
        }
    }
}

answered Feb 19, 2019 at 10:04

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

alxv Over a year ago

Thank you. This query looks well, but it leads to jvm heap usage keeps increasing slowly and there is no response for a long time. No responce at all. Strange, beacause I have only 100 documents within that index.

Val Over a year ago

Well, wildcards are rarely a good idea when it comes to performance. but indeed, if you only have 100 documents, that's weird

Collectives™ on Stack Overflow

Elasticsearch Range Query with wildcard in field name

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related