Hi,
I don not understand what I am doing wrong il this simple query.
curl --data-urlencode 'expr=innerJoin(
search(books,
q="*:*",
fl="id",
sort="id asc"),
searchreviews,
q="*:*",
fl="id_book_s",
sort="id_book_s asc"),
on="id=id_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
innerJoin(
search(people, q=*:*, fl="personId,name", sort="personId asc"),
search(pets, q=type:cat, fl="ownerId,petName", sort="ownerId asc"),
on="personId=ownerId"
)
Queries on each collection give :
$ curl --data-urlencode 'expr=search(books,
q="*:*",
fl="id, title_s, pubyear_i",
sort="pubyear_i asc",
qt="/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=search(reviews,
q="author_s:d*",
fl="id, id_book_s, stars_i, review_dt",
sort="id_book_s asc",
qt="/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éjean
06 08 46 12 43
