http://www.datastax.com/support-forums/topic/search-and-ttl Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 22:25:33 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php 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>