hsyuan

Results 22 comments of hsyuan

Orca generated redundant motion for hash distributed table

But orca generated plan without broadcast motion: ``` explain select * from test5, test6 where test5.col2=test6.col2; QUERY PLAN ------------------------------------------------------------------------------- Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..862.00 rows=5 width=18) -> Hash...

Orca failed to generate plan for correlated scalar subquery

And why are there 2 limit node in planner's subplan?

Subquery that has outer reference over constant table falls back to planner

Should it be `limit 1 offset 10` instead of `limit 10 offset 1`? Just checked, it doesn't matter.

[CALCITE-2772] Support varargs UDF for scalar function

Can you create a JIRA for this and link this PR with JIRA?

[CALCITE-2772] Support varargs UDF for scalar function

Sorry, I found the JIRA: https://issues.apache.org/jira/browse/CALCITE-2772

[CALCITE-2772] Support varargs UDF for scalar function

Another example is [ST_Reclass](https://postgis.net/docs/RT_ST_Reclass.html) in PostGIS. Variable argument function is helpful.

[CALCITE-3088] Multi-groupsets query failed due to data type preservation check

I will find time to take a look.

[CALCITE-3352] ProjectToWindowRule sets wrong collation on generated Window

BTW, I think the plan in the test case is wrong.

[CALCITE-3352] ProjectToWindowRule sets wrong collation on generated Window

Can you rebase on latest master and adopt @jinxing64 's suggestion?

[CALCITE-3298] Add getSelectivity for TableScan in RelMdSelectivity

@shenh062326 I don't think the failed test is related with your change.