Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <CAFWP_DqonVUX9GO7QR1oQ1LRfdEr-prLer2t6YMD+5ETKy8xgg@mail.gmail.com>
References: <CAGb2VChh9ofp2GWZAZiEW72qTjoPcWVzBot5NymSA4Zag343bg@mail.gmail.com>
	<070b9715-f4c3-7e16-8f93-30bde983c0ea@elyograg.org>
	<CAGb2VCgps4HU5fD1e0kNXunfJx4WWvgD=HKFOfY2sxozuKfb=g@mail.gmail.com>
	<CAE4tqLN9wcqF0J2w1HN7oveg77yLxDS2Nzr92SS9L1=Qp3iBrw@mail.gmail.com>
	<CAFWP_DqonVUX9GO7QR1oQ1LRfdEr-prLer2t6YMD+5ETKy8xgg@mail.gmail.com>
Date: Fri, 13 May 2016 09:42:43 -0600
Message-ID: <CAFWP_Dr4xc2Gd8R+HyPhcjfFjW+w5a4XJY_Dhj908xqNeN=0Lg@mail.gmail.com>
Subject: Re: Is there an equivalent to an SQL "select distinct" in Solr
From: John Bickerstaff <john@johnbickerstaff.com>
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=047d7b111f092bd98f0532bb20e3
archived-at: Fri, 13 May 2016 15:42:51 -0000

--047d7b111f092bd98f0532bb20e3
Content-Type: text/plain; charset=UTF-8

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 <john@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 <joelsolr@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 <thegeoforce@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 <apache@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
>> > >
>> > >
>> >
>>
>
>

--047d7b111f092bd98f0532bb20e3--