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