[
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 NUMBER to BYTES (was: Support cast from BYTES
to DOUBLE)
> 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 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
