Hi  Devs,

I am trying to implement the COUNTIF  function for Beam SQL ZetaSQL
dialect, as CombineFn.

Where I try to run the Test query (SELECT COUNTIF(f_long > 0) AS countif_no
FROM PCOLLECTION GROUP BY f_int2), I am getting Exception
Caused by:
org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.validate.SqlValidatorException:
No match found for function signature COUNTIF(<BOOLEAN>).

Can anybody help me in knowing the reason behind this?

Thank you

-- 

Regards,
*Sonam*
Software Engineer
Mobile: +92 3088337296

<http://venturedive.com/>

Reply via email to