[
https://issues.apache.org/jira/browse/CALCITE-6065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Runkang He updated CALCITE-6065:
--------------------------------
Description:
Add HEX and UNHEX functions (enabled in Hive and Spark library)
* HEX: Converts a BIGINT/CHARACTER/BINARY into a hexadecimal CHARACTER.
* UNHEX: Converts a hexadecimal-encoded CHARACTER into BINARY format.
Note that currently we have supported TO_HEX and FROM_HEX function in BigQuery
library. These are two similar functions compared to HEX and UNHEX in Hive and
Spark libraries. The similarities and differences are below:
UNHEX and FROM_HEX have the same logic.
HEX can convert BIGINT/CHARACTER/BINARY value, while TO_HEX can only convert
BINARY value. HEX returns upper case of hexadecimal CHARACTER, while TO_HEX
returns lower case ones.
See more about HEX in
[Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hex] doc,
and UNHEX in
[Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#unhex] doc.
was:
Add HEX and UNHEX functions (enabled in Hive and Spark library)
* HEX: Converts a BIGINT/CHARACTER/BINARY into a hexadecimal CHARACTER.
* UNHEX: Converts a hexadecimal-encoded CHARACTER into BINARY format.
Note that currently we have supported _TO_HEX and FROM_HEX function in BigQuery
library. These are two similar functions compared to HEX and_ _UNHEX_ _in_
_Hive_ _and Spark libraries. The similarities and differences are below:_
_UNHEX_ _and FROM_HEX have the same logic._
HEX can convert BIGINT/CHARACTER/BINARY value, while _TO_HEX can only convert
BINARY value._ _HEX_ _returns upper case of hexadecimal CHARACTER, while TO_HEX
returns lower case ones._
_See more about HEX in
[Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hex] doc,
and UNHEX in
[Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#unhex] doc._
> Add HEX and UNHEX functions (enabled in Hive and Spark library)
> ---------------------------------------------------------------
>
> Key: CALCITE-6065
> URL: https://issues.apache.org/jira/browse/CALCITE-6065
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.35.0
> Reporter: Runkang He
> Assignee: Runkang He
> Priority: Major
>
> Add HEX and UNHEX functions (enabled in Hive and Spark library)
> * HEX: Converts a BIGINT/CHARACTER/BINARY into a hexadecimal CHARACTER.
> * UNHEX: Converts a hexadecimal-encoded CHARACTER into BINARY format.
>
> Note that currently we have supported TO_HEX and FROM_HEX function in
> BigQuery library. These are two similar functions compared to HEX and UNHEX
> in Hive and Spark libraries. The similarities and differences are below:
>
> UNHEX and FROM_HEX have the same logic.
> HEX can convert BIGINT/CHARACTER/BINARY value, while TO_HEX can only convert
> BINARY value. HEX returns upper case of hexadecimal CHARACTER, while TO_HEX
> returns lower case ones.
>
> See more about HEX in
> [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
> and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hex] doc,
> and UNHEX in
> [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-MathematicalFunctions]
> and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#unhex]
> doc.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
