[ 
https://issues.apache.org/jira/browse/CALCITE-6815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yu Xu updated CALCITE-6815:
---------------------------
    Description: 
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.

  was:
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.


> 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)

Reply via email to