Create entry

Cassandra vs. vertica

Cassandra vertica + Add column
Description Second Generation Distributed Database Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine.
Multi-user system Yes Yes
Memory minimum 8 GB 8 GB
Extension/Plug-in Yes Yes
Operating system
Programming language
Database ?
Website cassandra.​apache.​org www.​vertica.​com
Database model
Query language
Transactions Yes Yes
Unicode Yes Yes
Referential integrity No Yes
Price rating ★★☆☆☆ ?
Standard compliance Yes ?
Sharding Yes Yes
Replication Yes Yes
Map and reduce Yes Yes
Revision control Yes ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Full text search No Yes
Preference (0% global votes) (50% global votes)
Documentation level ★★★★☆ ★★★★☆
TTL for entries Yes Yes
Value size max. 2 GB 956 PB
Conditional entry updates Yes Yes
Composite keys Yes No
Free to use Yes Conditional
Active Yes Yes
Compression Yes Yes
Shared nothing architecture Yes Yes
Secondary Indexes Yes No
Graph support Yes ?
Embeddable Yes No
Geospatial Indexes No Yes
Locking model ?
Data storage
Replication mode
Native driver ?
Data types ?
Open Source Yes No
Multilingual content ? Yes
Multiple projects ? Yes
Software distribution ?
Release Date ? 2007
RESTful ? No
Database Connection Pooling ? Yes
Real time analytics ? Yes
API ? Good
Cloud platform support ?
Log ? Yes
Download ? https:/​/​my.​vertica.​com/​community/​
Level of access authorization ?
Query Cache ? Yes
Ease of use ? ★★★★☆
Free for commercial use ? Yes
Sorts ? Yes
Perfomance ? ★★★★★
Geospatial ? Yes
Server Side Java Script ? Yes
JSON ? Yes
Flexible Table(Schema) ? Yes
Stored Procedure ? No
Auto-Sharding ? Yes
Free edition ? Yes
Kafka Integration ? Yes
SQL Queries ? Yes
420 Friendly? ? Yes
Multi-statement Transactions ? Yes
memcached protocol ? No
Monitoring UI ? Yes
Recursive queries ? No
CLI` ? Yes
Columner ? Yes
Monitoring and Management ?
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
+ Add row ++
Cassandra vertica
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.