Search code examples
solrdatastax-enterprisedatastax-startup

datastax solr dynamicField full-text search


We've run into a problem with our Datastax Enterprise search workload. Our version is [cqlsh 5.0.1 | Cassandra 2.1.9.791 | DSE 4.8.0 | CQL spec 3.2.0 | Native protocol v3]. We have a cassandra schema for this table with a map collection properties map<text, text> and in the solr schema.xml we have <dynamicField name="properties*" type="text" indexed="true" stored="true" />.

The problem is that we've inserted data incorrectly, without using the prefix as described here. Is there a way to make this data searchable without losing all of the data that's already in the table?


Solution

  • I wrote a whole blog post about it:

    http://www.sestevez.com/brians-loader-unloader-for-search/

    TL;DR you have to re-insert the data, but the post has a one liner on how to do it with cassandra-loader and awk.