Implementing SELECT distinct user_name FROM index?


(Oliver B. Fischer) #1

Hi,

after reading the docs and googling for a while I got the impression it
is not possible to ask ElasticSearch for a distinct values of a document
field. I know the terms facet but it won't help me to return 100,000
values. Right?

So is there another way to ask such kind of questions? At the moment I
see only two possibilites: a) SQL and a RDBMS or b) fetching all
relevant documents ordered by the desired field and kicking out
duplicates by hand.

Bye,

Oliver

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/52F2380E.7050706%40swe-blog.net.
For more options, visit https://groups.google.com/groups/opt_out.


(Adrien Grand) #2

I think for 100k, it is still OK to use a terms facet. This is going to
generate some network traffic but the issue would be the same with a RDBMS
anyway. However, I wouldn't recommend using sorting and kicking out
duplicates: this will either require deep paging or getting all results in
a single large page which are two things that would perform badly.

On Wed, Feb 5, 2014 at 2:09 PM, Oliver B. Fischer mailsink@swe-blog.netwrote:

Hi,

after reading the docs and googling for a while I got the impression it is
not possible to ask ElasticSearch for a distinct values of a document
field. I know the terms facet but it won't help me to return 100,000
values. Right?

So is there another way to ask such kind of questions? At the moment I see
only two possibilites: a) SQL and a RDBMS or b) fetching all relevant
documents ordered by the desired field and kicking out duplicates by hand.

Bye,

Oliver

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/52F2380E.7050706%40swe-blog.net.
For more options, visit https://groups.google.com/groups/opt_out.

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j6haNNi%3Dbj0VkL3Gxzy_iw%2BMYd%2B4jZGMUz1gwL36rtyjA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3