http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 06:26:57 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-6643 Mon, 24 Sep 2012 19:58:15 +0000 alexliu 6643@http://www.datastax.com/support-forums/ <p>no, we can fire a feature request </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-6636 Mon, 24 Sep 2012 09:05:51 +0000 shruti 6636@http://www.datastax.com/support-forums/ <p>Hi All,<br /> Even I have the requirement to index column through both secondary indexes and Solr index .Is there a way of doing it in DSE currently ? </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-2071 Mon, 11 Jun 2012 15:02:13 +0000 Anonymous 2071@http://www.datastax.com/support-forums/ <p>Hi Pearly, I don't think it was mentioned here, but I did find out that it is not currently possible without duplicating the column and indexing it two different ways. </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-2063 Mon, 11 Jun 2012 04:50:14 +0000 Anonymous 2063@http://www.datastax.com/support-forums/ <p>I had the same question that jkusar asked in this thread. That's to have the secondary index and solr index on the same column. Reading this thread, I could not find where the original question landed up. So is it possible to have both secondary index and Solr indexing on the same column. </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1764 Wed, 25 Apr 2012 18:18:12 +0000 tjake 1764@http://www.datastax.com/support-forums/ <p>You can tell the commit to block until the new searcher is ready</p> <p><a href="http://wiki.apache.org/solr/UpdateXmlMessages#Optional_attributes_for_.22commit.22_and_.22optimize.22" rel="nofollow">http://wiki.apache.org/solr/UpdateXmlMessages#Optional_attributes_for_.22commit.22_and_.22optimize.22</a> </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1763 Wed, 25 Apr 2012 18:08:50 +0000 Anonymous 1763@http://www.datastax.com/support-forums/ <p>Is that different than normal Solr? In my past experience with Solr, sending a commit message to Solr is asynchronous. It begins the commit right away, but it's still possible to do a search that doesn't include the new docs. </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1761 Wed, 25 Apr 2012 15:22:53 +0000 tjake 1761@http://www.datastax.com/support-forums/ <p>You can also try setting maxDocs to 1 </p> <p><a href="http://www.datastax.com/docs/datastax_enterprise2.0/search/dse_search_cluster#tuning-performance" rel="nofollow">http://www.datastax.com/docs/datastax_enterprise2.0/search/dse_search_cluster#tuning-performance</a> </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1760 Wed, 25 Apr 2012 15:21:55 +0000 tjake 1760@http://www.datastax.com/support-forums/ <p>If you commit via the solr api then you can guarantee its available for search </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1759 Wed, 25 Apr 2012 12:29:09 +0000 Anonymous 1759@http://www.datastax.com/support-forums/ <p>It was pointed out to me that if there was a way to optionally guarantee that SOLR had indexed a document and made it available for searching before returning from the CQL statement, then that would give me my guarantee and I could just do everything via SOLR.</p> <p>Any chance of this being implemented? </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1729 Fri, 20 Apr 2012 13:20:49 +0000 Anonymous 1729@http://www.datastax.com/support-forums/ <p>Also, if the secondary index exists before the field is added to the solr schema, then solr is unable to index the field.</p> <p>Is the solution just to run separate solr and cassandra nodes? We were attempting to avoid that if possible as it's not a requirement for us in order to handle load and just doubles the amount of hardware we need to buy and maintain. Even if that is the solution, won't the secondary indexes just replicate to the search nodes anyways along with the rest of the schema changes preventing solr from indexing the fields? </p> http://www.datastax.com/support-forums/topic/any-way-to-have-a-solr-and-normal-secondary-index-on-same-column#post-1727 Fri, 20 Apr 2012 13:17:12 +0000 Anonymous 1727@http://www.datastax.com/support-forums/ <p>Currently working with the wikipedia demo. I'm trying to have a column both indexed into solr and available for search via a normal cassandra secondary index. All of this is running on the same search node.</p> <p>When I try to create the secondary index, I get a message that the index already exists. It looks like it was created as part of the solr index. However, if I try query it like I would a secondary index, I get an error in the log stating "Solr search queries only supported on the 'solr_query' field".</p> <p>A little background: there are certain cases in our application where "near real-time" isn't fast enough. We need certain pieces of data to be available within the system immediately, and so a secondary index is needed so that we can look them up right away without having to wait for Solr to finish committing the changes. </p>