[
https://issues.apache.org/jira/browse/HIVE-24908?focusedWorklogId=570242&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-570242
]
ASF GitHub Bot logged work on HIVE-24908:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 23/Mar/21 05:31
Start Date: 23/Mar/21 05:31
Worklog Time Spent: 10m
Work Description: kasakrisz merged pull request #2091:
URL: https://github.com/apache/hive/pull/2091
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 570242)
Time Spent: 20m (was: 10m)
> Adding Respect/Ignore nulls as a UDAF parameter is ambiguous
> ------------------------------------------------------------
>
> Key: HIVE-24908
> URL: https://issues.apache.org/jira/browse/HIVE-24908
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Both function calls translated to the same UDAF call:
> {code}
> SELECT lead(a, 2, true) ...
> SELECT lead(a, 2) IGNORE NULLS ...
> {code}
> IGNORE NULLS is passed as an extra constant boolean parameter to the UDAF
> https://github.com/apache/hive/blob/eed78dfdcb6dfc2de400397a60de12e6f62b96e2/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java#L743
> However the semantics of the two function calls has different semantics:
> * *lead(a, 2, true)* - 'true' is the default value: "The value of DEFAULT is
> returned as the result if there is no row corresponding to the OFFSET number
> of rows before R within P (for the lag function) or after R within P (for the
> lead function)"
> * *lead(a, 2) IGNORE NULLS* - For each row in the current window find the 2nd
> not-NULL value starting directly after the current row.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
