Mapping arithmetic '+' operator with Date and Timestamp operands to target dialect functions

2019-08-26 Thread Sachin Rohaj
Hello Xing, No I will not be maintaining a customized `SqlImplementor`, rather I'll be making changes in the existing `SqlImplementor`. Regards, Sachin

Calcite-Master - Build # 1317 - Failure

2019-08-26 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #1317) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/1317/ to view the results.

Re: [DISCUSS] Towards Calcite 1.21.0

2019-08-26 Thread Danny Chan
Thanks for the review for CALCITE-2302, Julian. Best, Danny Chan 在 2019年8月26日 +0800 PM12:27,Julian Hyde ,写道: > Sounds good. > * I am reviewing 3122 and will commit shortly. > * I see Danny has asked me to final review 2302. I'll do that tomorrow. > * Who owns 1581? > > Julian > > On Sun, Aug 25,

[jira] [Created] (CALCITE-3297) PigToSqlAggregateRule should be applied on multi-set projection to produce an optimal plan

2019-08-26 Thread Khai Tran (Jira)
Khai Tran created CALCITE-3297: -- Summary: PigToSqlAggregateRule should be applied on multi-set projection to produce an optimal plan Key: CALCITE-3297 URL: https://issues.apache.org/jira/browse/CALCITE-3297

[jira] [Created] (CALCITE-3296) Decorrelator gives empty result after decorrelating sort rel with null offset and fetch

2019-08-26 Thread Juhwan Kim (Jira)
Juhwan Kim created CALCITE-3296: --- Summary: Decorrelator gives empty result after decorrelating sort rel with null offset and fetch Key: CALCITE-3296 URL: https://issues.apache.org/jira/browse/CALCITE-3296

Re: [DISCUSS] Towards Calcite 1.21.0

2019-08-26 Thread Julian Hyde
Regarding 3122. The fix looks good to me, but one test is broken when I merge in the fix to [CALCITE-3138] "RelStructuredTypeFlattener doesn't restructure ROW type fields”. So, we are holding until I figure with Khai Tran (author of 3122) and Igor Guzenko (author or 3138) out how to combine

Re: Preserving CAST of STRING operands in comparison operator

2019-08-26 Thread Julian Hyde
I might be mistaken, but disabling stripCastFromString() for some dialects and not others doesn’t sound like it’s solving the root cause of the problem. Julian > On Aug 26, 2019, at 7:49 AM, Soma Mondal wrote: > > Hi Julian, > > 2 tests failed when I made the stripCastFromString() no-op. >

Re: Preserving CAST of STRING operands in comparison operator

2019-08-26 Thread Soma Mondal
Hi Julian, 2 tests failed when I made the stripCastFromString() no-op. 1. testDb2DialectSelectQueryWithGroup 2. testSelectQueryWithGroup Above tests pretty much do the same thing and basically strip the cast from String literal something like this: Expected: SELECT COUNT(*),

Using Spark 2.4.0 as Execution Engine with Apache Calcite

2019-08-26 Thread Shubham Kumar
Hey, I am trying to optimize queries by creating materialized views in Hive and then exposing them to Calcite for optimized query rewrite. I wanted to know that how mature is the spark adapter of Calcite i.e. Let's say while making the connection I set parameter spark=true

[jira] [Created] (CALCITE-3295) Aggregate call name lost in serialized json string.

2019-08-26 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3295: Summary: Aggregate call name lost in serialized json string. Key: CALCITE-3295 URL: https://issues.apache.org/jira/browse/CALCITE-3295 Project: Calcite

[jira] [Created] (CALCITE-3294) Implement FINAL Clause for MATCH_RECOGNIZE

2019-08-26 Thread Julian Feinauer (Jira)
Julian Feinauer created CALCITE-3294: Summary: Implement FINAL Clause for MATCH_RECOGNIZE Key: CALCITE-3294 URL: https://issues.apache.org/jira/browse/CALCITE-3294 Project: Calcite Issue

Re: [DISCUSS] Towards Calcite 1.21.0

2019-08-26 Thread Chunwei Lei
Thanks for your work, Stamatis. As for 1581, I have reviewed it and it looks good to me. So I am +1 for the change. Best, Chunwei On Mon, Aug 26, 2019 at 1:39 PM Stamatis Zampetakis wrote: > I see that Chunwei has reviewed 1581 and he gave a +1 so I suppose it is > ready to go. > > On Mon,

Re: PLC4X Request Optimization

2019-08-26 Thread Julian Feinauer
Hi Julian, thank you very much for your insights. Your analysis is very detailed and I agree with all your suggestions. For myself I started to realize the "big" differences between Calcites Use Case and the PLC4X Case. I will definitely have a look into the book advised by you (I like

Re: Match Converter Rule based on Child Nodes

2019-08-26 Thread XING JIN
Hmm,, I get it So maybe you can try HepPlanner with match order of BOTTOM_UP; Or if VolcanoPlanner is necessary, how about call the optimization multiple times, e.g. wrap it with a loop Jin rahul patwari 于2019年8月23日周五 上午10:59写道: > Hi Jin, > > We wanted to transform LogicalJoin to different

[jira] [Created] (CALCITE-3293) Add strcmp function

2019-08-26 Thread xzh_dz (Jira)
xzh_dz created CALCITE-3293: --- Summary: Add strcmp function Key: CALCITE-3293 URL: https://issues.apache.org/jira/browse/CALCITE-3293 Project: Calcite Issue Type: Improvement Reporter:

Re: Mapping arithmetic '+' operator with Date and Timestamp operands to target dialect functions

2019-08-26 Thread XING JIN
I guess in your approach, you need to maintain a customized `SqlImplementor` ? How about add a RelOptRule and detect pattern of "date + interval '1' DAY" and use a RexShuttle to convert to "target_func(date, interval '1' DAY)" Thus only a RelOptRule needs to be maintained. Sachin Rohaj