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. For more options, visit https://groups.google.com/d/optout.
