Andi Wang
Andi Wang
Related: #2813
The workaround is to create a subview: ``` create view subview as select foo.b as b, from foo inner join bar on foo.a = bar.a select from subview inner join...
This issue is also seen in TPC-H Query 16.
Also, see comment here, where I propose the option to create an upsert view on top of a non-upsert source (or view): https://github.com/MaterializeInc/materialize/issues/1576#issuecomment-621961931
Do we have a target for what "high rate" is? That would help in determining what we base the work on. Also, other things to think about include: * how...
@philip-stoev Do we currently have any long-running load tests?
My current workaround for the lack of aggregations on intervals is to EXTRACT EPOCH from them, and do aggregations on them as floats.
> I presume that the rendering might still be able to push those to the join closure that is just after that input, which means that we'll filter with them...