Hacker News new | ask | show | jobs
by majidazimi 2785 days ago
Presto on top of Apache Ignite is basically an OLAP database (It just takes some effort to write the connector). It doesn't support transactional workloads though.
2 comments

This sounds like one of those things that sounds fun on a whiteboard but will be hell to implement and actually make perform well at all.
"Basically like" is very different from "engineered for"

Column-oriented storage itself is many times faster for analytical queries, even if on disk, and combined with the other optimizations of MemSQL will get you far better performance. Along with all the data being able to constantly undergo transactional updates.