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 <utkarsh2...@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 <utkarsh2...@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
