[
https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-5827:
----------------------------------
Description:
BigQuery offers the
[IS_INF|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf]
and
[IS_NAN|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_nan]
functions. The first returns whether the specified value is infinite, the
second returns whether the specified value is {{NaN}}.
Example 1: {{SELECT IS_INF(3)}} would return {{FALSE}}.
Example 2: {{SELECT IS_INF(CAST('Infinity` AS DOUBLE))}} would return {{TRUE}}.
Example 3: {{SELECT IS_NAN(3)}} would return {{FALSE}}.
Example 4: {{SELECT IS_INF(CAST('NaN' AS DOUBLE))}} would return {{TRUE}}.
was:
BigQuery offers the
[IS_INF|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf]
and
[IS_NAN|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_nan]
functions. The first returns whether the specified value is infinite, the
second returns whether the specified value is `NaN`.
Example 1: {{SELECT IS_INF(3)}} would return {{FALSE}}.
Example 2: {{SELECT IS_INF(CAST('Infinity` AS DOUBLE))}} would return {{TRUE}}.
Example 3: {{SELECT IS_NAN(3)}} would return {{FALSE}}.
Example 4: {{SELECT IS_INF(CAST('NaN' AS DOUBLE))}} would return {{TRUE}}.
> Add IS_INF and IS_NAN functions (enabled in BigQuery library)
> -------------------------------------------------------------
>
> Key: CALCITE-5827
> URL: https://issues.apache.org/jira/browse/CALCITE-5827
> Project: Calcite
> Issue Type: New Feature
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
>
> BigQuery offers the
> [IS_INF|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf]
> and
> [IS_NAN|https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_nan]
> functions. The first returns whether the specified value is infinite, the
> second returns whether the specified value is {{NaN}}.
> Example 1: {{SELECT IS_INF(3)}} would return {{FALSE}}.
> Example 2: {{SELECT IS_INF(CAST('Infinity` AS DOUBLE))}} would return
> {{TRUE}}.
> Example 3: {{SELECT IS_NAN(3)}} would return {{FALSE}}.
> Example 4: {{SELECT IS_INF(CAST('NaN' AS DOUBLE))}} would return {{TRUE}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
