[
https://issues.apache.org/jira/browse/CALCITE-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Runkang He updated CALCITE-6066:
--------------------------------
Description:
Add HYPOT function (enabled in Spark library)
HYPOT: calculates the hypotenuse of a right-angle triangle. For example:
{code:sql}
SELECT hypot(3, 4);
> 5.0
{code}
See more at
[Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hypot] and
[Oracle|https://docs.oracle.com/en/middleware/fusion-middleware/osa/19.1/using/applying-functions-create-new-column.html#GUID-A6F5689E-6C6D-4FA4-B152-5A5287555C95]
doc.
Note that I have checked there is no function with the same name in
MySQL/PostgreSQL/Hive.
was:
Add HYPOT function (enabled in Spark library)
HYPOT: calculates the hypotenuse of a right-angle triangle. For example:
{code:sql}
SELECT hypot(3, 4);
> 5.0
{code}
See more at
[Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hypot] doc.
> Add HYPOT function (enabled in Spark library)
> ---------------------------------------------
>
> Key: CALCITE-6066
> URL: https://issues.apache.org/jira/browse/CALCITE-6066
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.35.0
> Reporter: Runkang He
> Assignee: Runkang He
> Priority: Major
>
> Add HYPOT function (enabled in Spark library)
> HYPOT: calculates the hypotenuse of a right-angle triangle. For example:
> {code:sql}
> SELECT hypot(3, 4);
> > 5.0
> {code}
> See more at
> [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hypot] and
> [Oracle|https://docs.oracle.com/en/middleware/fusion-middleware/osa/19.1/using/applying-functions-create-new-column.html#GUID-A6F5689E-6C6D-4FA4-B152-5A5287555C95]
> doc.
> Note that I have checked there is no function with the same name in
> MySQL/PostgreSQL/Hive.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
