Re: Solritas Question
What is mean to say is that, before the query goes to Solr, certain parameters need to be added, as for example number of documents displayed, boosting parameters etc. The algorithm of appending these parameters to the solr search query will be done by the interface. The modified query will go to Solr and it Solr will search its database according. Thanks and regards, Romita From: Erik Hatcher To: "solr-user@lucene.apache.org" , Cc: "solr-user@lucene.apache.org" Date: 03/07/2013 10:20 AM Subject:Re: Solritas Question Please elaborate. What do you mean by interface? What do you want different than it is now? Erik On Mar 6, 2013, at 21:04, "Romita Saha" wrote: > Hi, > > I am working with Solritas. However I want it to fetch data from Solr > through an interface. > > Solritas --> Interface -->Solr > Solr --> Interface -->Solritas > > Could somebody please guide me as to what changes to do in Solr config > files to achieve this. > > > Thanks and regards, > Romita
Solritas Question
Hi, I am working with Solritas. However I want it to fetch data from Solr through an interface. Solritas --> Interface -->Solr Solr --> Interface -->Solritas Could somebody please guide me as to what changes to do in Solr config files to achieve this. Thanks and regards, Romita
Re: Get tokenized words in Solr Response
Hi Mikhail, Thanks for your guidance. I found the required information in debugQuery=on. Thanks and regards, Romita From: Mikhail Khludnev To: solr-user , Date: 01/24/2013 03:19 PM Subject:Re: Get tokenized words in Solr Response Romita, IIRC you've already asked this, and I replied that everything what you need is on debugQuery=on output. That format is a little bit verbose, and I suppose you can experience some difficulties on finding the necessary info there. Please provide debugQuery=on output, I can try to highlight the necessary info for you. On Thu, Jan 24, 2013 at 6:11 AM, Romita Saha wrote: > Hi, > > I want the tokenized keywords to be displayed in solr response. As for > example, my solr search could be "Seach this document named XYZ-123". And > the tokenizer in schema.xml tokenizes the query as follows: > "search documnent xyz 123". I want to get these tokenized words in the > Solr response. Is it possible? > > Thanks and regards, > Romita -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com>
Get tokenized words in Solr Response
Hi, I want the tokenized keywords to be displayed in solr response. As for example, my solr search could be "Seach this document named XYZ-123". And the tokenizer in schema.xml tokenizes the query as follows: "search documnent xyz 123". I want to get these tokenized words in the Solr response. Is it possible? Thanks and regards, Romita
Re: Tokenized keywords
Hello Jack, Thanks a lot for the answer. I want something like what you have specifies, I want the tokenized words to be added to the response. Could you give me some details about custom search component? Thanks and regards, Romita From: "Jack Krupansky" To: , Date: 01/21/2013 11:32 PM Subject:Re: Tokenized keywords If debugQuery doesn't give you what you want, you can write a custom search component which runs after the QueryComponent and extracts the info you want from the generated query and then simply adds it to the response in any form that you want. -- Jack Krupansky -Original Message- From: Romita Saha Sent: Monday, January 21, 2013 1:49 AM To: solr-user@lucene.apache.org Subject: Re: Tokenized keywords What I am trying to achieve is as follows. I query "Search for all the Laptops" and my tokenized key words are "search laptop" (I apply stopword filter to filter out words like for,all,the and i also user lowercase filter). I want to display these tokenized keywords using debugQuery. Thanks and regards, Romita From: Dikchant Sahi To: solr-user@lucene.apache.org, Date: 01/21/2013 02:26 PM Subject:Re: Tokenized keywords Can you please elaborate a more on what you are trying to achieve. Tokenizers work on indexed field and doesn't effect how the values will be displayed. The response value comes from stored field. If you want to see how your query is being tokenized, you can do it using analysis interface or enable debugQuery to see how your query is being formed. On Mon, Jan 21, 2013 at 11:06 AM, Romita Saha wrote > Hi, > > I use some tokenizers to tokenize the query. I want to see the tokenized > query words displayed in the .Could you kindly help me do that. > > Thanks and regards, > Romita
Re: Tokenized keywords
Hi, I have a field defined in scheme.xml named as 'original'. I first copy this field to "modified" and apply filters on this field "modified." field name="original" type="string" indexed="true" stored="true"/> field name="modified" type="text_general" indexed="true" stored="true"/> I want to display in my as follows: original: Search for all the Laptops modified: search laptop Thanks and regards, Romita Saha Panasonic R&D Center Singapore Blk 1022 Tai Seng Avenue #06-3530 Tai Seng Ind. Est. Singapore 534415 DID: (65) 6550 5383 FAX: (65) 6550 5459 email: romita.s...@sg.panasonic.com From: Mikhail Khludnev To: solr-user@lucene.apache.org, Date: 01/21/2013 03:48 PM Subject:Re: Tokenized keywords Romita, That's what exactly is shown debugQuery output. If you cant find it there, paste output here, let's try to find together. Also pay attention to explainOther debug parameter and analisys page in admin ui. 21.01.2013 10:50 пользователь "Romita Saha" написал: > What I am trying to achieve is as follows. > > I query "Search for all the Laptops" and my tokenized key words are > "search laptop" (I apply stopword filter to filter out words like > for,all,the and i also user lowercase filter). > I want to display these tokenized keywords using debugQuery. > > Thanks and regards, > Romita > > > > From: Dikchant Sahi > To: solr-user@lucene.apache.org, > Date: 01/21/2013 02:26 PM > Subject:Re: Tokenized keywords > > > > Can you please elaborate a more on what you are trying to achieve. > > Tokenizers work on indexed field and doesn't effect how the values will be > displayed. The response value comes from stored field. If you want to see > how your query is being tokenized, you can do it using analysis interface > or enable debugQuery to see how your query is being formed. > > > On Mon, Jan 21, 2013 at 11:06 AM, Romita Saha > wrote > > > Hi, > > > > I use some tokenizers to tokenize the query. I want to see the tokenized > > query words displayed in the .Could you kindly help me do > that. > > > > Thanks and regards, > > Romita > >
Re: Tokenized keywords
What I am trying to achieve is as follows. I query "Search for all the Laptops" and my tokenized key words are "search laptop" (I apply stopword filter to filter out words like for,all,the and i also user lowercase filter). I want to display these tokenized keywords using debugQuery. Thanks and regards, Romita From: Dikchant Sahi To: solr-user@lucene.apache.org, Date: 01/21/2013 02:26 PM Subject:Re: Tokenized keywords Can you please elaborate a more on what you are trying to achieve. Tokenizers work on indexed field and doesn't effect how the values will be displayed. The response value comes from stored field. If you want to see how your query is being tokenized, you can do it using analysis interface or enable debugQuery to see how your query is being formed. On Mon, Jan 21, 2013 at 11:06 AM, Romita Saha wrote > Hi, > > I use some tokenizers to tokenize the query. I want to see the tokenized > query words displayed in the .Could you kindly help me do that. > > Thanks and regards, > Romita
Is there any C API for Solr??
Hi All, Is there any C API for Solr?? Thanks and regards, Romita
Re: Solr PHP client
Hi, I open the Solr browser using the following url: http://localhost:8983/solr/browser The PHP client code to ping server is ping() ) { echo 'Solr service not responding.'; exit; } Could you please let me know if the above portion of the code is correct? Or do I need to specify anything else in " $solr = new Apache_Solr_Service( 'localhost', '8983', '/solr' );" Thanks and regards, Romita From: "Romita Saha" To: solr-user@lucene.apache.org, Date: 12/17/2012 10:02 AM Subject:Re: Solr PHP client Hi, Yes I can access Solr via a browser. But cannot access it with Solr-PHP client. Thanks and regards, Romita From: Upayavira To: solr-user@lucene.apache.org, Date: 12/14/2012 09:49 PM Subject:Re: Solr PHP client Can you access your Solr server via a browser? I bet it is something simple like a URL being wrong. Upayavira On Fri, Dec 14, 2012, at 09:37 AM, Romita Saha wrote: > Hi I am using Solr-PHP client. I am not able to ping Solr. Is their any > change that I need to make in Solr config files so that it can listen to > the PHP client? > > I get the following error : > > ping() ) { echo 'Solr service not responding.'; exit; } > > Could someone please help. > > Thanks and regards, > Romita
Re: Solr PHP client
Hi, Yes I can access Solr via a browser. But cannot access it with Solr-PHP client. Thanks and regards, Romita From: Upayavira To: solr-user@lucene.apache.org, Date: 12/14/2012 09:49 PM Subject:Re: Solr PHP client Can you access your Solr server via a browser? I bet it is something simple like a URL being wrong. Upayavira On Fri, Dec 14, 2012, at 09:37 AM, Romita Saha wrote: > Hi I am using Solr-PHP client. I am not able to ping Solr. Is their any > change that I need to make in Solr config files so that it can listen to > the PHP client? > > I get the following error : > > ping() ) { echo 'Solr service not responding.'; exit; } > > Could someone please help. > > Thanks and regards, > Romita
Re: Solr PHP client
Hi I am using Solr-PHP client. I am not able to ping Solr. Is their any change that I need to make in Solr config files so that it can listen to the PHP client? I get the following error : ping() ) { echo 'Solr service not responding.'; exit; } Could someone please help. Thanks and regards, Romita
Solr PHP client
Hi, Can anyone please guide me to use SolrPhpClient? The documents available are not clear. As to where to place SolrPhpClient? I have downloaded SolrPhpClient and have changed the following lines, specifying the path (where the files are present in my computer) require_once('/home/solr/SolrPhpClient/Apache/Solr/Document.php./Document.php'); require_once('/home/solr/SolrPhpClient/Apache/Solr/Document.php./Response.php'); After this I am unable to proceed. What and how should I index my documents now. How should I start my solr. Where to place the conf files. I see there are few html documents inside the folder "SolrPhpClien/phpdocs". Could someone please help. Thanks and regards, Romita
Re: does Solr support CGI?
I want to integrate Solr with a distributed server. I want to built an interface in order to do this. This interface would basically pass the data back and forth from solr to the server and vice versa. On receiving a request from the server, this interface would add certain information to the request and forward it to solr. Thanks and regards, Romita From: Otis Gospodnetic To: solr-user@lucene.apache.org, Date: 12/13/2012 10:59 AM Subject:Re: does Solr support CGI? Yes the information passing via url params is the same , but CGIs don't run in servlet containers. Maybe you can share what you are really after. Otis -- SOLR Performance Monitoring - http://sematext.com/spm On Dec 12, 2012 9:53 PM, "Romita Saha" wrote: > I am a little confused about what exactly a CGI is. According to my > understanding, Common gateway interface tells the webserver how to pass > data back and forth to and from an application. user (client) requests for > a page>webserver (CGI)> server side program (may be Solr). Could > you please tell me in details what exactly a CGI and why Solr cannot > support it? > > Thanks and regards, > Romita > > > > From: Otis Gospodnetic > To: solr-user@lucene.apache.org, > Date: 12/13/2012 10:40 AM > Subject:Re: does Solr support CGI? > > > > CGI as in Computer Gateway Interface? No. > > Otis > -- > SOLR Performance Monitoring - http://sematext.com/spm > On Dec 12, 2012 9:20 PM, "Romita Saha" > wrote: > > > Hi all, > > > > Could anyone tell me if Solr support CGI > > > > Thanks and regards, > > Romita > >
Re: does Solr support CGI?
I am a little confused about what exactly a CGI is. According to my understanding, Common gateway interface tells the webserver how to pass data back and forth to and from an application. user (client) requests for a page>webserver (CGI)> server side program (may be Solr). Could you please tell me in details what exactly a CGI and why Solr cannot support it? Thanks and regards, Romita From: Otis Gospodnetic To: solr-user@lucene.apache.org, Date: 12/13/2012 10:40 AM Subject:Re: does Solr support CGI? CGI as in Computer Gateway Interface? No. Otis -- SOLR Performance Monitoring - http://sematext.com/spm On Dec 12, 2012 9:20 PM, "Romita Saha" wrote: > Hi all, > > Could anyone tell me if Solr support CGI > > Thanks and regards, > Romita
Re: does Solr support CGI?
Yes thats right. CGI as in Computer Gateway Interface. I understand that you say Solr cannot support CGI. Am I correct? Could you kindly explain in more details. Thanks and regards, Romita From: Otis Gospodnetic To: solr-user@lucene.apache.org, Date: 12/13/2012 10:40 AM Subject:Re: does Solr support CGI? CGI as in Computer Gateway Interface? No. Otis -- SOLR Performance Monitoring - http://sematext.com/spm On Dec 12, 2012 9:20 PM, "Romita Saha" wrote: > Hi all, > > Could anyone tell me if Solr support CGI > > Thanks and regards, > Romita
does Solr support CGI?
Hi all, Could anyone tell me if Solr support CGI Thanks and regards, Romita
Re: Change searching field using Solritas
Hi, I have found out the solution to my own question. I need to change the qf parameter in solrconfig file. Thanks and regards, Romita From: "Romita Saha" To: solr-user@lucene.apache.org, Date: 12/05/2012 06:20 PM Subject:Change searching field using Solritas Hi, I am trying to change the Solr browser UI using Solritas. What I understand is that if I want to search something and type in the FIND box and click 'Submit Query', Solr always searches in the field 'name' and give the result accordingly. However I want to search in some other field. I am not able to find out where in Velocity conf files I need to modify to search in a field other than the field 'name'. Could you please help me find it out. Thanks and regards, Romita
How to change Solr UI
Hi, I want to change the Solr UI. As far as i understand, Solritas is just for prototyping, where I can change the UI according to a predefined template (Velocity) and cannot add on any additional functionality to that page. How can I change the Solr UI otherwise. Any guidance would be appreciated. Thanks and regards, Romita
Re: user session id / cookie to record search query
Hi, Thanks a lot. Will follow the same. Thanks and regards, Romita From: Rafał Kuć To: solr-user@lucene.apache.org, Date: 11/21/2012 05:34 PM Subject:Re: user session id / cookie to record search query Hello! What Solr are you using ? If not 4.0, information on logging can be found on wiki - http://wiki.apache.org/solr/SolrLogging -- Regards, Rafał Kuć Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch - ElasticSearch > Hello Rafał Kuć > Thanks a lot for you guidance. I am not quite sure how to i collect the > logs. Could you please help. > Romita > From: Rafał Kuć > To: solr-user@lucene.apache.org, > Date: 11/21/2012 04:57 PM > Subject:Re: user session id / cookie to record search query > Hello! > You want it to be written into logs ? If that is the case you can just > add additional parameter, that is not recognized by Solr, for example > 'userId' and send a query like this: > http://localhost:8983/solr/select?q=*:*&userId=user1 > In the logs you should see something like that: > INFO: [collection1] webapp=/solr path=/select > params={q=*:*&userId=user1} hits=0 status=0 QTime=1
Re: user session id / cookie to record search query
Hello Rafał Kuć Thanks a lot for you guidance. I am not quite sure how to i collect the logs. Could you please help. Romita From: Rafał Kuć To: solr-user@lucene.apache.org, Date: 11/21/2012 04:57 PM Subject:Re: user session id / cookie to record search query Hello! You want it to be written into logs ? If that is the case you can just add additional parameter, that is not recognized by Solr, for example 'userId' and send a query like this: http://localhost:8983/solr/select?q=*:*&userId=user1 In the logs you should see something like that: INFO: [collection1] webapp=/solr path=/select params={q=*:*&userId=user1} hits=0 status=0 QTime=1 -- Regards, Rafał Kuć Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch - ElasticSearch > Hi All, > Do anyone have an idea how to use user session id / cookie to record > search query from that particular user. > Thanks and regards, > Romita
Re: is it possible to save the search query?
Hi Mark, Thanks a lot for your reply. I do not have much knowledge regarding xslt. Could you kindly specify how do i use xslt to extract relevant information. Also how can i drive solr response to a file. Any guidance regarding this would help. Thanks and regards, Romita From: geeky2 To: solr-user@lucene.apache.org, Date: 11/20/2012 10:55 PM Subject:Re: is it possible to save the search query? Hello, i think you are asking two questions here - i'll see if i can give you some simple examples for both 1) how can i pull data from a solr search result set and compare it to another for analysis? one way - might be to drive the results in to files and then use xslt to extract relevant information. here is an example xslt file that pulls specific fields from a result: http://www.w3.org/1999/XSL/Transform";> [ ] , , , 2) how can i embed data in to a solr query, making it easier to do analysis in the log files? here is a simple example that "bookmarks" or brackets transactions in the logs - used only during stress testing #!/bin/bash TYPE=$1 TAG=$2 if [ $TYPE == 1 ] then # beginning curl -v http://something:1234/boo/core1/select/?q=partImageURL%3A$ {TAG}-test-begin&version=2.2&start=0&rows=777indent=on else # end curl -v http://something:1234/boo/core1/select/?q=partImageURL%3A$ {TAG}-test-end&version=2.2&start=0&rows=777indent=on fi hopefully this will give you something to start with. thx mark -- View this message in context: http://lucene.472066.n3.nabble.com/is-it-possible-to-save-the-search-query-tp4018925p4021315.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: is it possible to save the search query?
Hi Amit, Could you please explain more on how to use a user cookie to construct a session. Thanks and regards, Romita From: Amit Nithian To: "solr-user@lucene.apache.org" , Date: 11/08/2012 06:21 PM Subject:Re: is it possible to save the search query? Are you trying to do this in real time or offlline? Wouldn't mining your access logs help? It may help to have your front end application pass in some extra parameters that are not interpreted by Solr but are there for "stamping" purposes for log analysis. One example could be a user id or user cookie or something in case you have to construct sessions. On Wed, Nov 7, 2012 at 10:01 PM, Romita Saha wrote: > Hi, > > The following is the example; > 1st query: > > > http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data > ^2 > id&start=0&rows=11&fl=data,id > > Next query: > > > http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data > id^2&start=0&rows=11&fl=data,id > > In the 1st query the the field 'data' is boosted by 2. However may be the > user was not satisfied with the response. Thus in the next query he > boosted the field 'id' by 2. > > I want to record both the queries and compare between the two, meaning, > what are the changes implemented on the 2nd query which are not present in > the previous one. > > Thanks and regards, > Romita Saha > > > > From: Otis Gospodnetic > To: solr-user@lucene.apache.org, > Date: 11/08/2012 01:35 PM > Subject: Re: is it possible to save the search query? > > > > Hi, > > Compare in what sense? An example will help. > > Otis > -- > Performance Monitoring - http://sematext.com/spm > On Nov 7, 2012 8:45 PM, "Romita Saha" > wrote: > > > Hi All, > > > > Is it possible to record a search query in solr and then compare it with > > the previous search query? > > > > Thanks and regards, > > Romita Saha > > > >
Re: is it possible to save the search query?
Hi, Thanks for your guidance. I am unable to figure out what is a doc ID and how can i collect all the doc IDs. Thanks and regards, Romita Saha From: Otis Gospodnetic To: solr-user@lucene.apache.org, Date: 11/09/2012 12:33 AM Subject:Re: is it possible to save the search query? Hi, Aha, I think I understand. Yes, you could collect all doc IDs from each query and find the differences. There is nothing in Solr that can find those differences or that would store doc IDs of returned hits in the first place, so you would have to implement this yourself. Sematext's Search Analytics service my be of help here in the sense that all data you need (queries, doc IDs, etc.) are collected, so it would be a matter of providing an API to get the data for off-line analysis. But this data collection+diffing is also something you could implement yourself. One thing to think about - what do you do when a query returns a lrge number of hits. Do you really want/need to get IDs for all of them, or only a page at a time. Otis -- Search Analytics - http://sematext.com/search-analytics/index.html Performance Monitoring - http://sematext.com/spm/index.html On Thu, Nov 8, 2012 at 1:01 AM, Romita Saha wrote: > Hi, > > The following is the example; > 1st query: > > > http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data > ^2 > id&start=0&rows=11&fl=data,id > > Next query: > > > http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data > id^2&start=0&rows=11&fl=data,id > > In the 1st query the the field 'data' is boosted by 2. However may be the > user was not satisfied with the response. Thus in the next query he > boosted the field 'id' by 2. > > I want to record both the queries and compare between the two, meaning, > what are the changes implemented on the 2nd query which are not present in > the previous one. > > Thanks and regards, > Romita Saha > > > > From: Otis Gospodnetic > To: solr-user@lucene.apache.org, > Date: 11/08/2012 01:35 PM > Subject:Re: is it possible to save the search query? > > > > Hi, > > Compare in what sense? An example will help. > > Otis > -- > Performance Monitoring - http://sematext.com/spm > On Nov 7, 2012 8:45 PM, "Romita Saha" > wrote: > > > Hi All, > > > > Is it possible to record a search query in solr and then compare it with > > the previous search query? > > > > Thanks and regards, > > Romita Saha > > > >
Re: is it possible to save the search query?
Hi, The following is the example; 1st query: http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data^2 id&start=0&rows=11&fl=data,id Next query: http://localhost:8983/solr/db/select/?defType=dismax&&debugQuery=on&q=cashier2&qf=data id^2&start=0&rows=11&fl=data,id In the 1st query the the field 'data' is boosted by 2. However may be the user was not satisfied with the response. Thus in the next query he boosted the field 'id' by 2. I want to record both the queries and compare between the two, meaning, what are the changes implemented on the 2nd query which are not present in the previous one. Thanks and regards, Romita Saha From: Otis Gospodnetic To: solr-user@lucene.apache.org, Date: 11/08/2012 01:35 PM Subject:Re: is it possible to save the search query? Hi, Compare in what sense? An example will help. Otis -- Performance Monitoring - http://sematext.com/spm On Nov 7, 2012 8:45 PM, "Romita Saha" wrote: > Hi All, > > Is it possible to record a search query in solr and then compare it with > the previous search query? > > Thanks and regards, > Romita Saha >
Re: solr search issue
Hi, I am new to solr. Could you kindly explain a bit about defining free text search. In my database I have two columns. One is id another is data. I want my query to spread across multiple fields. When i search for a parameter from id filed, it searches it in both the fields. However whenever I search a parameter from data field, it only searches in data. Below is my query. http://localhost:8983/solr/db/select/?defType=dismax&q=2&qf=data id^2&start=0&rows=11&fl=data,id In my table, id=2 for data=level2. id=4 for data=cashier2. When I search q=2&qf=data id, it searches for '2' in data field also and gives me both the results i.e data=level2 and data=cashier2. However, when i search for q=cashier2&qf=data id, it only gives me result as data=cashier2 and not data=level2 (please note that id=2 for data = level2. Ideally it should break the query into cashier+2 and search in id field as well) Thanks and regards, Romita Saha Panasonic R&D Center Singapore Blk 1022 Tai Seng Avenue #06-3530 Tai Seng Ind. Est. Singapore 534415 DID: (65) 6550 5383 FAX: (65) 6550 5459 email: romita.s...@sg.panasonic.com From: Erick Erickson To: solr-user@lucene.apache.org, Date: 11/02/2012 02:42 PM Subject:Re: solr search issue First, define a "free text search". If what you're after is that your terms (i.e. q=term1 term2) get spread across multiple fields, simply add them to your qf parameter (qf=field1,field2). If you want the terms bound to a particular field, it's just the usual q=field:term, in which case any field term does NOT get spread amongst all the fields in your qf parameter. Best Erick On Fri, Nov 2, 2012 at 1:56 AM, Romita Saha wrote: > Hi, > > Thank you for your reply. What if I want to do a free text search? > > Thanks and regards, > Romita > > > From: Gora Mohanty > To: solr-user@lucene.apache.org, > Date: 11/02/2012 12:36 PM > Subject:Re: solr search issue > > > > On 2 November 2012 09:51, Romita Saha > wrote: > > > > Hi, > > > > I am trying to search a database . In my database I have a field level2. > > > > My query: > > > > http://localhost:8983/solr/db/select/?defType=dismax&q=search%20level2&qf=data%20id > ^2%20&start=0&rows=11&fl=data,id > > > Where did you get this syntax from? If you want to search just on the > field level2, you should have: > http://localhost:8983/solr/db/select/?q=term&defType=dismax&qf=level2 > where "term" is your search term. (I have omitted boosts, and extra > parameters.) > > Regards, > Gora > >
Re: solr search issue
Hi, Thank you for your reply. What if I want to do a free text search? Thanks and regards, Romita From: Gora Mohanty To: solr-user@lucene.apache.org, Date: 11/02/2012 12:36 PM Subject:Re: solr search issue On 2 November 2012 09:51, Romita Saha wrote: > > Hi, > > I am trying to search a database . In my database I have a field level2. > > My query: > http://localhost:8983/solr/db/select/?defType=dismax&q=search%20level2&qf=data%20id^2%20&start=0&rows=11&fl=data,id Where did you get this syntax from? If you want to search just on the field level2, you should have: http://localhost:8983/solr/db/select/?q=term&defType=dismax&qf=level2 where "term" is your search term. (I have omitted boosts, and extra parameters.) Regards, Gora
solr search issue
Hi, I am trying to search a database . In my database I have a field level2. My query: http://localhost:8983/solr/db/select/?defType=dismax&q=search%20level2&qf=data%20id^2%20&start=0&rows=11&fl=data,id When I make the above query, I do not get any response. However I get the require the response when I do the following query: http://localhost:8983/solr/db/select/?defType=dismax&q=search%20level 2&qf=data%20id^2%20&start=0&rows=11&fl=data,id The only difference in the two queries are: previous query: search for level2 new query: search for level 2 (whitespace between level and 2) Note: My database has field name as level2 (no space between level and 2) Could anybody please explain? Thanks and regards, Romita
Re: Query regarding solr search
Did you change it in schema.xml ?? Thanks and regards, Romita From: Leena Jawale To: "'solr-user@lucene.apache.org'" <'solr-user@lucene.apache.org'>, Cc: "Sawant, Amit2 " Date: 10/31/2012 12:07 PM Subject:Query regarding solr search Hi, My XML file is 1001 IBM 1001 INFPW03772 22/4/2010 1000 1002 DELL 1002 INFPW03734 09/7/2010 5000 But still the SerialNo and price1 working according to type text. Thanks, Leena Jawale From: Leena Jawale Sent: Tuesday, October 30, 2012 4:58 PM To: 'solr-user@lucene.apache.org' Cc: 'Sawant, Amit2 ' Subject: RE: Query regarding solr search Hi, I understand that in the solr search considering the field type as text_en and not as int for the fields. So how do I convert the field type of a particular field in solr XML as int so that I can operate that field for range queries in solr?? Thanks, Leena Jawale From: Leena Jawale Sent: Tuesday, October 30, 2012 12:18 PM To: 'solr-user@lucene.apache.org' Cc: 'Sawant, Amit2 ' Subject: Query regarding solr search Hi, I have created Solr XML data source. And on that I am working on less than operator. I tried q=SerialNo:[ * TO 500 ].But It is showing records having SerialNo=1000. Could you help me this.? Thanks, Leena Jawale The contents of this e-mail and any attachment(s) may contain confidential or privileged information for the intended recipient(s). Unintended recipients are prohibited from taking action on the basis of information in this e-mail and using or disseminating the information, and must notify the sender and delete it from their system. L&T Infotech will not accept responsibility or liability for the accuracy or completeness of, or the presence of any virus or disabling code in this e-mail"
Re: searching a database element
Hi, It worked. I was specifying more than one filed under defaultSearchField. Once I specified just the required field, it is able to do the search. Thanks a lot for your guidance. Romita From: "Romita Saha" To: solr-user@lucene.apache.org, Date: 10/23/2012 12:31 PM Subject:Re: searching a database element Hi, Sorry for the typo in the previous mail. I am searching for dell actually. The query is http://.../solr/db/select?q=dell&start=0&rows=4&fl=laptop I am not applying any analyzer/tokenizer for the fieldType 'string'. I also want to share my solrconfig file with you. data-config.xml Thanks and regards, Romita Saha From: adityab To: solr-user@lucene.apache.org, Date: 10/23/2012 12:19 PM Subject:Re: searching a database element Are you applying any analyzer/tokenizer for the fieldType 'string' (i guess no) your query in the response shows '*dell*' where as you are store data is '*Dell*'. If you wan to search ignoring the case then you might need to use LowerCaseFilterFactory as analyzer to the field. and then perform the search. -- View this message in context: http://lucene.472066.n3.nabble.com/searching-a-database-element-tp4015293p4015298.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: searching a database element
Hi, Sorry for the typo in the previous mail. I am searching for dell actually. The query is http://.../solr/db/select?q=dell&start=0&rows=4&fl=laptop I am not applying any analyzer/tokenizer for the fieldType 'string'. I also want to share my solrconfig file with you. data-config.xml Thanks and regards, Romita Saha From: adityab To: solr-user@lucene.apache.org, Date: 10/23/2012 12:19 PM Subject:Re: searching a database element Are you applying any analyzer/tokenizer for the fieldType 'string' (i guess no) your query in the response shows '*dell*' where as you are store data is '*Dell*'. If you wan to search ignoring the case then you might need to use LowerCaseFilterFactory as analyzer to the field. and then perform the search. -- View this message in context: http://lucene.472066.n3.nabble.com/searching-a-database-element-tp4015293p4015298.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: searching a database element
Hi, I added laptop to the schema.xml file. However the query http://.../solr/db/select?q=Dell&start=0&rows=4&fl=laptop is not able to search for dell. Following is the response. 0 2 on 0dell 2.2 10 Thanks and regards, Romita Saha From: adityab To: solr-user@lucene.apache.org, Date: 10/23/2012 12:01 PM Subject:Re: searching a database element if i understand correctly you are looking for the below attribute in schema.xml to be defined. laptop you query can now be http://.../solr/db/select?q=Dell&start=0&rows=4&fl=laptop -- View this message in context: http://lucene.472066.n3.nabble.com/searching-a-database-element-tp4015293p4015296.html Sent from the Solr - User mailing list archive at Nabble.com.
searching a database element
Hi, I have indexed from a database. I have specified a field type laptop. In the database, laptop has the value equal to Dell. I can search laptop: Dell from the database with the following command. http://localhost:8983/solr/db/select/?q=laptop:Dell&start=0&rows=4&fl=laptop Can i search for just the query string dell without specifying that it is of field type laptop? Below is my data-config and schema.xml file: data-config.xml: schema.xml: laptop Romita Saha
Re: Solr reports: "Can not read response from server" when running import
Hi Shawn, Thanks a lot for your guidance. I can import the database successfully now. Thanks once again. Regards, Romita Saha From: Shawn Heisey To: solr-user@lucene.apache.org, Date: 10/17/2012 09:49 PM Subject:Re: Solr reports: "Can not read response from server" when running import On 10/17/2012 12:29 AM, Romita Saha wrote: > Hi Dave, > > I followed your guidance and loaded my database in MySQL. Presently the > url reads like this: > > url = "jdbc:mysql://localhost:8983/var/lib/mysql/camerasys" > > The bin address in my.cnf file is : > bind-address = 127.0.0.1 > > However the issue still persists. Kindly help me find out the issue. The > error log is stated below. > > Caused by: com.mysql.jdbc.CommunicationsException: Communications link > failure due to underlying exception: Typically MySQL listens on port 3306, and if you haven't changed it from the default, you shouldn't even need to include it. Your URL then needs to have the name of the database (schema), not the path to where MySQL is storing it.Port 8983 is Solr's port if you run under the included jetty container. It looks like you probably can use this, assuming you named the database camerasys: url="jdbc:mysql://localhost/camerasys" Here's how my dataimport source is defined. I pass the database host and schema in via the dataimport request URL, and I include the port number even though I don't have to: Thanks, Shawn
Re: Solr reports: "Can not read response from server" when running import
r.java:330) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:296) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:683) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:619) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:327) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:225) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:375) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:445) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:426) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:641) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1044) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) at com.mysql.jdbc.Connection.(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363) at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:240) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39) at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.pullRow(EntityProcessorWrapper.java:330) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:296) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:683) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:619) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:327) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:225) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:375) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:445) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:426) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847) at com.mysql.jdbc.Connection.(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363) at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:240) ... 13 more Oct 17, 2012 12:26:31 PM org.apache.solr.update.DirectUpdateHandler2 rollback INFO: start rollback Oct 17, 2012 12:26:31 PM org.apache.solr.update.DirectUpdateHandler2 rollback INFO: end_rollback Thanks and regards, Romita Saha From: Dave Meikle To: solr-user@lucene.apache.org, Date: 10/15/2012 07:03 PM Subject:Re: Solr reports: "Can not read response from server" when running import Hi Romita, On 15 Oct 2012, at 11:46, Romita Saha wrote: > Thank you for your prompt reply. The name of the database am using is > sampledatabase.sql and it is located in home/demo/snp-comm folder. Hence I > have specified the url as > > url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase.sql" /> I suspect this is your problem in that the MySQL JDBC driver is expecting to connect to a server where this database is hosted as opposed to the file you have specified. I assume from the name the sampledatabase.sql is just a SQL script, so I suggest you load that into a MySQL and then connect to the database on that server. Cheers, Dave
Re: Solr reports: "Can not read response from server" when running import
Hi Dave, Thank you for your prompt reply. The name of the database am using is sampledatabase.sql and it is located in home/demo/snp-comm folder. Hence I have specified the url as url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase.sql" /> Could you please specify which conf file i need to look into? Thanks and regards, Romita From: Dave Meikle To: solr-user@lucene.apache.org, Date: 10/15/2012 06:24 PM Subject:Re: Solr reports: "Can not read response from server" when running import Hi, On 15 Oct 2012, at 11:02, Romita Saha wrote: > My dataconfig.xml file looks like the following : > > - > url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase" /> > - > - > > > > The error information means that the connection wasn't accepted by the server. I would make sure that a) your connection URL is correct as it looks wrong to me - i.e. your database name in the URL looks like a path[1] - and b) your binding address is correct in your config file (my.cnf) and your associated host/DNS entries would let you resolve it. Cheers, Dave [1] http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
Solr reports: "Can not read response from server" when running import
Hi, I am trying to import a mysql database : sampledatabase. When I run the full import command http://localhost:8983/solr/db/dataimport?command=full-import in the browser, I get the following error in the terminal after about 1 minute. Oct 16, 2012 3:49:20 PM org.apache.solr.core.SolrCore execute INFO: [db] webapp=/solr path=/dataimport params={command=full-import} status=0 QTime=0 Oct 16, 2012 3:49:20 PM org.apache.solr.common.SolrException log SEVERE: Exception while processing: customer document : SolrInputDocument[{}]:org.apache.solr.handler.dataimport.DataImportHandlerException : Unable to execute query: select contactLastName from customers Processing Document # 1 . . . Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received and packets from server. at sun.reflect.NativeConstructorAccessImpl.newInstance0(Native Method) . . . Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:592) ... 31 more . . . My dataconfig.xml file looks like the following : - - - Relevant portion of schema.xml : Relevant portion of solarconfig.xml : - - data-config.xml Kindly let me know what can be the issue. Thanks and regards, Romita Saha Panasonic R&D Center Singapore Blk 1022 Tai Seng Avenue #06-3530 Tai Seng Ind. Est. Singapore 534415 DID: (65) 6550 5383 FAX: (65) 6550 5459 email: romita.s...@sg.panasonic.com