[jira] [Created] (CALCITE-3849) SUBSTRING Function to support binary

Ritesh created CALCITE-3849: --- Summary: SUBSTRING Function to support binary Key: CALCITE-3849 URL: https://issues.apache.org/jira/browse/CALCITE-3849 Project: Calcite Issue Type: New Feature

Build failed in Jenkins: Calcite-Snapshots #129

See Changes: [chunwei] [CALCITE-3838] Support Calc in [jhyde] [CALCITE-3839] After calling RelBuilder.aggregate, cannot lookup field [jhyde] [CALCITE-3412] FLOOR(timestamp TO WEEK) gives wrong result [jhyde]

Re: "lazy" optmization?

We already did this in Flink SQL where there multiple optimize programs, each for specific purpose, we also have our own logical and physical conventions. Julian Hyde 于2020年3月10日 周二上午4:30写道： > It's difficult to do "split processing into phases" entirely within > Calcite. Generally a DBMS would

[jira] [Created] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

Vineet Garg created CALCITE-3848: Summary: Materialized view rewriting fails for mv consisting of group by on join keys Key: CALCITE-3848 URL: https://issues.apache.org/jira/browse/CALCITE-3848

Re: "lazy" optmization?

It's difficult to do "split processing into phases" entirely within Calcite. Generally a DBMS would manage these phases, and call Calcite at each step. I'd love to have some working code in Calcite that does this, but we'd be stepping over the line from "framework" into "platform". It's difficult

Calcite-Master - Build # 1638 - Still Failing

The Apache Jenkins build system has built Calcite-Master (build #1638) Status: Still Failing Check console output at https://builds.apache.org/job/Calcite-Master/1638/ to view the results.

Re: How to change sql to lower case in Cassandra Adapter?

Got it. Thank you! Michael Mior 于2020年3月9日周一 下午10:04写道： > The casing is a property of the parser, while the model is related to > the schema definition so unfortunately the casing can't be configured > in model.json. > -- > Michael Mior > mm...@apache.org > > Le lun. 9 mars 2020 à 10:00,

Re: How to change sql to lower case in Cassandra Adapter?

The casing is a property of the parser, while the model is related to the schema definition so unfortunately the casing can't be configured in model.json. -- Michael Mior mm...@apache.org Le lun. 9 mars 2020 à 10:00, Xiangwei Wei a écrit : > > Thank you! > > I tried to add a property to change

Re: How to change sql to lower case in Cassandra Adapter?

Thank you! I tried to add a property to change the value of unquotedCasing when establishing connection and it worked. One more question, is it possible to change the unquotedCasing property in the model.json file? Michael Mior 于2020年3月9日周一 下午8:27写道： > This is not from the adapter, but from

Re: How to change sql to lower case in Cassandra Adapter?

This is not from the adapter, but from Calcite's SQL parsing. By default, Calcite's parser will convert all unquoted names to uppercase. See the unquotedCasing property of the parser config. -- Michael Mior mm...@apache.org Le lun. 9 mars 2020 à 02:59, Xiangwei Wei a écrit : > > In Cassandra

[jira] [Created] (CALCITE-3847) Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables

Danny Chen created CALCITE-3847: --- Summary: Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables Key: CALCITE-3847 URL:

How to change sql to lower case in Cassandra Adapter?

In Cassandra Adapter, column name is converted to upper case if it's not surrounded by double quotation. How can I change it to lower case by default? -- Best, Xiangwei Wei