Details
-
New Feature
-
Status: Open
-
Normal
-
Resolution: Unresolved
-
None
-
None
Description
For analytics & auditing purposes it becomes essential to serve different access patterns than that modeled from a partition key fetch perspective, although a limited reads are needed by users but if enabled cluster wide it will require index write for every row written on that table on every single node on every DC even the one which may be serving read operations. A user may not want to have indices built on Transactional DC on every write, that computation and disk utilization may not be useful as the Analytics may possibly be performed on other DC.
It will be a plus to have analytics / auditing workload built inside Cassandra itself using native secondary indices / SASI indices / Stratio by creating indices for a specific datacenter and not having to ship off data to other index stores like Elasticsearch through application.