[
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 BYTES type to DOUBLE.
In particular, we have a string '00T1p000029eYmpEAE'. 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('00T1p000029eYmpEAE' 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.
was:
We are undertaking a task that requires casting from the BYTES type to DOUBLE.
In particular, we have a string '00T1p000029eYmpEAE'. 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('00T1p000029eYmpEAE' 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 BYTES to DOUBLE
> ----------------------------
>
> Key: FLINK-32565
> URL: https://issues.apache.org/jira/browse/FLINK-32565
> Project: Flink
> Issue Type: Sub-task
> Reporter: Hanyu Zheng
> Priority: Major
>
> We are undertaking a task that requires casting from the BYTES type to
> DOUBLE. In particular, we have a string '00T1p000029eYmpEAE'. 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('00T1p000029eYmpEAE' 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
