[jira] [Created] (CALCITE-4118) RexSimplify might remove CAST from RexNode incorrectly

2020-07-09 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-4118: --- Summary: RexSimplify might remove CAST from RexNode incorrectly Key: CALCITE-4118 URL: https://issues.apache.org/jira/browse/CALCITE-4118 Project: Calcite

[jira] [Created] (CALCITE-4053) RexSimplify should not pass exprs containing non-const subExprs to RexExecutor#reduce

2020-06-08 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-4053: --- Summary: RexSimplify should not pass exprs containing non-const subExprs to RexExecutor#reduce Key: CALCITE-4053 URL: https://issues.apache.org/jira/browse/CALCITE-4053

[jira] [Created] (CALCITE-3979) Unexpected removing of CAST in ReduceExpressionsRule

2020-05-08 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3979: --- Summary: Unexpected removing of CAST in ReduceExpressionsRule Key: CALCITE-3979 URL: https://issues.apache.org/jira/browse/CALCITE-3979 Project: Calcite Issue

[jira] [Created] (CALCITE-3893) Sql with GROUP_ID may generate wrong plan

2020-04-02 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3893: --- Summary: Sql with GROUP_ID may generate wrong plan Key: CALCITE-3893 URL: https://issues.apache.org/jira/browse/CALCITE-3893 Project: Calcite Issue Type: Bug

Re: Split Join condition with CAST which only widening nullability

2020-03-26 Thread Shuo Cheng
RelBuilder could be done. I've do some fix in above Link (remove unnecessary CAST when doing pushDownEqualJoinConditions) On Thu, Mar 26, 2020 at 7:14 PM Shuo Cheng wrote: > Sorry for the late reply, I've reproduced the problem here > https://github.com/cshu

Re: Split Join condition with CAST which only widening nullability

2020-03-26 Thread Shuo Cheng
hose could be referenced (and the reference also > has the type) ; but for filter/join conditions we don't need to care with > it. > > It seems we already have a "matchnullability" in ReduceExpressionsRule ; > for FILTER/JOIN we should probably turn that off... :) >

Re: Split Join condition with CAST which only widening nullability

2020-03-23 Thread Shuo Cheng
ble BOOLEAN? The join condition treats > UNKNOWN the same as FALSE, and besides UNKNOWN will never occur, so the > conditions with and without the CAST are equivalent. > > Julian > > > On Mar 23, 2020, at 9:34 PM, Shuo Cheng wrote: > > > > Hi all, > > >

Split Join condition with CAST which only widening nullability

2020-03-23 Thread Shuo Cheng
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 RelOptUtil#splitJ

[jira] [Created] (CALCITE-3830) Digest of AggregateCall do not consider the ''

2020-02-26 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3830: --- Summary: Digest of AggregateCall do not consider the '' Key: CALCITE-3830 URL: https://issues.apache.org/jira/browse/CALCITE-3830 Project: Calcite

[jira] [Created] (CALCITE-3721) Filter of distinct aggregate call is lost after applying `AggregateExpandDistinctAggregatesRule`

2020-01-09 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3721: --- Summary: Filter of distinct aggregate call is lost after applying `AggregateExpandDistinctAggregatesRule` Key: CALCITE-3721 URL: https://issues.apache.org/jira/browse/CALCITE-3721

[jira] [Created] (CALCITE-3631) Support SQL hints for Calc

2019-12-25 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3631: --- Summary: Support SQL hints for Calc Key: CALCITE-3631 URL: https://issues.apache.org/jira/browse/CALCITE-3631 Project: Calcite Issue Type: Sub-task

Contribute to Calcite

2019-12-16 Thread Shuo Cheng
Hi Guys, I want to contribute to Apache Calcite. Would you please give me the permission as a contributor? My JIRA ID is icshuo.

[jira] [Created] (CALCITE-3590) Support SQL hints for Aggregate.

2019-12-11 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3590: --- Summary: Support SQL hints for Aggregate. Key: CALCITE-3590 URL: https://issues.apache.org/jira/browse/CALCITE-3590 Project: Calcite Issue Type: Sub-task

Re: [QUESTION] Build Calcite using Gradle

2019-11-26 Thread Shuo Cheng
elliJ and Gradle`, but it didn’t work. How should i to to debug some > unit tests? > > > Best wishes, > Trista > > > [1] > http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population > > > Juan Pan > > > panj...@apache.org > Juan Pan(Trista

Re: [QUESTION] Build Calcite using Gradle

2019-11-25 Thread Shuo Cheng
First make sure the URLs in `FileReaderTest`, e.g , en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States, can be accessed from your machine. On Tue, Nov 26, 2019 at 3:49 PM Juan Pan wrote: > Hi everyone, > > > After migrating Calcite to Gradle, i built Calcite referring to d

Re: IntelliJ and Gradle

2019-11-25 Thread Shuo Cheng
Usually, i run gradle build to solve this problem On Tue, Nov 26, 2019 at 10:03 AM Julian Hyde wrote: > After our migration to gradle, IntelliJ frequently fails to correctly load > a project. > > For example, I just switched to the amaliujia/rw-add_TVF_TUMBLE branch and > opened SqlToRelConv

[jira] [Created] (CALCITE-3527) enrich tests for sql hints.

2019-11-20 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3527: --- Summary: enrich tests for sql hints. Key: CALCITE-3527 URL: https://issues.apache.org/jira/browse/CALCITE-3527 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-3519) `inheritPath` of `RelHint` represented by `ImmutableBitSet` may be incomplete.

2019-11-18 Thread Shuo Cheng (Jira)
Shuo Cheng created CALCITE-3519: --- Summary: `inheritPath` of `RelHint` represented by `ImmutableBitSet` may be incomplete. Key: CALCITE-3519 URL: https://issues.apache.org/jira/browse/CALCITE-3519