Re: [DISCUSS] State of the project 2019

Sorry to disturb others. @Danny Chan Hi, i have not received your personal mail, and i sent you email(yuzhao@gmail.com?) as well, but no reply. :( So i have to ping you in this way, please excuse me. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On

[jira] [Created] (CALCITE-3459) AssertionError for using Timestamp/Time/Date in table function

Wang Yanlin created CALCITE-3459: Summary: AssertionError for using Timestamp/Time/Date in table function Key: CALCITE-3459 URL: https://issues.apache.org/jira/browse/CALCITE-3459 Project: Calcite

[jira] [Created] (CALCITE-3458) Remove desc in AbstractRelNode

Haisheng Yuan created CALCITE-3458: -- Summary: Remove desc in AbstractRelNode Key: CALCITE-3458 URL: https://issues.apache.org/jira/browse/CALCITE-3458 Project: Calcite Issue Type:

Quicksql

Anyone know anything about Quicksql? It seems to be quite a popular project, and they have an internal fork of Calcite. https://github.com/Qihoo360/ https://github.com/Qihoo360/Quicksql/tree/master/analysis/src/main/java/org/apache/calcite

Re: Same rules fired for logical and physical nodes

This is probably a bigger discussion, but let me kick it off here anyway. Some of our planner rules have public constructors with Class arguments, and therefore people can create their own rule instances that match particular sub-classes. Other planner rules do not have those public

Re: [DISCUSSION] Cache Optimization in JdbcSchema

How much benefit is that massive cache giving you? If it’s not giving much benefit, maybe we should not be caching so much. Maybe in your case caching just the current schema (or the most recent 2 or 3 schemas) would be a better strategy. As y’all know, I’m always in favor of removing caches.

Re: [DISCUSS] Support Sql Hint for Calcite

Sure, we can make sure something gets into 1.22. There is consensus about the parser extensions, whereas the extensions to RelNode and the planner engine are a little more experimental. So let’s go forward with that, stating which parts we think are likely to change. Julian > On Oct 29,

[jira] [Created] (CALCITE-3457) RexSimplify incorrectly simplifies IS NOT NULL operator with ITEM call

Vova Vysotskyi created CALCITE-3457: --- Summary: RexSimplify incorrectly simplifies IS NOT NULL operator with ITEM call Key: CALCITE-3457 URL: https://issues.apache.org/jira/browse/CALCITE-3457

Re: Need help in adding keywords to Babel parser

Adding to the list of keywords is a start, but you'll also have to modify the parser to indicate where those keywords are valid to be used. You'll also need to modify some of the data structures to store information about what has been parsed. -- Michael Mior mm...@apache.org Le mar. 29 oct. 2019

[jira] [Created] (CALCITE-3456) AssertionError throws when aggregation has non-aggregate calls

Danny Chen created CALCITE-3456: --- Summary: AssertionError throws when aggregation has non-aggregate calls Key: CALCITE-3456 URL: https://issues.apache.org/jira/browse/CALCITE-3456 Project: Calcite

Re: Transaction Support - Guidelines

Hi Stamatis! Thank you for the clarification. It gives me some direction as to where to start. Regards, Kiran On Mon, Oct 28, 2019 at 6:25 PM Stamatis Zampetakis wrote: > Hi Kiran, > > This is definitely the place to ask such questions! > > Unfortunately, there is no specific documentation or

Re: Problem with converters and possibly rule matching

Hi Vladimir, I am sorry. Pushed, it works now. вт, 29 окт. 2019 г. в 14:41, Vladimir Sitnikov : > > mvn clean test > > [ERROR] The goal you specified requires a project to execute but there is > no POM in this directory > > Vladimir, please push missing files > > Vladimir >

Re: Problem with converters and possibly rule matching

> mvn clean test [ERROR] The goal you specified requires a project to execute but there is no POM in this directory Vladimir, please push missing files Vladimir

Re: Problem with converters and possibly rule matching

Hi colleagues, I prepared (relatively) simple reproducer for the problem [1]. It can be executed with three commands: git clone https://github.com/devozerov/calcite-optimizer.git cd calcite-optimizer mvn clean test Please do not pay attention to stuff located inside "org.apache.calcite" package,

Need help in adding keywords to Babel parser

Hi, I am writing a SQL statement (ANSI SQL or HiveQL) analyzer which will parse a given SQL statement into equivalent AST and I am using Babel for this use case. But when I try to parse statements such as “lateral view explode”, which is a valid HiveQL syntax, Babel is throwing ParseException.

Re: [DISCUSS] Support Sql Hint for Calcite

Colleagues, Not only Hazelcast and Apache Flink are interested in SQL hints. Apache Ignite community is working on Calcite integration too, it’s important for us to have appropriate API at current development stage. This case we’ll be able to adapt our solution for SQL hints usage, probably

Re: [DISCUSS] Support Sql Hint for Calcite

Julian, can we make  some effort to push this feature into release 1.22, there are users like Vladimir Ozerov from Hazelcast that are interesting on this feature, also the Apache Flink. I agree that this internal design is not that perfect, at this moment, we may hardly to conclude a perfect

Re: Problem with converters and possibly rule matching

Hi everybody, First of all, thank you for answers and suggestions. Let me address them briefly: 1) I use two conventions at the moment, LOGICAL and PHYSICAL. I agree with you that this might be overkill, and there is a chance that in the final solution we may end up with only one. But meanwhile

Re: Problem with converters and possibly rule matching

Vladimir, I guess Project rule doesn't have a child matcher. Put into it child "any" match rule and it will apply on each child node transformation. Regards, Igor вт, 29 окт. 2019 г., 7:07 Danny Chan : > Vladimir, all you need to do is to change the convention of the root node, > the volcano

Re: [DISCUSSION] Cache Optimization in JdbcSchema

Thanks, I will open a JIRA for discussion, with design doc and testing report. Danny Chan 于2019年10月29日周二 下午12:11写道： > Sounds very attractive, could you give an intuitive design doc to > illustrate how it works ? And we may review the design then ;) > > Best, > Danny Chan > 在 2019年10月29日 +0800

Re: Query hints support and example of extended SQL syntax

I’m trying to push it into release-1.22 (next release), wait for our good news ! Best, Danny Chan 在 2019年10月29日 +0800 PM2:11，Vladimir Ozerov ，写道： > Hi Danny, > > I looked at your design proposal and it looks great. All common hint cases > that we may possibly need are covered there. Thank you. >

Re: Query hints support and example of extended SQL syntax

Hi Danny, I looked at your design proposal and it looks great. All common hint cases that we may possibly need are covered there. Thank you. I hope the community will release it soon since hints are essential for production-grade systems. From what I see in other projects, such as Flink or