I try to remove it and test the previous case, the result is rewrite
successfully, the result is as follows:
*SELECT *FROM "hr"."MV0"WHERE "deptno" > 20*
But, I need to further analyze this part of the code to see if this
adjustment is possible.
On Tue, Nov
has two ways to do query-rewriting, namely substitution, and
> rules[1]. MaterializedViewRule builds on the ideas presented in the
> paper[2], which does not talk much about outer-join rewriting. If you want
> to support outer join, you can try to use
> MaterializedViewSubstitutionVisitor.
>
&g
Hello everyone,
I have a question about that Calcite does not support outer join in
materialized view. I have been thinking for a long time and still haven't
figured it out. Could anyone help me answer the reason? Thanks very much.
I also found in Calcite's materialization a annotation like that Cu
"SELECT COUNT(*) FILTER (WHERE timestampColumn > '2021-01-01),
timestampColumn FROM testTable WHERE timestampColumn > '2021-01-01"
+ "00:00:00.123' GROUP BY timestampColumn"
There's a semicolon missing.
On Mon, Sep 27, 2021 at 4:34 PM Atri Sharma wrote:
> Using the Babel parser, I get an er
Thank you very much!
On Mon, Sep 27, 2021 at 3:48 PM Francis Chuang
wrote:
> Hi,
>
> I've given you contributor permissions in jira.
>
> Francis
>
> On 27/09/2021 5:45 pm, hongkang jiang wrote:
> > Hi,
> >
> > I want to contribute to Apache Calcite.
Hi,
I want to contribute to Apache Calcite. Would you please give me the
contributor permission? My JIRA ID is jhkcool .😀