I should clarify: http:/XXX.XXX.XX.XX:8983/solr/yourCoreName/select q=*%3A*&rows=0&wt=json&indent=true&facet=true&facet.field=category
"yourCoreName" will get built in for you if you use the Solr Admin UI for queries -- On Fri, May 13, 2016 at 9:36 AM, John Bickerstaff <j...@johnbickerstaff.com> wrote: > 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 >> > > >> > > >> > >> > >
