Re: Add cross-join suppression to JoinAssociateRule

Thank you for the feedback. I'll try to prototype it for all the affected rules. Regards, Vladimir чт, 18 февр. 2021 г. в 13:02, Stamatis Zampetakis : > Hi Vladimir, > > Thanks for bringing up this topic. > > There are various works who highlight the importance of cartesian products > for optima

count(if(a=1, 1, null)) syntax support

when does calcite support count(if(a=1, 1, null)) syntax ? spark, hive, clickhouse, impala, presto support the syntax for a long time.

Re: [DISCUSS] Towards Avatica 1.18.0

Hi Francis, all, I saw Stamatis' comment under https://github.com/apache/calcite-avatica/pull/105 (CALCITE-3163) asking to add unit-tests to avoid regressions, I have added them and opened a complementing PR which you can find here https://github.com/apache/calcite-avatica/pull/139. Best regards,

Re: count(if(a=1, 1, null)) syntax support

IF was added in https://issues.apache.org/jira/browse/CALCITE-3731 and will be part of 1.27 release. IF is a dialect-specific function, enabled in bigquery, hive and spark function tables. There are several other ways you can achieve the same effect: * COUNT(*) FILTER (WHERE a = 1) * COUNT(CASE