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
