It depends how your documents are modeled. If both the action and user id fields are in the same document, then this could be a simple not>term filter, but I'm afraid that what you are looking for is a join, which elasticsearch does not support (well, it does, but only specific cases via parent/child and nested docs, not general-purpose joins).
On Wed, Jan 7, 2015 at 11:43 AM, Ho-sang Jeon <[email protected]> wrote: > Here is a simple but difficult question. I want to do an aggregation for a > query results that should be use*"NOT IN"* functionality like any RDBMS' > SQL. > > For example, I want to do a job something like below. > > curl -XGET http://localhost:9200/my_index/my_type/_search?pretty -d '{ > "query": { > "filtered": { > "filter": { > !!! Documents whose 'user_id' field value is 'NOT IN' > distinct user_ids where the 'action' field value is 'signup' !!! > } > } > }, > "aggregations": { > "distinct_users":{ > "cardinality": { > "field": "user_id", > "precision_threshold": 1000000 > } > } > } > }' > > Is it possible to get the results what I want in Elasticsearch? > > Thanks in advance. > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/4aa88ff2-e0ae-45f3-85f4-9c6afba3842c%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/4aa88ff2-e0ae-45f3-85f4-9c6afba3842c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Adrien Grand -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j6VeJZG_2qgs9H6TZpD2du8rRuy-G%2BYTBi6C4cc4uPPmw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
