[
https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17814696#comment-17814696
]
EveyWu commented on CALCITE-6241:
----------------------------------
[~hongyuguo]
thanks for your advice，Comparing the duplicated PR,
the following additional functions are added
* DATE_FROM_UNIX_DATE
* TIMESTAMP_MICROS
* TIMESTAMP_MILLIS
* TIMESTAMP_SECONDS
And other functions are not included. The main differences are as follows:
* {*}CONVERT_TIMEZONE{*}: OperandType not matched, Spark
CONVERT_TIMEZONE([sourceTz, ]targetTz, sourceTs), PostgreSQL
CONVERT_TIMEZONE(tz1, tz2, datetime)
* {*}SPLIT{*}: OperandType not matched, Spark SPLIT(str, regex, limit),
BigQuery SPLIT(string [, delimiter]);
* {*}REGEXP_REPLACE{*}: OperandType not matched, Spark REGEXP_REPLACE(str,
regexp, rep[, position]), BigQuery REGEXP_REPLACE(value, regexp, rep [, pos [,
occurrence [, matchType]]]);
* {*}CONCAT_WS{*}：OperandType not matched, Spark CONCAT_WS(sep[, str |
array(str)]+), MySQL&PostgreSQL CONCAT_WS(separator, str1 [, string ]*);
* {*}TO_DATE{*}: OperandType not matched, Spark TO_DATE(date_str[, fmt]),
PostgreSQL TO_DATE(string1, string2);
* {*}TO_TIMESTAMP{*}: OperandType not matched;
* {*}CHR{*}: Spark returns ASCII code, same as CHAR, BigQuery returns UTF-8
code;
* {*}LOG{*}: OperandType not matched, Spark log(base, expr), BigQuery
LOG(value [, value2]);
> Enable a few existing functions to Spark library
> ------------------------------------------------
>
> Key: CALCITE-6241
> URL: https://issues.apache.org/jira/browse/CALCITE-6241
> Project: Calcite
> Issue Type: Improvement
> Reporter: EveyWu
> Priority: Minor
> Labels: pull-request-available
> Attachments: image-2024-02-06-17-11-31-144.png
>
>
> Add Spark as a supported library for functions that have already been
> implemented for other libraries.
> Spark Functions
> Link：[https://spark.apache.org/docs/latest/api/sql/index.html|https://spark.apache.org/docs/latest/api/sql/index.html#rtrim]
> Enable function List：
> * DECODE
> * NVL
> * IFNULL
> * LEN
> * LENGTH
> * LPAD
> * RPAD
> * LTRIM
> * RTRIM
> * ENDSWITH
> * STARTSWITH
> * GREATEST
> * LEAST
> * TRANSLATE
> * BOOL_AND
> * BOOL_OR
> * DATE_FROM_UNIX_DATE
> * UNIX_DATE
> * LEFT
> * REPEAT
> * RIGHT
> * SPACE
> * TIMESTAMP_SECONDS
> * TIMESTAMP_MILLIS
> * TIMESTAMP_MICROS
> * UNIX_SECONDS
> * UNIX_MILLIS
> * UNIX_MICROS
> * MD5
> * SHA1
> * POW
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
