Hanyu Zheng created FLINK-32565:
-----------------------------------
Summary: 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
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)
