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

[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 <
> 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 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().
>>
>> Can anybody help me in knowing the reason behind this?
>>
>> Thank you
>>
>> --
>>
>> Regards,
>> *Sonam*
>> Software Engineer
>> Mobile: +92 3088337296 <+92%20308%208337296>
>>
>> 
>>
>

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

[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 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().
>
> Can anybody help me in knowing the reason behind this?
>
> Thank you
>
> --
>
> Regards,
> *Sonam*
> Software Engineer
> Mobile: +92 3088337296 <+92%20308%208337296>
>
> 
>