Re: Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread John Bickerstaff
I should clarify: http:/XXX.XXX.XX.XX:8983/solr/yourCoreName/select q=*%3A*=0=json=true=true=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 wrote: > In case it's helpful

Re: Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread John Bickerstaff
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

Re: Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread Joel Bernstein
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

Re: Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread GW
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

Re: Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread Shawn Heisey
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

Is there an equivalent to an SQL "select distinct" in Solr

2016-05-13 Thread GW
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? Thanks in advance, GW