You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2020/11/01 17:52:00 UTC

[jira] [Updated] (CALCITE-4369) COUNTIF support for BigQuery

     [ https://issues.apache.org/jira/browse/CALCITE-4369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde updated CALCITE-4369:
---------------------------------
    Description: 
Example:

{{select countif(x > 0) from (select 1 as x, 2 as y, 3 as z)}}

Should work in BigQuery function table (i.e. {{fun=bigquery}} on the JDBC connect string). The implementation should translates {{countif(condition)}} as if the user had written {{count\(*) filter (where condition)}}.

  was:
Example:

{{select countif(x > 0) from (select 1 as x, 2 as y, 3 as z)}}


> COUNTIF support for BigQuery
> ----------------------------
>
>                 Key: CALCITE-4369
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4369
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Aryeh Hillman
>            Assignee: Julian Hyde
>            Priority: Major
>             Fix For: 1.27.0
>
>
> Example:
> {{select countif(x > 0) from (select 1 as x, 2 as y, 3 as z)}}
> Should work in BigQuery function table (i.e. {{fun=bigquery}} on the JDBC connect string). The implementation should translates {{countif(condition)}} as if the user had written {{count\(*) filter (where condition)}}.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)