lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Erickson <erickerick...@gmail.com>
Subject Re: How to use joins in solr 4.3.1
Date Tue, 16 Jul 2013 12:24:47 GMT
Not quite sure what's the problem with the second, but the
first is:
q=:

That just isn't legal, try q=*:*

As for the second, are there any other errors in the solr log?
Sometimes what's returned in the response packet does not
include the true source of the problem.

Best
Erick

On Mon, Jul 15, 2013 at 7:40 PM, Utkarsh Sengar <utkarsh2012@gmail.com> wrote:
> I have also tried these queries (as per this SO answer:
> http://stackoverflow.com/questions/12665797/is-solr-4-0-capable-of-using-join-for-multiple-core
> )
>
> 1. http://_server_.com:8983/solr/location/select?q=:&fq={!join
> from=merchantId to=merchantId fromIndex=merchant}walgreens
>
> And I get this:
>
> {
>   "responseHeader":{
>     "status":400,
>     "QTime":1,
>     "params":{
>       "indent":"true",
>       "q":":",
>       "wt":"json",
>       "fq":"{!join from=merchantId to=merchantId
> fromIndex=merchant}walgreens"}},
>   "error":{
>     "msg":"org.apache.solr.search.SyntaxError: Cannot parse ':':
> Encountered \" \":\" \": \"\" at line 1, column 0.\nWas expecting one
> of:\n    <NOT> ...\n    \"+\" ...\n    \"-\" ...\n    <BAREOPER> ...\n
>    \"(\" ...\n    \"*\" ...\n    <QUOTED> ...\n    <TERM> ...\n
> <PREFIXTERM> ...\n    <WILDTERM> ...\n    <REGEXPTERM> ...\n    \"[\"
> ...\n    \"{\" ...\n    <LPARAMS> ...\n    <NUMBER> ...\n    <TERM>
> ...\n    \"*\" ...\n    ",
>     "code":400}}
>
> And this:
> 2.http://_server_.com:8983/solr/location/select?q=walgreens&fq={!join
> from=merchantId to=merchantId fromIndex=merchant}
>
> {
>   "responseHeader":{
>     "status":500,
>     "QTime":5,
>     "params":{
>       "indent":"true",
>       "q":"walgreens",
>       "wt":"json",
>       "fq":"{!join from=merchantId to=merchantId fromIndex=merchant}"}},
>   "error":{
>     "msg":"Server at http://_SERVER_:8983/solr/location returned non
> ok status:500, message:Server Error",
>     "trace":"org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException:
> Server at http://_SERVER_:8983/solr/location returned non ok
> status:500, message:Server Error\n\tat
> org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:372)\n\tat
> org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:180)\n\tat
> org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:156)\n\tat
> org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:119)\n\tat
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)\n\tat
> java.util.concurrent.FutureTask.run(FutureTask.java:138)\n\tat
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)\n\tat
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)\n\tat
> java.util.concurrent.FutureTask.run(FutureTask.java:138)\n\tat
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)\n\tat
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)\n\tat
> java.lang.Thread.run(Thread.java:662)\n",
>     "code":500}}
>
> Thanks,
> -Utkarsh
>
>
>
> On Mon, Jul 15, 2013 at 4:27 PM, Utkarsh Sengar <utkarsh2012@gmail.com>wrote:
>
>> Hello,
>>
>> I am trying to join data between two cores: merchant and location
>>
>> This is my query:
>> http://_server_.com:8983/solr/location/select?q={!join from=merchantId
>> to=merchantId fromIndex=merchant}walgreens
>> Ref: http://wiki.apache.org/solr/Join
>>
>>
>> Merchants core has documents for the query: "walgreens" with an merchantId
>> 1
>>  A simple query: http://_server_.com:8983/solr/location/select?q=walgreens
>> returns documents called walgreens with merchantId=1
>>
>> Location core has documents with merchantId=1 too.
>>
>> But my join query returns no documents.
>>
>> This is the response I get:
>> {
>>   "responseHeader":{
>>     "status":0,
>>     "QTime":5,
>>     "params":{
>>       "debugQuery":"true",
>>       "indent":"true",
>>       "q":"{!join from=merchantId to=merchantId
>> fromIndex=merchant}walgreens",
>>       "wt":"json"}},
>>   "response":{"numFound":0,"start":0,"maxScore":0.0,"docs":[]
>>   },
>>   "debug":{
>>     "rawquerystring":"{!join from=merchantId to=merchantId
>> fromIndex=merchant}walgreens",
>>     "querystring":"{!join from=merchantId to=merchantId
>> fromIndex=merchant}walgreens",
>>     "parsedquery":"JoinQuery({!join from=merchantId to=merchantId
>> fromIndex=merchant}allText:walgreens)",
>>     "parsedquery_toString":"{!join from=merchantId to=merchantId
>> fromIndex=merchant}allText:walgreens",
>>     "QParser":"",
>>     "explain":{}}}
>>
>>
>> Any suggestions?
>>
>>
>> --
>> Thanks,
>> -Utkarsh
>>
>
>
>
> --
> Thanks,
> -Utkarsh

Mime
View raw message