[
https://issues.apache.org/jira/browse/CALCITE-5241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17582068#comment-17582068
]
Julian Hyde commented on CALCITE-5241:
--------------------------------------
I'm familiar with a {{CHAR}} type (actually an abbreviation for
{{{}CHARACTER{}}}) but not with a {{CHAR}} function.
Postgres tends to allow type names as conversion functions, so maybe this works
on Postgres.
Can you link to documentation for the function in Hive or Spark? It doesn't
seem to be in [Hive's function
list|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf].
If it were implemented it would probably be in {{{}class
SqlLibraryOperators{}}}.
> 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)
