[
https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934112#comment-17934112
]
Yu Xu commented on CALCITE-6815:
--------------------------------
Thanks for [~julianhyde] remind, I added an exaplme in descrpition and update:
*hive> select bin(12);*
*OK*
*1100*
*Time taken: 2.857 seconds, Fetched: 1 row(s)*
argument type is long type and return a string type.
the type is 'binary array string' is just a string
> Support bin function for Spark and Hive Library
> -----------------------------------------------
>
> Key: CALCITE-6815
> URL: https://issues.apache.org/jira/browse/CALCITE-6815
> Project: Calcite
> Issue Type: Improvement
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
>
> Currently calcite not support bin functions for Hive and Spark Library, need
> to support it.
> related Hive links:
> [https://hive.apache.org/docs/latest/hive-udfs_282102277/#mathematical-functions]
> Spark：[https://spark.apache.org/docs/latest/api/sql/index.html#bin]
> usage: select bin(long type)
> return binary array string.
> *example:*
> hive> select bin(12);
> OK
> 1100
> Time taken: 2.857 seconds, Fetched: 1 row(s)
>
> arg type is long type and return a string type.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
