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: <CAE4tqLN9wcqF0J2w1HN7oveg77yLxDS2Nzr92SS9L1=Qp3iBrw@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>
Date: Fri, 13 May 2016 09:36:59 -0600
Message-ID: <CAFWP_DqonVUX9GO7QR1oQ1LRfdEr-prLer2t6YMD+5ETKy8xgg@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=001a11439e6ab0c9430532bb0b70
archived-at: Fri, 13 May 2016 15:37:20 -0000

--001a11439e6ab0c9430532bb0b70
Content-Type: text/plain; charset=UTF-8

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
> > >
> > >
> >
>

--001a11439e6ab0c9430532bb0b70--