Elasticsearch return only results that match array of ids

Question

Is it possible to use elastic search to query only within a set of roomIds?

I tried using bool and should:

query: {
    bool: {
        must: [
        {
            multi_match: {
            operator: 'and',
            query: keyword,
            fields: ['content'],
            type: 'most_fields'
            }
        },
        { term: { users: caller } },
        {
            bool: {
            should: 
                term: {
                    room: [list of roomIds]
                }
            }
        }
        ]
    }
},

It works but when I have more than 1k roomIds I get "search_phase_execution_exception".

Is there a better way to do this? Thanks.

Which version are you using?

Vova Bilyachat
– Vova Bilyachat

2020-01-02 02:55:35 +00:00
Commented Jan 2, 2020 at 2:55 — Vova Bilyachat
– Vova Bilyachat, Commented Jan 2, 2020 at 2:55

Vova Bilyachat · Accepted Answer · 2020-01-02 02:58:45Z

2

For array search you should be using terms query instead of term

query: {
    bool: {
        must: [
        {
            multi_match: {
            operator: 'and',
            query: keyword,
            fields: ['content'],
            type: 'most_fields'
            }
        },
        { term: { users: caller } },
        {
            bool: {
            should: 
                terms: {
                    room: [list of roomIds]
                }
            }
        }
        ]
    }
},

From documentation

By default, Elasticsearch limits the terms query to a maximum of 65,536 terms. This includes terms fetched using terms lookup. You can change this limit using the index.max_terms_count setting.

answered Jan 2, 2020 at 2:58

Vova Bilyachat

19.5k4 gold badges60 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch return only results that match array of ids

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related