Andi Wang

Differential join can pick plan that reuses less arrangements when there are more than two inputs

1

Seen in a prospect query. There are no keys on foo, bar, or baz. There is only an index on `foo(a)`. ``` select from foo inner join bar on foo.a...

We need to think about how we would properly test that we support log compacted topics. To me, what's tricky about this is balancing the realism of testing vs having...

Generalized Upserts

2

Something that I know @frankmcsherry has also been thinking about. I consider this issue a sketchpad of potential directions upserts can take: * The option to convert any input into...

Support numeric aggregations on intervals

2

We can add two intervals, but we cannot sum a column of them. It would also be nice to have the rest of the numeric aggregations such as avg, stddev,...

Split OR Filters to UNIONs to reduce size of cross joins

3

From a prospect query: ``` select foo.b from foo, bar where foo.a = 'X' or foo.a = bar.a or bar.a = 'Y' ``` It plans something like ``` %0 =...

Optimization: Redundant join does not work if projects are inconsistently absorbed by reduces.

1

### What version of Materialize are you using? latest main ### How did you install Materialize? Linux release tarball ### What was the issue? Discovered by @andrioni. See slack thread...