Awesome, i watched the demo video... i will be trying this. Thanks for the info on lightweight transactions, sounds like the perfect use then!
As for the indexes - are they standard Cassandra secondary indexes? "Custom secondary indexes" - does that mean that it just looks like a secondary index, but is actually backed by Elastic search?