Re: Is there an equivalent to an SQL "select distinct" in Solr
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 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 > 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 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 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 >> > > >> > > >> > >> > >
Re: Is there an equivalent to an SQL "select distinct" in Solr
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 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 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 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 > > > > > > > > >
Re: Is there an equivalent to an SQL "select distinct" in Solr
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 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 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 > > > > >
Re: Is there an equivalent to an SQL "select distinct" in Solr
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 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 > >
Re: Is there an equivalent to an SQL "select distinct" in Solr
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
Is there an equivalent to an SQL "select distinct" in Solr
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