3 ms·
Impala is cool but it's a data warehouse, not a full-featured DBMS. The biggest difference is that it only supports batch inserts, so forget about UPDATE/DELETE
by teraflop 12y ago
Impala is cool but it's a data warehouse, not a full-featured DBMS. The biggest difference is that it only supports batch inserts, so forget about UPDATE/DELETE queries.
In any case, CitusDB's home page doesn't say anything about it being a columnar database, and this blog post says it uses the same storage engine as PostgreSQL.
- EdwardDiego 12y ago> Impala is cool but it's a data warehouse, not a full-featured DBMS. I wouldn't even call it that to be honest, you spend a lot of time thinking about Hadoop and HDFS files when working with Impala. > In any case, CitusDB's home page doesn't say anything about it being a columnar database It does, if you dig deep enough. :) https://www.citusdata.com/citus-products/cstore-fdw https://www.citusdata.com/citus-products/cstore-fdw But you're right that it's completely optional and not needed to access their distributed query processing.