You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2023/06/15 05:54:00 UTC

[jira] [Commented] (CALCITE-5782) Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)

    [ https://issues.apache.org/jira/browse/CALCITE-5782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17732857#comment-17732857 ] 

Julian Hyde commented on CALCITE-5782:
--------------------------------------

Please be sure to use Calcite’s type names when describing functions like this - VARBINARY and VARCHAR rather than BYTES and STRING. We want them to be usable by people who are not running in BigQuery mode. You can mention BigQuery’s type names as long as you qualify them. 

> Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)
> ---------------------------------------------------------------
>
>                 Key: CALCITE-5782
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5782
>             Project: Calcite
>          Issue Type: New Feature
>            Reporter: Dan Zou
>            Assignee: Dan Zou
>            Priority: Major
>
> Add TO_HEX and FROM_HEX functions (enabled in BigQuery library)
> * TO_HEX: Converts a sequence of {{BYTES}} into a hexadecimal {{{}STRING{}}}. 
> * FROM_HEX: Converts a hexadecimal-encoded {{STRING}} into {{BYTES}} format
> See more details in BigQuery doc [TO_HEX|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_hex], [FROM_HEX|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#from_hex]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)