[
https://issues.apache.org/jira/browse/FLINK-32565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-32565:
--------------------------------
Description:
We are undertaking a task that requires casting from the DOUBLE type to BYTES
In particular, we have a INTEGER 1234. Our current approach is to convert this
INTEGER to BYTES using the following SQL query:
{code:java}
SELECT CAST(1234 as BYTES);{code}
{{ }}
However, we encounter an issue when executing this query, potentially due to an
error in the conversion between INTEGER and BYTES. Our goal is to identify and
correct this issue so that our query can execute successfully. The tasks
involved are:
# Investigate and pinpoint the specific reason for the conversion failure from
INTEGER to BYTES.
# Design and implement a solution that enables our query to function correctly.
# Test this solution across all required scenarios to ensure its robustness.
was:
We are undertaking a task that requires casting from the BYTES type to DOUBLE.
In particular, we have a string '00T1p'. Our current approach is to convert
this string to BYTES and then cast the result to DOUBLE using the following SQL
query:
{code:java}
SELECT CAST((CAST('00T1p' as BYTES)) as DOUBLE);{code}
{{ }}
However, we encounter an issue when executing this query, potentially due to an
error in the conversion between BYTES and DOUBLE. Our goal is to identify and
correct this issue so that our query can execute successfully. The tasks
involved are:
# Investigate and pinpoint the specific reason for the conversion failure from
BYTES to DOUBLE.
# Design and implement a solution that enables our query to function correctly.
# Test this solution across all required scenarios to ensure its robustness.
> Support cast from NUMBER to BYTES
> ---------------------------------
>
> Key: FLINK-32565
> URL: https://issues.apache.org/jira/browse/FLINK-32565
> Project: Flink
> Issue Type: Sub-task
> Reporter: Hanyu Zheng
> Assignee: Hanyu Zheng
> Priority: Major
>
> We are undertaking a task that requires casting from the DOUBLE type to BYTES
> In particular, we have a INTEGER 1234. Our current approach is to convert
> this INTEGER to BYTES using the following SQL query:
> {code:java}
> SELECT CAST(1234 as BYTES);{code}
> {{ }}
> However, we encounter an issue when executing this query, potentially due to
> an error in the conversion between INTEGER and BYTES. Our goal is to identify
> and correct this issue so that our query can execute successfully. The tasks
> involved are:
> # Investigate and pinpoint the specific reason for the conversion failure
> from INTEGER to BYTES.
> # Design and implement a solution that enables our query to function
> correctly.
> # Test this solution across all required scenarios to ensure its robustness.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
