Hi,you Zhuang I find clacite have SqlIfFunction,but it don't accomplish.
you Zhuang 于2021年2月21日周日 上午2:39写道:
> when does calcite support count(if(a=1, 1, null)) syntax ? spark, hive,
> clickhouse, impala, presto support the syntax for a long time.
>
a WHEN 1 THEN 1 END)
* COUNT(CASE WHEN a = 1 THEN 1 END)
* COUNTIF(a = 1) // from 1.27, and only in the BigQuery dialect
Julian
On Sat, Feb 20, 2021 at 10:39 AM you Zhuang wrote:
>
> when does calcite support count(if(a=1, 1, null)) syntax ? spark, hive,
> clickhouse, impala, prest
when does calcite support count(if(a=1, 1, null)) syntax ? spark, hive,
clickhouse, impala, presto support the syntax for a long time.