[
https://issues.apache.org/jira/browse/CALCITE-5241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17582434#comment-17582434
]
Jiajun Xie commented on CALCITE-5241:
-------------------------------------
[~julianhyde] , there are a similar function in [Hive's function
list:|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf]
|string|chr(bigint\|double A)|Returns the ASCII character having the binary
equivalent to A (as of Hive 1.3.0 and 2.1.0). If A is larger than 256 the
result is equivalent to chr(A % 256). Example: select chr(88); returns "X".|
I found that char function in appendix D.2 of the [JDBC 4.1
specification|https://download.oracle.com/otn-pub/jcp/jdbc-4_1-mrel-spec/jdbc4.1-fr-spec.pdf].
{code:java}
CHAR(code) Character with ASCII code value code, where code is between 0 and
255 {code}
Why we haven't implemented ? I want to fix it.
> calcite can't support function of char(n) or {fn CHAR(string)}
> --------------------------------------------------------------
>
> Key: CALCITE-5241
> URL: https://issues.apache.org/jira/browse/CALCITE-5241
> Project: Calcite
> Issue Type: Wish
> Components: core
> Reporter: pengfei.zhan
> Priority: Major
>
> Spark and hive support `char\(n\)`, however, calcite doesn't support it. Is
> there any message I missed?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
