Quering the database
Hi, I am new to solr. I am indexing data from data using solr. Everything is working fine the documents are indexed and using *:* as a query keyword i am able to get all the results from the table. My problem is now if i want to query using a specific keyword such as monitors, it doesn't return any fields when searched for but the data does exist in the database. What am i missing here? Highly appreciate for any hints. Regards, Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Quering-the-database-tp1015636p1015636.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Quering the database
Thank you for your reply. Below is my data-config details. Below are the defined schema fields for the data-config field_1 text -- View this message in context: http://lucene.472066.n3.nabble.com/Quering-the-database-tp1015636p1015671.html Sent from the Solr - User mailing list archive at Nabble.com.
RE: Quering the database
Thank you for your reply. Still the the problem persists even i tested with a simple example by defining a column of type text as varchar in database and in schema.xml used the default id which is set to string. Row is fetched and document created but searching doesn't give any results of the content in the column. Best Regards, Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Quering-the-database-tp1015636p1015890.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Quering the database
Thanks alot to all now its clear the problem was in the schema. One more thing i would like to know is if the user queries for something does it have to always be like q=field:monitor where field is defined in schema and monitor is just a text in a column. Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Quering-the-database-tp1015636p1018268.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Quering the database
Thanks these links were useful. Managed to figured out what i needed. Cheers Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Quering-the-database-tp1015636p1018896.html Sent from the Solr - User mailing list archive at Nabble.com.
Parsing xml of the search results
The default style of search results is raw xml. If i want to make it more user friendly do i have to add stylesheet to the xml search response tags. Thanks. Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Parsing-xml-of-the-search-results-tp1019017p1019017.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Parsing xml of the search results
Thanks man this helped. Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Parsing-xml-of-the-search-results-tp1019017p1019064.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Parsing xml of the search results
User friendly i meant that the xml is raw and not user friendly for reading. So i wondered what is the best approach for showing the results in a more readable way. I got replied to this post but your comments were also valuable. Thanks. Cheers Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Parsing-xml-of-the-search-results-tp1019017p1019120.html Sent from the Solr - User mailing list archive at Nabble.com.
Setting up apache solr in eclipse with Tomcat
I would like to setup apache solr in eclipse using tomcat. It is easy to setup with jetty but with tomcat it doesn't run solr on runtime. Anyone has done this before? Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Setting-up-apache-solr-in-eclipse-with-Tomcat-tp1021673p1021673.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Setting up apache solr in eclipse with Tomcat
Thanks man i haven't tried this but where do put that xml configuration. Is it to the web.xml in solr? Cheers, Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Setting-up-apache-solr-in-eclipse-with-Tomcat-tp1021673p1023188.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Setting up apache solr in eclipse with Tomcat
Thanks now its clear and works fine. Regards, Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Setting-up-apache-solr-in-eclipse-with-Tomcat-tp1021673p1023404.html Sent from the Solr - User mailing list archive at Nabble.com.
Parsing solrj results
I have implement a solrj client for quering index data from database. the
search result is in text but with SolrDocument[{description= which is a
field in xml. How i can parse out this. Thanks.
Hando
--
View this message in context:
http://lucene.472066.n3.nabble.com/Parsing-solrj-results-tp1029166p1029166.html
Sent from the Solr - User mailing list archive at Nabble.com.
Solr Delta import where last_modified
Hi all. I have set my data-config with mysql database. The problem i am having is mysql doesn't execute deltaquery. The where last_modified is not executed and throws an error of unknown column last_modified in where clause. Shouldn't this be treated as a deltaquery instead of a column in table. Am i missing any configurations. Highly appreciate for any feedback about this. Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Delta-import-where-last-modified-tp1068743p1068743.html Sent from the Solr - User mailing list archive at Nabble.com.
Delta-import with solrj client
Greetings. I have a solrj client for fetching data from database. I am using delta-import for fetching data. If a column is changed in database using timestamp with delta-import i get the latest column indexed but there are duplicate values in the index similar to the column but the data is older. This works with cleaning the index but i want to update the index without cleaning it. Is there a way to just update the index with the updated column without having duplicate values. Appreciate for any feedback. Hando -- View this message in context: http://lucene.472066.n3.nabble.com/Delta-import-with-solrj-client-tp1085763p1085763.html Sent from the Solr - User mailing list archive at Nabble.com.
