[
https://issues.apache.org/jira/browse/FLINK-32564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-32564:
--------------------------------
Description:
We are dealing with a task that requires casting from the BYTES type to BIGINT.
Specifically, we have a string '00T1p'. 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('00T1p' 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.
was:
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.
> Support cast from BYTES to BIGINT
> ---------------------------------
>
> Key: FLINK-32564
> URL: https://issues.apache.org/jira/browse/FLINK-32564
> Project: Flink
> Issue Type: Sub-task
> Reporter: Hanyu Zheng
> Priority: Major
>
> We are dealing with a task that requires casting from the BYTES type to
> BIGINT. Specifically, we have a string '00T1p'. 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('00T1p' 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)
