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 <[email protected]>wrote: > 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 [email protected]. > 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 [email protected]. 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.
