Not sure this really helps you but it might be easier and more reliable of
a search to do this as two separate queries the first would just be an agg
listing all distinct users and the second an agg listing users who have an
action of "signup"? and then just subtracting that list from the first.
On Wednesday, January 7, 2015 6:18:34 AM UTC-5, Ho-sang Jeon wrote:
>
> Thanks Andrien Grand.
>>
>
> To clarify my quesion, I have added some example data below.
>
> Here is an example data.
>
> curl -s -XPOST 'localhost:9200/my_index/my_type/1' -d'{ "user_id": 1234,
> "action": "signup" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/2' -d'{ "user_id": 1234,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/3' -d'{ "user_id": 1234,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/4' -d'{ "user_id": 5678,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/5' -d'{ "user_id": 5678,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/6' -d'{ "user_id": 9012,
> "action": "signup" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/7' -d'{ "user_id": 9012,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/8' -d'{ "user_id": 9012,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/9' -d'{ "user_id": 3456,
> "action": "visit" }'
> curl -s -XPOST 'localhost:9200/my_index/my_type/10' -d'{ "user_id": 3456,
> "action": "visit" }'
>
> What I really want to get is the "Documents whose user_id DOES NOT signed
> up based on these log data". So, documents [*4, 5, 9, 10*] are the final
> results what I want to get.
>
> 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/1cf8f178-08de-4e8b-943e-73f3e5ce8042%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
