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: <CAPJfaaFRQ2oxX4TDGcWxG3N+L9i36x84w2QEvqSpBMFHggXBpQ@mail.gmail.com>
References: <CAPJfaaFRQ2oxX4TDGcWxG3N+L9i36x84w2QEvqSpBMFHggXBpQ@mail.gmail.com>
From: Joel Bernstein <joelsolr@gmail.com>
Date: Tue, 18 Apr 2017 08:51:48 -0400
Message-ID: <CAE4tqLPVNdEVj-VpomUQsvAe3_YuAvecoHCaPVep1bQ3B6DkAg@mail.gmail.com>
Subject: Re: Innerjoin streaming expressions - Invalid JoinStream error
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a114b18c8029a29054d705fb9
archived-at: Tue, 18 Apr 2017 12:51:55 -0000

--001a114b18c8029a29054d705fb9
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 I looked through the test cases I don't think we have this covered exactly
as it's written.  Can you log a jira for this?

Joel Bernstein
http://joelsolr.blogspot.com/

On Tue, Apr 18, 2017 at 6:33 AM, Dominique Bejean <dominique.bejean@eolya.f=
r
> wrote:

> Hi,
>
> I don not understand what I am doing wrong il this simple query.
>
> curl --data-urlencode 'expr=3DinnerJoin(
>                                 search(books,
>                                    q=3D"*:*",
>                                    fl=3D"id",
>                                    sort=3D"id asc"),
>                                 searchreviews,
>                                    q=3D"*:*",
>                                    fl=3D"id_book_s",
>                                    sort=3D"id_book_s asc"),
>                                 on=3D"id=3Did_books_s"
>                             )' http://localhost:8983/solr/books/stream
>
> {"result-set":{"docs":[{"EXCEPTION":"Invalid JoinStream - all incoming
> stream comparators (sort) must be a superset of this stream's
> equalitor.","EOF":true}]}}
>
>
> It is tottaly similar to the documentation example
> =EF=BB=BF
> innerJoin(
>   search(people, q=3D*:*, fl=3D"personId,name", sort=3D"personId asc"),
>   search(pets, q=3Dtype:cat, fl=3D"ownerId,petName", sort=3D"ownerId asc"=
),
>   on=3D"personId=3DownerId"
> )
>
>
>
> Queries on each collection give :
>
> $ curl --data-urlencode 'expr=3Dsearch(books,
>                                    q=3D"*:*",
>                                    fl=3D"id, title_s, pubyear_i",
>                                    sort=3D"pubyear_i asc",
>                                    qt=3D"/export")'
> http://localhost:8983/solr/books/stream
>
> {
>   "result-set": {
>     "docs": [
>       {
>         "title_s": "Friends",
>         "pubyear_i": 1994,
>         "id": "book2"
>       },
>       {
>         "title_s": "The Way of Kings",
>         "pubyear_i": 2010,
>         "id": "book1"
>       },
>       {
>         "EOF": true,
>         "RESPONSE_TIME": 16
>       }
>     ]
>   }
> }
>
>
> $ curl --data-urlencode 'expr=3Dsearch(reviews,
>                                    q=3D"author_s:d*",
>                                    fl=3D"id, id_book_s, stars_i, review_d=
t",
>                                    sort=3D"id_book_s asc",
>                                    qt=3D"/export")'
> http://localhost:8983/solr/reviews/stream
>
> {
>   "result-set": {
>     "docs": [
>       {
>         "stars_i": 3,
>         "id": "book1_c2",
>         "id_book_s": "book1",
>         "review_dt": "2014-03-15T12:00:00Z"
>       },
>       {
>         "stars_i": 4,
>         "id": "book1_c3",
>         "id_book_s": "book1",
>         "review_dt": "2014-12-15T12:00:00Z"
>       },
>       {
>         "stars_i": 3,
>         "id": "book2_c2",
>         "id_book_s": "book2",
>         "review_dt": "1994-03-15T12:00:00Z"
>       },
>       {
>         "stars_i": 4,
>         "id": "book2_c3",
>         "id_book_s": "book2",
>         "review_dt": "1994-12-15T12:00:00Z"
>       },
>       {
>         "EOF": true,
>         "RESPONSE_TIME": 47
>       }
>     ]
>   }
> }
>
>
> Can someone help me to find my mistake ?
>
> Regards
>
> Dominique
> --
> Dominique B=C3=A9jean
> 06 08 46 12 43
>

--001a114b18c8029a29054d705fb9--