You may also want to try out the SQL interface in Solr 6.0 which supports SELECT DISTINCT queries.
https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-SELECTDISTINCTQueries Joel Bernstein http://joelsolr.blogspot.com/ On Fri, May 13, 2016 at 9:47 AM, GW <thegeofo...@gmail.com> wrote: > Thank you Shawn, > > I will toy with these over the weekend. Solr/Hadoop/Hbase has been a nasty > learning curve for me, > It would probably would have been a lot easier if I didn't have 30 years of > RDBMS stuck in my head. > > Again, > > Many thanks for your response. > > > On 13 May 2016 at 08:57, Shawn Heisey <apa...@elyograg.org> wrote: > > > On 5/13/2016 6:48 AM, GW wrote: > > > Let's say I have 10,000 documents and there is a field named "category" > > and > > > lets say there are 200 categories but I do not know what they are. > > > > > > My question: Is there a query/filter that can pull a list of distinct > > > categories? > > > > Sounds like a job for faceting or grouping. Which one of them to use > > will depend on exactly what you're trying to obtain in your results. > > > > https://cwiki.apache.org/confluence/display/solr/Faceting > > https://cwiki.apache.org/confluence/display/solr/Result+Grouping > > > > Thanks, > > Shawn > > > > >