[
https://issues.apache.org/jira/browse/IMPALA-3273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-3273:
----------------------------------
Priority: Major (was: Critical)
> LEAD and LAG do not support a column for the default value
> ----------------------------------------------------------
>
> Key: IMPALA-3273
> URL: https://issues.apache.org/jira/browse/IMPALA-3273
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend
> Affects Versions: Impala 2.2
> Reporter: David Magaha
> Priority: Major
> Labels: built-in-function
>
> The default values for the LEAD and LAG functions fails when using a column.
> ex: SELECT LEAD( column_name, 1, column_name ) FROM some_table
> This will only work if the default value is a constant.
> Here is some of the the grammar from SQL:2016:
> {noformat}
> <lead or lag function> ::=
> <lead or lag> <left paren> <lead or lag extent>
> [ <comma> <offset> [ <comma> <default expression> ] ] <right paren>
> [ <null treatment> ]
> <default expression> ::=
> <value expression>
> <value expression> ::=
> <common value expression>
> | <boolean value expression>
> | <row value expression>
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
