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

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. >

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

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

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.