[frankmcsherry]

Hi, I work at Materialize.

You can read about Vertica's "Live Aggregate Projections" here:

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/An...

In particular, there are important constraints like (among others)

> The projections can reference only one table.

In Materialize you can spin up just about any SQL92 query, join eight relations together, have correlated subqueries, count distinct if you want. It is then all maintained incrementally.

The lack of caveats is the main difference from the existing systems.