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 <manu.cha...@hotmail.com> wrote: > 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 an RDBMS database which supports join. The fact that in Cassandra as > well a table is created to serve a query, it made me wonder if/how > Cassandra and Vertica are similar and different? > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > >
