Re: Cassandra and Vertica

2020-11-15 Thread CPC
Data distribution(vertica segements cassandra partition keys) are similar. Both dbms hold data as immutable data files but this is it. Aside from that nothing is similar. Cassandra was designed for OLTP loads but vertica designed for analytical loads. On Sun, 15 Nov 2020 at 23:37, Manu Chadha wro

Cassandra and Vertica

2020-11-15 Thread Manu Chadha
Has anyone here used Vertica? Out of curiosity, are Cassandra and Vertica databases similar? I recently spent time reading about Vertica. It has features like columnar data structures called projections which optimise query execution. It also has no single point of failure. But it comes out as a