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: <1331597138.40536302.1458840708127.JavaMail.zimbra@redhat.com>
References: <1445888039.39811500.1458762833401.JavaMail.zimbra@redhat.com>
 <189252143.39821468.1458763767562.JavaMail.zimbra@redhat.com>
 <CANGii8dCm1O98BC86FYCRop=9_Cycpn-eOfAyB5++bU+g6S4sw@mail.gmail.com>
 <1108400994.39850639.1458767763278.JavaMail.zimbra@redhat.com>
 <CANGii8dGVc0wt1nNLOs0468WHBV-ns5LbXoG=056FJv1GJPmXQ@mail.gmail.com>
 <659130681.39989122.1458822205883.JavaMail.zimbra@redhat.com>
 <CANGii8eT=pCQLVTFPB3b_Ao+OCCsBNnjhkCBuTsyE2ERFNsdUg@mail.gmail.com>
 <1331597138.40536302.1458840708127.JavaMail.zimbra@redhat.com>
From: Mikhail Khludnev <mkhludnev@griddynamics.com>
Date: Thu, 24 Mar 2016 23:01:37 +0300
Message-ID: 
 <CANGii8fBat3kfNjk8P=+P9oe14tVkYyHJyu5fZ0Fd2D1Ge-CnQ@mail.gmail.com>
Subject: Re: SyntaxError - Block Join Parent Query
To: solr-user <solr-user@lucene.apache.org>
Content-Type: multipart/alternative; boundary=001a114022c658d887052ed0ec2e

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

On Thu, Mar 24, 2016 at 8:31 PM, Charles Sanders <csanders@redhat.com>
wrote:

> I tried this on another machine with a clean index. I was able to get the
> query to work. Thank you.
>
> Couple of related questions.
> 1) I was able to get this to work on a single shard machine. But I am not
> able to get this query to work on Solr with two shards (SorlCloud). Any
> reason why this does not work with SolrCloud?
>

I hardly imagine. Show me your debugQuery=true output.


> 2) The query pattern you supplied does not appear in the documentation. Do
> you know of any reason why the information in the documentation does not
> work and does not mention your pattern?
>
> https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-BlockJoinQueryParsers

Just nobody wrote it there, but anybody can, and somebody wrote at some
other places
http://blog.griddynamics.com/2013/12/grandchildren-and-siblings-with-block.html?q=block+join
https://cwiki.apache.org/confluence/display/solr/Local+Parameters+in+Queries


