Configuring Solr to connect to a SQL server instance
I currently have the following: I am running the example-DIH instance of solr, and it works fine. I then change the data-db-confix.xml file to make the dataSource the following: As far as I can tell from the SQL profiler, it is never able to log in, or even attempt to connect. I did get the jdbc .jar file and sqljdbc_auth.dll file, and loaded them into example-DIH\solr\db\lib The error I am getting from the attempted import is as follows: Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select * from temp_ip_solr_test Processing Document # 1 What could I be doing wrong? Solr version 4.3 ** This e-mail message and any attachments are confidential. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please notify Ipreo immediately by replying to this e-mail, and destroy all copies of this e-mail and any attachments. Thank you! **
Different scores for exact and non-exact matching
What I am looking to do is take field that contains a string like (called name for example): "This is a sample string" and then query by that field so that a search for "This" gets x points (exact match), "sam" gets y points (partial match). I attempted to do this via the sort and query parameters, like so: sort=if(name==This,100,50) but this gives me an error: sort param could not be parsed as a query, and is not a field that exists in the index: if(name==This,100,50) Full URL: http://localhost:8983/solr/db/select?q=name%3A*&sort=if(name%3D%3D%22This%22%2C100%2C50)+asc&fl=price%2Cname&wt=xml&indent=true Is there a way to do this? Note: I believe that I can at least get the documents that need to be sorted via (name:This AND name:This*) but then I do not know where to go from there (as I can't seem to get sort working for any functions). Can anyone provide some examples for how to do this kind of thing? Thank you. ** This e-mail message and any attachments are confidential. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please notify Ipreo immediately by replying to this e-mail, and destroy all copies of this e-mail and any attachments. Thank you! **
Running solr cloud
I cannot seem to be able to get the default cloud setup to work properly. What I did: Downloaded the binaries, extracted. Made the pwd example Ran: java -Dbootstrap_confdir=./solr/collection1/conf -Dcollection.configName=myconf -DzkRun -DnumShards=2 -jar start.jar And got the error message: Caused by: org.apache.solr.common.cloud.ZooKeeperException: Specified config does not exist in ZooKeeper:collection1 Which caused follow up messages, etc. What am I doing wrong here? Windows 7 pro ** This e-mail message and any attachments are confidential. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please notify Ipreo immediately by replying to this e-mail, and destroy all copies of this e-mail and any attachments. Thank you! **
