3 ms·
is where a good way of doing MPP SQL in Cassandra or Mongo? and Vertica is really far from being free, isn't it?
by trhway 12y ago
is where a good way of doing MPP SQL in Cassandra or Mongo? and Vertica is really far from being free, isn't it?
- imaginenore 12y agoPostgres-XL can do that. There's also Shard-Query and (not free) Amazon Redshift. Or you could just shard your regular community Postgre or MySQL.
- bsg75 12y agoSee also https://github.com/citusdata/cstore_fdw https://github.com/citusdata/cstore_fdw
- bsg75 12y agoVertica has a community tier, free up to 1TB of source data, and a 3 node limit. SQL is not part of the Cassandra or Mongo feature sets. They have certain analytic possibilities, but not if you want to use SQL (window functions for example), or most of the BI client tools associated with data warehousing.
- electrum 12y agoPresto is a fully distributed (MPP) SQL query engine that supports Cassandra: http://prestodb.io/docs/current/connector/cassandra.html http://prestodb.io/docs/current/connector/cassandra.html You can even join together data from Hive, Cassandra, MySQL, PostgreSQL, Kafka, etc., all in one query. We don't have a connector for Mongo yet, but contributions are welcome! The Cassandra connector was actually an external contribution. We don't use it at Facebook.