http://www.datastax.com/support-forums/topic/solr-search-on-csv-data Software, Support, and Training for Apache Cassandra en-US Sat, 18 May 2013 19:51:32 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-4770 Thu, 02 Aug 2012 13:33:08 +0000 datastaxtesting 4770@http://www.datastax.com/support-forums/ <p>I updated my configuration to:<br /> [root@NJVC-BAO-DEV-DB-2 wiki]# /usr/local/datastax-2.1/dse-2.1/bin/dsetool ring -h 10.3.11.91<br /> Address DC Rack Workload Status State Load Owns Token<br /> 85070591730234615865843651857942052864<br /> 10.3.11.90 DC1 RAC1 Analytics(JT) Up Normal 1.08 MB 50.00% 0<br /> 10.3.11.91 DC2 RAC1 Search Up Normal 9.66 MB 50.00% 85070591730234615865843651857942052864</p> <p>Now...when i post solrconfig.xml and schema.xml I get the following warning:</p> <p>[root@NJVC-BAO-DEV-DB-2 wikipedia]# ./1-add-schema_test.sh<br /> WARNING: "java.lang.RuntimeException: org.apache.solr.common.SolrException: Could not find: schema.xml"<br /> Posted solrconfig_test.xml to <a href="http://10.3.11.91:8983/solr/resource/mappingtest.chemicalstest/solrconfig_test.xml" rel="nofollow">http://10.3.11.91:8983/solr/resource/mappingtest.chemicalstest/solrconfig_test.xml</a><br /> WARNING: "java.lang.RuntimeException: org.apache.solr.common.SolrException: Could not find: schema.xml"<br /> Posted schema_test.xml to <a href="http://10.3.11.91:8983/solr/resource/mappingtest.chemicalstest/schema_test.xml" rel="nofollow">http://10.3.11.91:8983/solr/resource/mappingtest.chemicalstest/schema_test.xml</a> </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-4750 Thu, 02 Aug 2012 10:15:11 +0000 Piotr Kołaczkowski 4750@http://www.datastax.com/support-forums/ <p>Hmm, your search node is not in a separate DC. Therefore, if you have a replication factor = 1, only half of your data is placed on the search node. Probably because of a bug that was fixed in the 2.2 branch, the server tries to contact your analytics node to get the rest of the data and gets connection refused, because solr is not running there.</p> <p>Put the two nodes into separate datacenters or eventually try RF=2 with your current config (but that might still not work - there is a strong assumption in DSE search that it needs to have a separate DC). </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3351 Fri, 20 Jul 2012 17:40:53 +0000 datastaxtesting 3351@http://www.datastax.com/support-forums/ <p>Just to plain what I am doing:<br /> I have 2 node cluster 10.3.11.90(bin/dse cassandra -t running) and 10.3.11.91(bin/dse cassandra -s -f) running than in 10.3.11.91...I modified solrconfig.xml (localhost to 10.3.11.91) and than I followed the step as per solr wikipedia demo....also when I point to <a href="http://10.3.11.91:8983/demos/wikipedia/" rel="nofollow">http://10.3.11.91:8983/demos/wikipedia/</a> nothing lods in the right side....</p> <p>bin/dsetool result:</p> <p>[root@NJVC-BAO-DEV-DB-2 wiki]# /usr/local/datastax-2.1/dse-2.1/bin/dsetool ring -h 10.3.11.91<br /> Address DC Rack Workload Status State Load Owns Token<br /> 85070591730234615865843651857942052864<br /> 10.3.11.90 DC1 RAC1 Analytics(JT) Up Normal 1.08 MB 50.00% 0<br /> 10.3.11.91 DC1 RAC2 Search Up Normal 9.66 MB 50.00% 85070591730234615865843651857942052864 </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3350 Fri, 20 Jul 2012 17:38:46 +0000 datastaxtesting 3350@http://www.datastax.com/support-forums/ <p>Before posting I modified the solrconfig.xml (10.3.11.91 in place of localhost)</p> <p>This is the error which I could see in system log:</p> <p>ERROR [pool-2-thread-1] 2012-07-20 11:33:15,305 SolrException.java (line 114) org.apache.solr.common.SolrException: org.apache.solr.client.solrj.SolrServerException: java.net.ConnectException: Connection refused<br /> at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:284)<br /> at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)<br /> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1460)<br /> at org.apache.solr.core.QuerySenderListener.newSearcher(QuerySenderListener.java:59)<br /> at org.apache.solr.core.SolrCore$3.call(SolrCore.java:1237)<br /> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)<br /> at java.util.concurrent.FutureTask.run(FutureTask.java:138)<br /> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)<br /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br /> at java.lang.Thread.run(Thread.java:662)<br /> Caused by: org.apache.solr.client.solrj.SolrServerException: java.net.ConnectException: Connection refused </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3346 Fri, 20 Jul 2012 17:18:24 +0000 xedin 3346@http://www.datastax.com/support-forums/ <p>That error message could indicate that something went wrong on the server side, can you check you system.log for exceptions? </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3345 Fri, 20 Jul 2012 17:14:36 +0000 datastaxtesting 3345@http://www.datastax.com/support-forums/ <p>when I execute solr query inside cqlsh I get the following result below but no output??</p> <p>cqlsh:wiki&gt; select title from solr where solr_query='title:natio*';<br /> Request did not complete within rpc_timeout. </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3340 Fri, 20 Jul 2012 15:53:20 +0000 Piotr Kołaczkowski 3340@http://www.datastax.com/support-forums/ <p>You should POST solrconfig.xml and schema.xml using HTTP to appropriate URLs:</p> <p><a href="http://localhost:8983/solr/resource/" rel="nofollow">http://localhost:8983/solr/resource/</a>{keyspace}.{columnfamily}/solrconfig.xml<br /> <a href="http://localhost:8983/solr/resource/" rel="nofollow">http://localhost:8983/solr/resource/</a>{keyspace}.{columnfamily}/schema.xml</p> <p>You can POST many times, it will just overwrite the previous content if present. </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3280 Thu, 19 Jul 2012 14:46:27 +0000 datastaxtesting 3280@http://www.datastax.com/support-forums/ <p>Sorry!! Could you pl. explain in detail. </p> <p>Data I loaded in 10.3.11.90 node(cassandra running) and solr running in 10.3.11.91 node.</p> <p>Data format is:<br /> #UUID,ID,REG,AGE,SEX,HAZSUB,REPORT, CHEMICAL<br /> 550e8400-e29b-41d4-a716-446655440000,38083,12468880,0,0,21,19, chromium<br /> :<br /> :</p> <p>Now if the user search for chemical name say chromium than all rows containing chromium should be displayed.....Also in which folder should I make solrconfig.xml and schema.xml?? </p> <p>Thanks!! </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3270 Thu, 19 Jul 2012 11:03:12 +0000 Piotr Kołaczkowski 3270@http://www.datastax.com/support-forums/ <p>Posting solrconfig.xml and schema.xml is enough. You need to create schema.xml to provide appropriate mapping of your columns to Solr. Then it will just index existing data in Cassandra. </p> http://www.datastax.com/support-forums/topic/solr-search-on-csv-data#post-3252 Thu, 19 Jul 2012 04:35:16 +0000 datastaxtesting 3252@http://www.datastax.com/support-forums/ <p>I have 2 node cluster 10.3.11.90(seed node running cassandra) and 10.3.11.91(running solr).....I loaded the CSV data using bulk loader in the cluster now I have to make available solr search on this data...what is the step??</p> <p>Thanks! </p>