search

sirensolutions / siren-join

[This is the old, single node version for Elasticsearch 2.x, see the latest "Siren Federate" plugin for distributed Elasticsearch 5.x and 6.x capabilities]
http://siren.io
GNU Affero General Public License v3.0
183 stars 60 forks source link

Add not exists functionality #88

Closed rostiar closed 8 years ago

rostiar commented 8 years ago

Hi,

It would be nice to add NOT EXISTS functionality

Thanks, Rostislav.

scampi commented 8 years ago

Can you describe what you would like ?

rostiar commented 8 years ago

Hi @scampi, For example I have collection of documents from my app servers. It looks like client x were served by server A, client x were served by server B and so on... Now I need to know what clients were server by server A but were not served by server B during the same period of time. In SQL it would be not exists query. Now siren-join supports only exists and I cannot run not exists query. Rostislav.

scampi commented 8 years ago

The siren-join query is just like any other query in ES. Therefore, you can use the bool query to wrap the siren-join in a must_not clause.

rostiar commented 8 years ago

Good idea, thanks. I will try it and get back.