In case it's helpful for a quick and dirty peek at your facets, the following URL (in a browser or Curl) will get you basic facets for a field named "category" -- assuming you change the IP address / hostname to match yours.
http:/XXX.XXX.XX.XX:8983/solr/statdx_shard1_replica3/select q=*%3A*&rows=0&wt=json&indent=true&facet=true&facet.field=category You can also do this in the Admin UI by checking the "facet" box, and entering the field name in the facet.field that pops up. You can leave the query field at the default *:* You need to make sure that you put a "0" in the rows field as well (right under "sort") in order to just get back the facet counts. On Fri, May 13, 2016 at 7:52 AM, Joel Bernstein <joels...@gmail.com> wrote: > 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 > > > > > > > > >