>
>
> Thanks again.
>
>
> ----- Original Message -----
>
> From: "Mikhail Khludnev" <mkhludnev@griddynamics.com>
> To: "solr-user" <solr-user@lucene.apache.org>
> Sent: Thursday, March 24, 2016 11:31:11 AM
> Subject: Re: SyntaxError - Block Join Parent Query
>
> I suggest to add debugQuery=true and fl=*,[child ...] doc transformer. And
> come back with response.
>
> On Thu, Mar 24, 2016 at 3:23 PM, Charles Sanders <csanders@redhat.com>
> wrote:
>
> > Ah yes. Thank you. Made the correction and I do not get the SyntaxError.
> > However, it does not apply the child filter. The query should return only
> > TestParent4. But it is returning TestParent2, TestParent3 and
> TestParent4.
> > All of these meet the parent portion of the query (+blue). But only
> > TestParent4 should meet the child portion of the query.
> >
> > q=+blue +{!parent
> > which="documentKind:TestParent"v=$childq}&childq=portal_product:("red
> hat")
> >
> >
> > {
> > "responseHeader":{
> > "status":0,
> > "QTime":15,
> > "params":{
> > "indent":"true",
> > "q":" blue {!parent which=\"documentKind:TestParent\"v=$childq}",
> > "childq":"portal_product:(\"red hat\")",
> > "wt":"json"}},
> > "response":{"numFound":2733,"start":0,"maxScore":3.0138793,"docs":[
> > {
> > "documentKind":"TestParent",
> > "uri":"https://ping/pong/testparent4",
> > "view_uri":"https://ping/pong/testparent4",
> > "id":"TestParent4",
> > "allTitle":"blue",
> > "sortTitle":"blue",
> > "_version_":1529622873461751808,
> > "_root_":["https://ping/pong/testparent4"],
> > "timestamp":"2016-03-23T19:40:48.211Z",
> > "language":"en"},
> > {
> > "documentKind":"TestParent",
> > "uri":"https://ping/pong/testparent3",
> > "view_uri":"https://ping/pong/testparent3",
> > "id":"TestParent3",
> > "allTitle":"blue",
> > "sortTitle":"blue",
> > "_version_":1529622308758487040,
> > "_root_":["https://ping/pong/testparent3"],
> > "timestamp":"2016-03-23T19:31:49.668Z",
> > "language":"en"},
> > {
> > "documentKind":"TestParent",
> > "uri":"https://ping/pong/testparent2",
> > "view_uri":"https://ping/pong/testparent2",
> > "id":"TestParent2",
> > "allTitle":"blue",
> > "sortTitle":"blue",
> > "_version_":1529622293809987584,
> > "_root_":["https://ping/pong/testparent2"],
> > "timestamp":"2016-03-23T19:31:35.408Z",
> > "language":"en"}
> >
> > ----- Original Message -----
> >
> > From: "Mikhail Khludnev" <mkhludnev@griddynamics.com>
> > To: "solr-user" <solr-user@lucene.apache.org>
> > Sent: Wednesday, March 23, 2016 5:34:31 PM
> > Subject: Re: SyntaxError - Block Join Parent Query
> >
> > On Thu, Mar 24, 2016 at 12:16 AM, Charles Sanders <csanders@redhat.com>
> > wrote:
> >
> > > Thanks for the quick reply. But I'm not sure I understand. Did I do
> > > something wrong??
> > >
> > Absolutely
> > 'portal_product"red hat")'
> > You omit a colon and opening bracket after a field name, don't you?
> >
> >
> > >
> > >
> > >
> >
> /select?q=+blue%20+{!parent%20which=%22documentKind:TestParent%22%20v=$childq}&childq=portal_product%22red%20hat%22)
> > >
> > > <response>
> > > <lst name =" responseHeader " >
> > > <int name =" status " > 400 </int>
> > > <int name =" QTime " > 2 </int>
> > > <lst name =" params " >
> > > <str name =" q " >
> > > blue {!parent which="documentKind:TestParent" v=$childq}
> > > </str>
> > > <str name =" childq " > portal_product"red hat") </str>
> > > </lst>
> > > </lst>
> > > <lst name =" error " >
> > > <str name =" msg " >
> > > org.apache.solr.search.SyntaxError: Cannot parse 'portal_product"red
> > > hat")': Encountered " ")" ") "" at line 1, column 23. Was expecting one
> > of:
> > > <EOF> <AND> ... <OR> ... <NOT> ... "+" ... "-" ... <BAREOPER> ... "("
> ...
> > > "*" ... "^" ... <QUOTED> ... <TERM> ... <FUZZY_SLOP> ... <PREFIXTERM>
> ...
> > > <WILDTERM> ... <REGEXPTERM> ... "[" ... "{" ... <LPARAMS> ... <NUMBER>
> > ...
> > > </str>
> > > <int name =" code " > 400 </int>
> > > </lst>
> > > </response>
> > >
> > > ----- Original Message -----
> > >
> > > From: "Mikhail Khludnev" <mkhludnev@griddynamics.com>
> > > To: "solr-user" <solr-user@lucene.apache.org>
> > > Sent: Wednesday, March 23, 2016 5:02:29 PM
> > > Subject: Re: SyntaxError - Block Join Parent Query
> > >
> > > On Wed, Mar 23, 2016 at 11:09 PM, Charles Sanders <csanders@redhat.com
> >
> > > wrote:
> > >
> > > > I'm getting a SyntaxError which I do not understand when I execute a
> > > block
> > > > join parent query. I'm running Solr5.2.1, with 2 shards. The problem
> > > > appears to be in that portion of the query that filters the child
> > > document.
> > > > Any insight as to where I made the error is greatly appreciated.
> > > >
> > > > This query produces an error:
> > > > q=+blue +{!parent
> which="documentKind:TestParent"}portal_product:("red
> > > > hat")
> > > > -- should return TestParent4
> > > >
> > > q=+blue +{!parent which="documentKind:TestParent"
> > > v=$childq}&childq=portal_product:("red hat")
> > >
> > >
> > > > However, this query works:
> > > > q=+blue +{!parent which="documentKind:TestParent"}portal_product:rhel
> > > > -- should return TestParent2
> > > >
> > > > Sample data and schema information below:
> > > > {
> > > > "documentKind": "TestParent",
> > > > "uri": "https://ping/pong/testparent1",
> > > > "view_uri": "https://ping/pong/testparent1",
> > > > "id": "TestParent1",
> > > > "allTitle": "gold",
> > > > "allText": "gold",
> > > > "contents": "gold",
> > > > "_childDocuments_": [
> > > > {
> > > > "documentKind": "TestChild",
> > > > "uri": "testchild1",
> > > > "id": "testchild1",
> > > > "portal_product_version": "6",
> > > > "portal_product": "rhel"
> > > > }
> > > > ]
> > > > }
> > > >
> > > > {
> > > > "documentKind": "TestParent",
> > > > "uri": "https://ping/pong/testparent2",
> > > > "view_uri": "https://ping/pong/testparent2",
> > > > "id": "TestParent2",
> > > > "allTitle": "blue",
> > > > "allText": "blue",
> > > > "contents": "blue",
> > > > "_childDocuments_": [
> > > > {
> > > > "documentKind": "TestChild",
> > > > "uri": "testchild2",
> > > > "id": "testchild2",
> > > > "portal_product_version": "6",
> > > > "portal_product": "rhel"
> > > > }
> > > > ]
> > > > }
> > > >
> > > > {
> > > > "documentKind": "TestParent",
> > > > "uri": "https://ping/pong/testparent3",
> > > > "view_uri": "https://ping/pong/testparent3",
> > > > "id": "TestParent3",
> > > > "allTitle": "blue",
> > > > "allText": "blue",
> > > > "contents": "blue",
> > > > "_childDocuments_": [
> > > > {
> > > > "documentKind": "TestChild",
> > > > "uri": "testchild3",
> > > > "id": "testchild3",
> > > > "portal_product_version": "3",
> > > > "portal_product": "rhev"
> > > > }
> > > > ]
> > > > }
> > > >
> > > > {
> > > > "documentKind": "TestParent",
> > > > "uri": "https://ping/pong/testparent4",
> > > > "view_uri": "https://ping/pong/testparent4",
> > > > "id": "TestParent4",
> > > > "allTitle": "blue",
> > > > "allText": "blue",
> > > > "contents": "blue",
> > > > "_childDocuments_": [
> > > > {
> > > > "documentKind": "TestChild",
> > > > "uri": "testchild4",
> > > > "id": "testchild4",
> > > > "portal_product_version": "3",
> > > > "portal_product": "red hat"
> > > > }
> > > > ]
> > > > }
> > > >
> > > > <field name="documentKind" type="string" indexed="true" stored="true"
> > > > required="true" />
> > > > <field name="uri" type="string" indexed="true" stored="true"
> > > > required="true"/>
> > > > <field name="view_uri" type="string" indexed="true" stored="true" />
> > > > <field name="id" type="string" indexed="true" stored="true" />
> > > > <field name="allTitle" type="text_std" indexed="true" stored="true"
> />
> > > > <field name="allText" type="text_std" indexed="true" stored="false"
> > > > multiValued="true" termVectors="true" />
> > > > <field name="contents" type="text_std" indexed="true" stored="false"
> > > > multiValued="true" termVectors="true" />
> > > > <field name="portal_product_version" type="string" indexed="true"
> > > > stored="true"/>
> > > > <field name="portal_product" type="string" indexed="true"
> > stored="true"/>
> > > >
> > >
> > >
> > >
> > > --
> > > Sincerely yours
> > > Mikhail Khludnev
> > > Principal Engineer,
> > > Grid Dynamics
> > >
> > > <http://www.griddynamics.com>
> > > <mkhludnev@griddynamics.com>
> > >
> > >
> >
> >
> > --
> > Sincerely yours
> > Mikhail Khludnev
> > Principal Engineer,
> > Grid Dynamics
> >
> > <http://www.griddynamics.com>
> > <mkhludnev@griddynamics.com>
> >
> >
>
>
> --
> Sincerely yours
> Mikhail Khludnev
> Principal Engineer,
> Grid Dynamics
>
> <http://www.griddynamics.com>
> <mkhludnev@griddynamics.com>
>
>


-- 
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics

<http://www.griddynamics.com>
<mkhludnev@griddynamics.com>

--001a114022c658d887052ed0ec2e--