You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Zou (Jira)" <ji...@apache.org> on 2023/03/21 15:30:00 UTC
[jira] [Updated] (CALCITE-5599) Support more trigonometric functions for BigQuery
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zou updated CALCITE-5599:
-------------------------
Description:
We have already supported many trigonometric functions in calcite, such as SIN, COS, and there are still some trigonometric functions in BigQuery not supported:
* ACOSH(X):Computes the inverse hyperbolic cosine of X.
* COTH(X): Computes the hyperbolic cotangent for the angle of {{{}X{}}}, where {{X}} is specified in radians.
* CSC(X): Computes the cosecant of the input angle, which is in radians.
* CSCH(X): Computes the hyperbolic cosecant of the input angle, which is in radians.
* SEC(X): Computes the secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
* SECH(X): Computes the hyperbolic secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
More info could be found in [BigQuery Doc|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#acosh]
This is an umbrella issue, and I will create subtasks for each function listed above later.
was:
We have already supported many trigonometric functions in calcite, such as SIN, COS, and there are still some trigonometric functions in BigQuery not supported:
* ACOSH(X):Computes the inverse hyperbolic cosine of X.
* COTH(X): Computes the hyperbolic cotangent for the angle of {{{}X{}}}, where {{X}} is specified in radians.
* CSC(X): Computes the cosecant of the input angle, which is in radians.
* CSCH(X): Computes the hyperbolic cosecant of the input angle, which is in radians.
*
SEC(X): Computes the secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
* SECH(X): Computes the hyperbolic secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
More info could be found in [BigQuery Doc|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#acosh]
This is an umbrella issue, and I will create subtasks for each function listed above later.
> Support more trigonometric functions for BigQuery
> -------------------------------------------------
>
> Key: CALCITE-5599
> URL: https://issues.apache.org/jira/browse/CALCITE-5599
> Project: Calcite
> Issue Type: New Feature
> Reporter: Zou
> Assignee: Zou
> Priority: Major
>
> We have already supported many trigonometric functions in calcite, such as SIN, COS, and there are still some trigonometric functions in BigQuery not supported:
> * ACOSH(X):Computes the inverse hyperbolic cosine of X.
> * COTH(X): Computes the hyperbolic cotangent for the angle of {{{}X{}}}, where {{X}} is specified in radians.
> * CSC(X): Computes the cosecant of the input angle, which is in radians.
> * CSCH(X): Computes the hyperbolic cosecant of the input angle, which is in radians.
> * SEC(X): Computes the secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
> * SECH(X): Computes the hyperbolic secant for the angle of {{{}X{}}}, where {{X}} is specified in radians.
> More info could be found in [BigQuery Doc|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#acosh]
> This is an umbrella issue, and I will create subtasks for each function listed above later.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)