Hanyu Zheng created FLINK-32564:
-----------------------------------
Summary: Support cast BYTES to BIGINT
Key: FLINK-32564
URL: https://issues.apache.org/jira/browse/FLINK-32564
Project: Flink
Issue Type: Sub-task
Reporter: Hanyu Zheng
We are dealing with a task that requires casting from the BYTES type to BIGINT.
Specifically, we have a string '00T1p000029eYmpEAE'. Our approach is to convert
this string to BYTES and then cast the result to BIGINT with the following SQL
query:
{code:java}
SELECT CAST((CAST('00T1p000029eYmpEAE' as BYTES)) as BIGINT);{code}
However, an issue arises when executing this query, likely due to an error in
the conversion between BYTES and BIGINT. We aim to identify and rectify this
issue so our query can run correctly. The tasks involved are:
# Investigate and identify the specific reason for the failure of conversion
from BYTES to BIGINT.
# Design and implement a solution to ensure our query can function correctly.
# Test this solution across all required scenarios to guarantee its
functionality.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
