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: <CAF2DzVXi3ycXGVKthi1_bN0St+MvB==tA+EYSTtL6q_iXs8sBg@mail.gmail.com>
References: <CAF2DzVU636bBk_cinaPeDj5OMMiR7LSugeUihiJ4Toz89_5E-A@mail.gmail.com>
 <CAEFAe-EBZoWASqMfe-6bhiLJ70_aKNk2ryNbSyniPzhhAYJc6w@mail.gmail.com>
 <CAF2DzVV7t0XzxndGWfxn3nTA=s-9UK4dRO_6v8AYt=KT4=-=SQ@mail.gmail.com>
 <CAB_8Yd8FQZQ+z7kFYf08dL5zbBVJtw9Y_B3amQLMDwpD7Jt4kA@mail.gmail.com> <CAF2DzVXi3ycXGVKthi1_bN0St+MvB==tA+EYSTtL6q_iXs8sBg@mail.gmail.com>
From: Mikhail Khludnev <mkhl@apache.org>
Date: Tue, 4 Oct 2016 21:58:57 +0300
Message-ID: <CAF8TkC7Xn_AxFLCrRnA3_U+7zpf-Mff0CgFa855FzcfgZ+9yZQ@mail.gmail.com>
Subject: Re: Faceting on both Parent and Child records in Block Join Query Parser
To: solr-user <solr-user@lucene.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c0892c8209a8c053e0ea7c0
archived-at: Tue, 04 Oct 2016 18:59:01 -0000

--94eb2c0892c8209a8c053e0ea7c0
Content-Type: text/plain; charset=UTF-8

Edwin,
It seems like you try to pull document hierarchy back. That's usually done
by searching parents and fl=[child ..],,.

On Tue, Oct 4, 2016 at 5:22 PM, Zheng Lin Edwin Yeo <edwinyeozl@gmail.com>
wrote:

> Some of the sample documents are like the following:
>
> Author is the Header, while Books are the Child
>
> Author: Edwin
> Books: Book 1
>            Book 2
>            Book 3
>
> Author: John
> Books: Book 4
>            Book 5
>
> For this query:
>
> http://localhost:8983/solr/collection1/select?q=*:*
> &json.facet={
>    author:{
>         type:terms,
>         field:author_s,
>   domain: { blockParent : "type_s:author" }
>    },
>    books:{
> type:terms,
> field:book_s,
> domain: { blockChild : "type_s:book" }
>   }
> }&fl=null&rows=0
>
> I'll get the following results:
>
> "facets":{
>     "count":2,
>     "author":{
>       "buckets":[{
>           "val":"Edwin",
>           "count":1,
>           "books":{
>             "buckets":[]}},
>         {
>           "val":"John",
>           "count":1,
>           "books":{
>             "buckets":[]}},
>
> I can't manage to get the list of books to be displayed in the buckets for
> books.
>
>
> Regards,
> Edwin
>
>
> On 4 October 2016 at 19:29, Yonik Seeley <yseeley@gmail.com> wrote:
>
> > Perhaps show a couple sample documents, and then what data you're
> > looking for in a response?
> > This stuff can be tough to pin down without concrete examples.
> >
> > -Yonik
> >
> >
> > On Tue, Oct 4, 2016 at 5:22 AM, Zheng Lin Edwin Yeo
> > <edwinyeozl@gmail.com> wrote:
> > > I have tried to use this nested query, but I still can't get results
> for
> > > the list of books.
> > >
> > > http://localhost:8983/solr/collection1/select?q=*:*
> > > &json.facet={
> > >    items:{
> > >       type:terms,
> > >       field:author_s,
> > >  domain: { blockParent : "type_s:author" },
> > >  facet:{
> > > by1:{
> > > type:terms,
> > > field:book_s,
> > > domain: { blockChild : "type_s:book" }
> > > }
> > > }
> > >  }
> > >    }
> > > }&fl=null&rows=0
> > >
> > >
> > > Only when I didn't use the nested method, but query it individually
> like
> > > the one below, the I managed to get the result.
> > >
> > > http://localhost:8983/solr/collection1/select?q=*:*
> > > &json.facet={
> > >    items:{
> > >         type:terms,
> > >         field:author_s,
> > >   domain: { blockParent : "type_s:author" }
> > >    },
> > >    by1:{
> > > type:terms,
> > > field:book_s,
> > > domain: { blockChild : "type_s:book" }
> > >   }
> > > }&fl=null&rows=0
> > >
> > >
> > > Regards,
> > > Edwin
> > >
> > >
> > > On 4 October 2016 at 15:22, Alexandre Rafalovitch <arafalov@gmail.com>
> > > wrote:
> > >
> > >> You need to switch the domain to the child records. It is somewhere in
> > the
> > >> guide or Yonik's blog linked.
> > >>
> > >> Regards,
> > >>    Alex
> > >>
> > >> On 4 Oct 2016 1:55 PM, "Zheng Lin Edwin Yeo" <edwinyeozl@gmail.com>
> > wrote:
> > >>
> > >> > Hi,
> > >> >
> > >> > Is it possible to do nested faceting on both records in parent and
> > child
> > >> in
> > >> > a single query?
> > >> >
> > >> > For example, I want to facet both author_s and book_s. Author is
> > indexed
> > >> as
> > >> > a parent, whereas Book is indexed as a child.
> > >> >
> > >> > I tried the following JSON Facet query, which is to do a facet of
> all
> > the
> > >> > list of author (in the parent), followed by a facet of all the list
> of
> > >> > books (in the child) that are written by the author.
> > >> >
> > >> > http://localhost:8983/solr/collection1/select?q=*:*
> > >> > &json.facet={
> > >> >    items:{
> > >> >       type:terms,
> > >> >       field:author_s,
> > >> >  facet:{
> > >> > by1:{
> > >> > type:terms,
> > >> > field:book_s
> > >> > }
> > >> > }
> > >> >  }
> > >> >    }
> > >> > }&fl=null&rows=0
> > >> >
> > >> >
> > >> > However, it only managed to return me the facet of the list of
> > author. I
> > >> > could not get any results for the list of books. Is this possible to
> > be
> > >> > done, or what could be wrong with my query?
> > >> >
> > >> >
> > >> > Regards,
> > >> > Edwin
> > >> >
> > >>
> >
>


-- 
Sincerely yours
Mikhail Khludnev

--94eb2c0892c8209a8c053e0ea7c0--