fredespi Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 08:08:02 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/documentation-error#post-9486 Wed, 20 Mar 2013 23:59:31 +0000 thobbs 9486@http://www.datastax.com/support-forums/ <p>fredespi,</p> <p>Thanks! The documentation has been corrected. </p> http://www.datastax.com/support-forums/topic/possible-bug-with-group-queries-in-dse-search-30#post-9295 Mon, 04 Mar 2013 12:07:37 +0000 sergio 9295@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>I wasn't able to reproduce your problem: I uploaded a schema with a few non-required fields, inserted some data and run some group queries, but everything works fine.</p> <p>Could you reproduce your problem in a simplified setup and send us some test data?<br /> The following would be great:<br /> 1) The schema.xml.<br /> 2) A few documents to insert.<br /> 3) The query to tun.</p> <p>Thanks,</p> <p>Sergio B. </p> http://www.datastax.com/support-forums/topic/possible-bug-with-group-queries-in-dse-search-30#post-9294 Mon, 04 Mar 2013 10:41:07 +0000 fredespi 9294@http://www.datastax.com/support-forums/ <p>Upon upgrading to DSE 3, there seems to be an issue with group.query in solr.<br /> This functionality only seems to work if the field which is being queried has the property 'required' set to true.<br /> In all other fields, where 'required' is not set to true, if that field is queried in group.query, a NullPointerException is thrown.</p> <p>For example:<br /> If 'id' has required=true, and text does not,<br /> group=true&amp;group.query=id:"123ABC" works fine, but<br /> group=true&amp;group.query=text:"123ABC" throws a NullPointerException.</p> <p>Below is the stacktrace:</p> <p>java.lang.NullPointerException at org.apache.solr.search.grouping.distributed.shardresultserializer.TopGroupsResultTransformer.transformToNative(TopGroupsResultTransformer.java:110) at org.apache.solr.search.grouping.distributed.responseprocessor.TopGroupsShardResponseProcessor.process(TopGroupsShardResponseProcessor.java:80) at org.apache.solr.handler.component.QueryComponent.handleGroupedResponses(QueryComponent.java:620) at org.apache.solr.handler.component.QueryComponent.handleResponses(QueryComponent.java:603) at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:317) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1679) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:462) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.execute(CassandraDispatchFilter.java:184) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:276) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.doFilter(CassandraDispatchFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at ...</p> <p>This issue with group.query did not exist in DSE 2.2 </p> http://www.datastax.com/support-forums/topic/documentation-error#post-9209 Thu, 28 Feb 2013 15:07:40 +0000 fredespi 9209@http://www.datastax.com/support-forums/ <p>The page <a href="http://www.datastax.com/docs/datastax_enterprise3.0/solutions/dse_search_upload" rel="nofollow">http://www.datastax.com/docs/datastax_enterprise3.0/solutions/dse_search_upload</a> explains how to reload a solr core. It mentions a curl call: </p> <p>curl <a href="http://localhost:8983/solr/admin/cores?action=RELOAD&#038;name=&lt;keyspace.columnfamily&#038;gt" rel="nofollow">http://localhost:8983/solr/admin/cores?action=RELOAD&#038;name=&lt;keyspace.columnfamily&#038;gt</a>;<br /> --reindex=true --deleteAll=false</p> <p>which should (probably) really be</p> <p>curl "http://localhost:8983/solr/admin/cores?action=RELOAD&amp;name=&lt;keyspace.columnfamily&gt;&amp;reindex=true&amp;deleteAll=false" </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8775 Tue, 29 Jan 2013 19:39:47 +0000 Sven 8775@http://www.datastax.com/support-forums/ <p>You would probably also have to establish a C* connection from the client to issue the update command. I don't believe there is any purely solr based way to control that. I will file a feature request for that. </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8772 Tue, 29 Jan 2013 17:45:08 +0000 fredespi 8772@http://www.datastax.com/support-forums/ <p>Thank you. It seems you need to set ttl for each column you update or insert. Ok but how do I do that from a solr client? </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8771 Tue, 29 Jan 2013 16:44:44 +0000 alexliu 8771@http://www.datastax.com/support-forums/ <p>You can follow this link to set the ttl for the column.</p> <p><a href="http://www.datastax.com/docs/1.0/references/cql/INSERT" rel="nofollow">http://www.datastax.com/docs/1.0/references/cql/INSERT</a> </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8758 Tue, 29 Jan 2013 09:31:40 +0000 fredespi 8758@http://www.datastax.com/support-forums/ <p>Thanks. Could you give me an example? I uploaded a solrconfig and schema file and the resulting solr column now exists (as described in <a href="http://www.datastax.com/docs/datastax_enterprise2.0/search/dse_search_start#running-the-dse-search-demo)" rel="nofollow">http://www.datastax.com/docs/datastax_enterprise2.0/search/dse_search_start#running-the-dse-search-demo)</a> . How do I set TTL? </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8740 Mon, 28 Jan 2013 18:08:57 +0000 alexliu 8740@http://www.datastax.com/support-forums/ <p>when you create a column, you can specify the ttl for the column. The ttl is per column, it's not set per column family. </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8661 Fri, 25 Jan 2013 10:33:38 +0000 fredespi 8661@http://www.datastax.com/support-forums/ <p>Thanks Sven.</p> <p>But I don't understand. It seems to me that the post you linked to explains how to make sure the solr index is synchronized more often with the expired cassandra data. When ttl is set (somehow) on the data, and it expires in cassandra, the solr index may still have the data indexed (unless compactation has run) and you will get erroneous results. With the suggested solution those discrepancies decrease. I find it a little difficult to understand how exactly to get this to work as well, but my main problem is that I don't understand how to set ttl in the first place. I understand how to do it using cqlsh but not using solr api calls. I guess my question is: is ttl supposed to be set with every insert/update or do you set it once on a CF? If it's the first case, how do you do it with solr api calls? </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8638 Thu, 24 Jan 2013 19:01:34 +0000 Sven 8638@http://www.datastax.com/support-forums/ <p>You may want to check out <a href="http://www.datastax.com/dev/blog/cassandra-column-ttl-support-in-dse-search" rel="nofollow">http://www.datastax.com/dev/blog/cassandra-column-ttl-support-in-dse-search</a>.</p> <p>Thanks,<br /> Sven </p> http://www.datastax.com/support-forums/topic/search-and-ttl#post-8631 Thu, 24 Jan 2013 12:46:13 +0000 fredespi 8631@http://www.datastax.com/support-forums/ <p>I don't understand how to get TTL set on a solr CF. My understanding is that it might be possible to set a property on the CF, or that I need to set the TTL for each insert or update; either way it seems I need to use cassandra-cli or cqlsh. My question is how to do it when I do updates using the solr APIs? </p> http://www.datastax.com/support-forums/topic/incorrect-replica-assignment#post-7489 Tue, 13 Nov 2012 20:07:59 +0000 fredespi 7489@http://www.datastax.com/support-forums/ <p>Unfortunately I had already switched tokens between two of the nodes so I can't replicate the problem now. Sorry. </p> http://www.datastax.com/support-forums/topic/incorrect-replica-assignment#post-7435 Wed, 07 Nov 2012 23:30:15 +0000 nickmbailey 7435@http://www.datastax.com/support-forums/ <p>That could perhaps be a bug. Can you attach the output from 'nodetool ring' and 'nodetool describering &lt;keyspace&gt;' </p> http://www.datastax.com/support-forums/topic/incorrect-replica-assignment#post-7433 Wed, 07 Nov 2012 20:42:11 +0000 fredespi 7433@http://www.datastax.com/support-forums/ <p>using opscenter view replication and by doing nodetool describering keyspace. </p>