[ 
https://issues.apache.org/jira/browse/IMPALA-13482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896746#comment-17896746
 ] 

ASF subversion and git services commented on IMPALA-13482:
----------------------------------------------------------

Commit 453c9519bcadb64d8ad5a131c8d031a457dd4d22 in impala's branch 
refs/heads/master from Steve Carlin
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=453c9519b ]

IMPALA-13482: Bug fixes for lag/coalesce in analytic function.

The following SQL query in analytics.test ...

select lag(coalesce(505, 1 + NULL), 1) over (order by int_col desc)
from alltypestiny

... had a couple of issues

1) The coalesce function needed a special operator. This function
derives its return type from a common type that works for all
parameters.

2) The function was not being saved when being reset. This is
needed for when resetAnalysisState is called.

3) createNullLiteral needed to be overriden for similar reasons.
The null literal type needs to be saved for when
resetAnalysisState is called.

Change-Id: Ic54d955a73cec4b5f421099a74df4172a1b7dd8b
Reviewed-on: http://gerrit.cloudera.org:8080/22024
Reviewed-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Michael Smith <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Calcite planner: Bug fixes for an analytics.test
> ------------------------------------------------
>
>                 Key: IMPALA-13482
>                 URL: https://issues.apache.org/jira/browse/IMPALA-13482
>             Project: IMPALA
>          Issue Type: Sub-task
>    Affects Versions: Impala 4.5.0
>            Reporter: Steve Carlin
>            Priority: Major
>             Fix For: Impala 4.5.0
>
>
> Specifically, 
> select lag(coalesce(505, 1 + NULL), 1) over (order by int_col desc)
> from alltypestiny
> had a couple of issues that needed fixing



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to