DataStax Support Forums » Topic: DSE - Can Solr Index and Cassandra Secondary Indexes CoExists on Different Columns in same CF ?

DataStax Support Forums » Topic: DSE - Can Solr Index and Cassandra Secondary Indexes CoExists on Different Columns in same CF ? http://www.datastax.com/support-forums/topic/dse-can-solr-index-and-cassandra-secondary-indexes-coexists-on-different-columns-in-same-cf Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 03:35:02 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php shruti on "DSE - Can Solr Index and Cassandra Secondary Indexes CoExists on Different Columns in same CF ?" http://www.datastax.com/support-forums/topic/dse-can-solr-index-and-cassandra-secondary-indexes-coexists-on-different-columns-in-same-cf#post-7565 Mon, 19 Nov 2012 06:03:18 +0000 shruti 7565@http://www.datastax.com/support-forums/ Hi , Thanks for the reply . Initially in our application , we were using cassandra secondary indexes . now with the same schema , we have moved to Solr queries . I just wanted to know , if I can use existing cassandra CF with existing secondary indexes on some columnns and create Solr indexes on other columns in the same CF . I did try this out , as mentioned above, however DSE behavior was not consistent , sometimes it was able to create Solr indexes on columns , in which secondary indexes existed for other columns . However sometimes it will throw exception that index already exists . Just wanted to clear out my confusion . Thanks! rockbrain on "DSE - Can Solr Index and Cassandra Secondary Indexes CoExists on Different Columns in same CF ?" http://www.datastax.com/support-forums/topic/dse-can-solr-index-and-cassandra-secondary-indexes-coexists-on-different-columns-in-same-cf#post-7454 Fri, 09 Nov 2012 18:57:47 +0000 rockbrain 7454@http://www.datastax.com/support-forums/ You cannot mix and match secondary indexes with Solr. Also, if you are using Solr, it is more efficient than the other secondary index solution and provides more functionality. Can you elaborate on your use case? shruti on "DSE - Can Solr Index and Cassandra Secondary Indexes CoExists on Different Columns in same CF ?" http://www.datastax.com/support-forums/topic/dse-can-solr-index-and-cassandra-secondary-indexes-coexists-on-different-columns-in-same-cf#post-7438 Thu, 08 Nov 2012 06:06:01 +0000 shruti 7438@http://www.datastax.com/support-forums/ Hi All, I am using DSE for my solr queries . Currently I have a requirement for a solr index and cassandra secondary index to exist in same column family but different Columns , such that if I query column which is Solrbased Index , I also get Columns which are indexed through Cassandra. My Schema.xml currently looks like - <?xml version="1.0" encoding="UTF-8" ?> <schema name="cf4" version="1.1"> <types> <fieldType name="text" class="solr.TextField"/> </types> <fields> <field name="cidx1" type="text" indexed="false"/> <field name="cidx2" type="text" indexed="false"/> <field name="sidx1" type="text" indexed="true" stored="true"/> <field name="sidx2" type="text" indexed="true" stored="true"/> </fields> <defaultSearchField>sidx1</defaultSearchField> <uniqueKey>sidx1</uniqueKey> </schema> and my CF Definition - CREATE COLUMN FAMILY cf4 WITH column_type = Standard AND key_validation_class = 'UTF8Type' AND comparator = 'UTF8Type' AND default_validation_class = 'UTF8Type' AND column_metadata = [ {column_name: sidx1, validation_class: UTF8Type} {column_name: sidx2, validation_class: UTF8Type} {column_name: cidx1, validation_class: UTF8Type, index_type: KEYS} {column_name: cidx2, validation_class: UTF8Type, index_type: KEYS} ]; cidx1 and cidx2 are two columns indexed thorough cassandra , but need to be returned in Solr search query . This is currently throwing Exception stating - Not Solr-based type of index is found: testKeyspace1_cf4_cidx2_index" However , if I send my schema.xml as- <?xml version="1.0" encoding="UTF-8" ?> <schema name="cf4" version="1.1"> <types> <fieldType name="text" class="solr.TextField"/> </types> <fields> <field name="sidx1" type="text" indexed="true" stored="true"/> <field name="sidx2" type="text" indexed="true" stored="true"/> </fields> <defaultSearchField>sidx1</defaultSearchField> <uniqueKey>sidx1</uniqueKey> </schema> It Works fine , however when I query based on sidx1 OR sidx2 I donot get fields indexed through Cassandra cidx1 and cidx2 . Please let me know if this case is achievable , or am I missing on something . Thanks !