DataStax Support Forums » User Favorites: jas

DataStax Support Forums » User Favorites: jas jas Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 12:55:49 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php jas on "How to Drop a Solr index" http://www.datastax.com/support-forums/topic/how-to-drop-a-solr-index#post-7662 Sat, 24 Nov 2012 22:51:33 +0000 jas 7662@http://www.datastax.com/support-forums/ If you're equating "Solr index" to "Solr core", which you initially created using the DSE REST API (POSTed solrconfig.xml, schema.xml etc.), then drop the column family created in the process. When you invoked the API you specified keyspace.columnfamily. If that index is the only CF in the keyspace, then you can drop the keyspace as well and it's like you never created the Solr index. This will also remove the Lucene index files on the node (in solr.data). Cheers, Jeff Piotr Kołaczkowski on "How to Drop a Solr index" http://www.datastax.com/support-forums/topic/how-to-drop-a-solr-index#post-6876 Thu, 11 Oct 2012 17:36:42 +0000 Piotr Kołaczkowski 6876@http://www.datastax.com/support-forums/ You probably didn't find the answer because dropping secondary indexes isn't currently supported. We add it as a feature request. You can try to use DROP INDEX to remove the Solr secondary index. Anonymous on "How to Drop a Solr index" http://www.datastax.com/support-forums/topic/how-to-drop-a-solr-index#post-6748 Tue, 02 Oct 2012 20:00:55 +0000 Anonymous 6748@http://www.datastax.com/support-forums/ Hello, How do you drop a single Solr index within a solr node? Sorry, for the basic question. I am just not having any luck finding the answer. Thanks thobbs on "Specify consistency level through SOLR?" http://www.datastax.com/support-forums/topic/specify-consistency-level-through-solr/page/2#post-5810 Fri, 10 Aug 2012 20:07:09 +0000 thobbs 5810@http://www.datastax.com/support-forums/ Correct, with a third node and RF=3, updates at QUORUM can tolerate the failure of one of the replicas. jas on "Specify consistency level through SOLR?" http://www.datastax.com/support-forums/topic/specify-consistency-level-through-solr#post-5471 Tue, 07 Aug 2012 23:14:57 +0000 jas 5471@http://www.datastax.com/support-forums/ Thanks for the confirmation on the CL. RF for Solr is still kind of confusing to me. :) Just in case anybody else runs into this issue, I ran into a problem using a Solr 4.0 join query across two cores. I had misconfigured one of the core's (in the join <code>fromIndex</code>) keyspace with RF=1, while everything else was RF=2. Querying one node returned the correct answer, while the second did not. Apparently, until the Solr project implements distributed joins, a DSE node must have all of the data locally for both cores in order to do a local cross core join. Thus, RF=node count is required for such a join query to work on all nodes. I'm very dependent on this, so I'm glad to see that the default read CL of ONE is used for Solr queries. In addition, since I can specify the CL for an update, I can use ONE there as well. My hope here is that if one of the two nodes goes down, reads and writes won't fail since I'm forced to define RF=node count. Quorum reads and writes would fail otherwise. With a third node, and RF=3, this would not be a problem, right? Cheers, Jeff jas on "Multiple Schemas For Solr" http://www.datastax.com/support-forums/topic/multiple-schemas-for-solr#post-5470 Tue, 07 Aug 2012 22:40:17 +0000 jas 5470@http://www.datastax.com/support-forums/ Check out: <a href="http://www.datastax.com/docs/datastax_enterprise2.1/search/dse_search_schema" rel="nofollow">http://www.datastax.com/docs/datastax_enterprise2.1/search/dse_search_schema</a> You will create Solr cores using the convention of keyspaceName.columnFamilyName. They keyspace must exist, but DSE will create the column family based on the Solr configuration files you upload using the described REST API. Jeff jkusar on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-4322 Mon, 30 Jul 2012 21:24:55 +0000 jkusar 4322@http://www.datastax.com/support-forums/ Bah, I found my issue. I had some 2.0 binaries floating around in my path mucking things up since this didn't work in 2.0. Got everything cleaned up and it seems to be working now. Thanks! alexliu on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-4320 Mon, 30 Jul 2012 20:44:29 +0000 alexliu 4320@http://www.datastax.com/support-forums/ you can try test my example on DSE 2.1. I think it should work there as well. jkusar on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-4318 Mon, 30 Jul 2012 20:41:44 +0000 jkusar 4318@http://www.datastax.com/support-forums/ That's very interesting. How much longer till that version is released to the general public? Is it available as a beta anywhere? alexliu on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-4314 Mon, 30 Jul 2012 20:32:55 +0000 alexliu 4314@http://www.datastax.com/support-forums/ This is working in the incoming release, I am not sure DSE 2.1 the following is result that I run cqlsh> use ks33; cqlsh:ks33> insert into cf3 (key,title,body) values ('12345','This is a title','This is some body text'); cqlsh:ks33> select * from cf3; KEY | body | title -------+------------------------+----------------- 12345 | This is some body text | This is a title cqlsh:ks33> select * from cf3 where solr_query='text1:is'; KEY | body | title -------+------------------------+----------------- 12345 | This is some body text | This is a title cqlsh:ks33> select * from cf3 where solr_query='text1:body'; KEY | body | title -------+------------------------+----------------- 12345 | This is some body text | This is a title schema.xml <?xml version="1.0" encoding="UTF-8" ?> <schema name="wikipedia" version="1.1"> <types> <fieldType name="string" class="solr.StrField"/> <fieldType name="text" class="solr.TextField"> <analyzer><tokenizer class="solr.WikipediaTokenizerFactory"/></analyzer> </fieldType> </types> <fields> <field name="id" type="string" indexed="true" stored="true"/> <field name="name" type="text" indexed="true" stored="true"/> <field name="body" type="text" indexed="true" stored="true"/> <field name="title" type="text" indexed="true" stored="true"/> <field name="date" type="string" indexed="true" stored="true"/> <field name="text1" type="text" indexed="true" stored="true" multiValued="true"/> </fields> <defaultSearchField>body</defaultSearchField> <uniqueKey>id</uniqueKey> <copyField source="body" dest="text1"/> <copyField source="title" dest="text1"/> </schema> alexliu on "Multiple Schemas For Solr" http://www.datastax.com/support-forums/topic/multiple-schemas-for-solr#post-4271 Mon, 30 Jul 2012 16:42:12 +0000 alexliu 4271@http://www.datastax.com/support-forums/ can you post your solrconfig.xml and schema.xml files there, so we can do more investigate the issue, and reproduce it. gurkanoluc on "Multiple Schemas For Solr" http://www.datastax.com/support-forums/topic/multiple-schemas-for-solr#post-4218 Mon, 30 Jul 2012 07:58:17 +0000 gurkanoluc 4218@http://www.datastax.com/support-forums/ Hi again, I searched over internet, and see what I need is, multi core solr setup. In normal Solr setup, I can easily create multi cores. But in DSE, I couldn't find any document about this. Is there any idea? Basically, what I want to do is, index multiple Column Families using DSE Solr. Thanks. gurkanoluc on "Multiple Schemas For Solr" http://www.datastax.com/support-forums/topic/multiple-schemas-for-solr#post-4035 Fri, 27 Jul 2012 23:02:59 +0000 gurkanoluc 4035@http://www.datastax.com/support-forums/ Hi, I want to make search on multiple column families. In the examples of dse, there is only one schema. I have tried writing multiple schema definitions to schema.xml file and writing schema defitinitions to different files and calling them separately. When I type all schema definitions to one file, I'm getting ---- WARNING: "java.lang.RuntimeException: org.apache.solr.common.SolrException: Schema Parsing Failed: Premature end of file." Posted solrconfig.xml to <a href="http://localhost:8983/solr/resource/keyspace.Badges/solrconfig.xml" rel="nofollow">http://localhost:8983/solr/resource/keyspace.Badges/solrconfig.xml</a> WARNING: "java.lang.RuntimeException: org.apache.solr.common.SolrException: Schema Parsing Failed: The markup in the document following the root element must be well-formed." Posted schema.xml to <a href="http://localhost:8983/solr/resource/keyspace.Badges/schema.xml" rel="nofollow">http://localhost:8983/solr/resource/keyspace.Badges/schema.xml</a> ---- errors. If I want to post separately I'm getting, schema.xml file is not found. What is the ideal way of using multiple schema files? Thanks. jkusar on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-3897 Thu, 26 Jul 2012 18:07:23 +0000 jkusar 3897@http://www.datastax.com/support-forums/ Ok, here's some steps to reproduce the problem. First modify the wikipedia schema as follows: <pre><code><schema name="wikipedia" version="1.1"> <types> <fieldType name="string" class="solr.StrField"/> <fieldType name="text" class="solr.TextField"> <analyzer><tokenizer class="solr.WikipediaTokenizerFactory"/></analyzer> </fieldType> </types> <fields> <field name="id" type="string" indexed="true" stored="true"/> <field name="body" type="text" indexed="true" stored="true"/> <field name="text" type="text" indexed="true" stored="true" multiValued="true"/> <field name="title" type="text" indexed="true" stored="true"/> <field name="date" type="string" indexed="true" stored="true"/> </fields> <defaultSearchField>text</defaultSearchField> <uniqueKey>id</uniqueKey> <copyField source="body" dest="text"/> <copyField source="title" dest="text"/> </schema></code></pre> Run the add schema script. From cqlsh add a record: <code>cqlsh:wiki> insert into solr (key,title,body) values ('12345','This is a title','This is some body text');</code> Now from the solr admin tool, query for body. You will get nothing as it is searching the 'text' field and nothing has been copied to it. If you instead search for body:body (search for body within the body field), you get your record back. The copyField is definitely not happening. This is running a single solr node. The keyspace is using SimpleStrategy with RF=1. jkusar on "Data inserted via CQL does not get run through Solr's copyField directives" http://www.datastax.com/support-forums/topic/data-inserted-via-cql-does-not-get-run-through-solrs-copyfield-directives/page/2#post-3896 Thu, 26 Jul 2012 17:47:40 +0000 jkusar 3896@http://www.datastax.com/support-forums/ I'm not using dynamic fields. All nodes are Solr. My schema is posted in another recent thread about copyField.