[
https://issues.apache.org/jira/browse/FLINK-35864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868331#comment-17868331
]
Dylan He commented on FLINK-35864:
----------------------------------
The 'INTEGER' in the description is a vague formulation taken from Databricks,
and I've made it clear in the function doc what types are actually supported
for each parameter; specifically, num supports all four integer types, while
fromBase and toBase support three integer types other than bigint, which is
consistent with spark.
If you think it's necessary to give the full type definitions inside the jira
issue, please let me know.
> Add CONV function
> -----------------
>
> Key: FLINK-35864
> URL: https://issues.apache.org/jira/browse/FLINK-35864
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dylan He
> Assignee: Dylan He
> Priority: Major
> Labels: pull-request-available
>
> Add CONV function as the same in Hive & Spark & MySQL.
> ----
> Converts {{num}} from {{fromBase}} to {{toBase}}.
> Syntax:
> {code:SQL}
> CONV(num, fromBase, toBase)
> {code}
> Arguments:
> * {{num}}: An INTEGER or STRING expression.
> * {{fromBase}}: An INTEGER expression.
> * {{toBase}}: An INTEGER expression.
> Returns:
> A STRING.
> See also:
> *
> [Hive|https://cwiki.apache.org/confluence/display/Hive/Hive+UDFs#HiveUDFs-MathematicalFunctions]
> *
> [Spark|https://spark.apache.org/docs/3.5.1/sql-ref-functions-builtin.html#conversion-functions]
> *
> [Databricks|https://docs.databricks.com/en/sql/language-manual/functions/conv.html]
> *
> [MySQL|https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html#function_conv]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
