Calcite-Master - Build # 1315 - Still Failing

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

Re: PLC4X Request Optimization

2019-08-23 Thread Julian Hyde
The first step is to realize that you are looking at an optimization problem. Congratulations, you’ve done that. The next step is to evaluate the possible optimization techniques. Volcano is suitable in cases where there is dataflow - where the solution is a tree or DAG. It doesn’t seem that

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

2019-08-23 Thread Sachin Rohaj
Hello, In one of my use case i am working on DATE and TIMESTAMP based operands. We have select date + interval '1' DAY from table; I need to map this to target dialect. select target_func(date, interval '1' DAY) from table; *Approach*: I am planning to intercept the '+' operator in the

Re: Preserving CAST of STRING operands in comparison operator

2019-08-23 Thread Julian Hyde
I guess you’re talking about the JDBC adapter, and generating SQL for other dialects. I don’t recall why we have stripCastFromString() but I know that it was introduced for a good reason. Try making it no-op and see which tests fail. Julian > On Aug 23, 2019, at 3:32 AM, Soma Mondal wrote:

Preserving CAST of STRING operands in comparison operator

2019-08-23 Thread Soma Mondal
Hello, We have a REL which has this information select * from employee where employee_id = cast('12' as float); but Calcite removes the CAST from the STRING literal('12' in our case). select * from employee where employee_id = '12'; There are dialects which needs explicit casting in the above

Re: PLC4X Request Optimization

2019-08-23 Thread Julian Feinauer
Hi, a short update on this matter. We had a meetup yesterday with the PLC4X community and I prepared a very first "demo" implementation of the Optimizer / Framework. I tried to organize it after the Calcite / Volcano approach. We had several discussions and experimented a bit and some things

Re: [DISCUSS] ANTLR4 parse template for Calcite ?

2019-08-23 Thread Michael Mior
Incomplete, but here's one for PostgreSQL as well https://github.com/tshprecher/antlr_psql -- Michael Mior mm...@apache.org Le jeu. 22 août 2019 à 14:38, Julian Feinauer a écrit : > > Hi, > > there are some SQL dialect grammars online here (for ANTLR4) > >

Calcite-Master - Build # 1313 - Still Failing

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

[jira] [Created] (CALCITE-3287) Union's getRowCount in RelMdRowCount has not concern 'union all'

2019-08-23 Thread Hong Shen (Jira)
Hong Shen created CALCITE-3287: -- Summary: Union's getRowCount in RelMdRowCount has not concern 'union all' Key: CALCITE-3287 URL: https://issues.apache.org/jira/browse/CALCITE-3287 Project: Calcite