Split Join condition with CAST which only widening nullability

Hi all, Considering the Join condition 'CAST(IS_NOT_DISTINCT_FROM($1, $2), BOOLEAN)', which cast the non-nullable BOOLEAN to nullable BOOLEAN, Calcite can not split out equiv predicate, thus some join operation like hash join / sort merge join may not be used. Maybe we can expand

[jira] [Created] (CALCITE-3868) Remove redundant ruleSet and ruleNames in VolcanoPlanner

Haisheng Yuan created CALCITE-3868: -- Summary: Remove redundant ruleSet and ruleNames in VolcanoPlanner Key: CALCITE-3868 URL: https://issues.apache.org/jira/browse/CALCITE-3868 Project: Calcite

Re: STREAM keyword

Yes, you got the semantics correct. There are 6 kinds of events that can happen: create, update, delete of order_item, and create, update, delete of product. Some of these are not possible - e.g. creating a product with the same id after you have created an order - because of primary and

Re: STREAM keyword

Yep I think you got the idea. >Therefore to execute this query you need an unbounded memory for >`order_item` and `product` relations, so it's not a good candidate for a >streaming query, but let's put that aside, I'm interested in the semantics. The watermark idea is used to give a hint when

[jira] [Created] (CALCITE-3867) Support RelDistribution json serialization

Krisztian Kasa created CALCITE-3867: --- Summary: Support RelDistribution json serialization Key: CALCITE-3867 URL: https://issues.apache.org/jira/browse/CALCITE-3867 Project: Calcite Issue

Re: STREAM keyword

I've read again parts of the paper and now I've finally got the idea, I hope. The semantics still works with plain relations, relational operators are applied as in instantaneous queries, just the resulting relation is "streamed", in case of EMIT STREAM clause in the form of records and

Calcite-Master - Build # 1654 - Still Failing

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

Calcite-Master - Build # 1653 - Still Failing

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

set SqlToRelConverter.ConfigBuilder#expand default to false

Hi Now the default "expand" in SqlToRelConverter.ConfigBuilder is true but in calcite's main process, actually, it is false( `withExpand(THREAD_EXPAND.get())`) [image: image.png] [image: image.png] That leads we need to explicitly set `withExpand` to false when we use SqlToRelConverter. So