[ https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934112#comment-17934112 ]
Yu Xu edited comment on CALCITE-6815 at 3/11/25 6:28 AM: --------------------------------------------------------- Thanks for [~julianhyde] reminder, 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 was (Author: JIRAUSER307770): 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)