Re: Problem being encountered while running the Query with COUNTIF function

2020-11-12 Thread Kyle Weaver
COUNTIF was not defined properly. See my response to the other thread (let's continue discussion there to avoid context fragmentation). On Thu, Nov 12, 2020 at 10:16 AM Ahmet Altay wrote: > +Kenneth Knowles +Andrew Pilloud > +Robin > Qiu > > On Thu, Nov 12, 2020 at 9:32 AM Sonam Ramchand <

Re: Problem being encountered while running the Query with COUNTIF function

2020-11-12 Thread Ahmet Altay
+Kenneth Knowles +Andrew Pilloud +Robin Qiu On Thu, Nov 12, 2020 at 9:32 AM Sonam Ramchand < sonam.ramch...@venturedive.com> wrote: > 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

Problem being encountered while running the Query with COUNTIF function

2020-11-12 Thread Sonam Ramchand
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: