Elasticsearch query against multiple types

Question

I have two types stored in ES:

Photos (fields: photo-id, description, createDateAsLong)
VisitHistory (username, photo-id - with 30days TTL)

Is it possible to query ES for records of type Photos which photo-id doesn't exists in VisitHistory (for some username value). I mean a query which is equivalent of sql query like this:

SELECT * FROM Photos WHERE photo-id NOT IN (SELECT photo-id FROM VisitHistory WHERE username = 'somefoousername');

imotov · Accepted Answer · 2012-11-16 03:40:02Z

1

If you make Photos a parent document and VisitHistory a child document of Photos, you should be able to use a combination of not and has_child filters to build such request.

answered Nov 16, 2012 at 3:40

imotov

30.2k3 gold badges93 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch query against multiple types

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