[jira] [Updated] (FLINK-32565) Support cast from BYTES to DOUBLE

["Hanyu Zheng (Jira)" <ji...@apache.org>]

     [ 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)