You are moving from a SQL database to C* ??? I hope you are aware of the differences between a nosql like C* and a RDBMS. To keep it short, the app has to change significantly.
Please read documentation on differences between nosql and RDBMS. thanks. On Tue, Jan 5, 2016 at 6:20 AM, Bhuvan Rawal <bhu1ra...@gmail.com> wrote: > Hi All, > > Im planning to shift from SQL database to a columnar nosql database, we > have streamlined our choices to Cassandra and HBase. I would really > appreciate if someone decent experience with both give me a honest > comparison on below parameters (links to neutral benchmarks/blogs also > appreciated): > > 1. Data Consistency (Eventual consistency allowed but define "eventual") > 2. Ease of Scaling Up > 3. Managebility > 4. Failure Recovery options > 5. Secondary Indexing > 6. Data Aggregation > 7. Query Language (3rd party wrapper solutions also allowed) > 8. Security > 9. *Commercial Support for quick solutions to issues*. > 10. Run batch job on data like map reduce or some common aggregation > functions using row scan. Any other packages for cassandra to achieve this? > 11. Trigger specific updates on tables used for secondary index. > 12. Please consider that our DB will be the source of truth, with no > specific requirement of immediate data consistency amongst nodes. > > Regards, > Bhuvan Rawal > SDE >