You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Jeyhun Karimov (Jira)" <ji...@apache.org> on 2024/03/10 11:05:00 UTC
[jira] [Commented] (FLINK-32367) lead function second param cause ClassCastException
[ https://issues.apache.org/jira/browse/FLINK-32367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825031#comment-17825031 ]
Jeyhun Karimov commented on FLINK-32367:
----------------------------------------
Hi [~zhou_yb] when I tried to reproduce with the current master (d6a4eb966fbc47277e07b79e7c64939a62eb1d54), the LEAD function successfully accepts and executes expression as parameter. For example, the following query works:
{code:java}
SELECT a, b, lead(b, a/2, 3) over (partition by a order by b), lag(b, 1, 3) over (partitionby a order by b) FROM Table6{code}
Could you please verify or am I missing sth?
> lead function second param cause ClassCastException
> ---------------------------------------------------
>
> Key: FLINK-32367
> URL: https://issues.apache.org/jira/browse/FLINK-32367
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.15.4
> Reporter: zhou
> Priority: Major
> Attachments: image-2023-06-16-15-49-49-003.png, image-2023-06-16-18-12-05-861.png
>
>
> !image-2023-06-16-18-12-05-861.png!!image-2023-06-16-15-49-49-003.png!
> lead function second param is expression (window_length/2),throw a exceptionÂ
> if lead function second param is number,it worked well
--
This message was sent by Atlassian Jira
(v8.20.10#820010)