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?
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.