[
https://issues.apache.org/jira/browse/FLINK-32565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-32565:
--------------------------------
Summary: Support cast from BYTES to DOUBLE (was: Support cast BYTES to
DOUBLE)
> Support cast from 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)
