[ https://issues.apache.org/jira/browse/IMPALA-6323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Ho reassigned IMPALA-6323: ---------------------------------- Assignee: Michal Ostrowski > Support a constant in a window specification > -------------------------------------------- > > Key: IMPALA-6323 > URL: https://issues.apache.org/jira/browse/IMPALA-6323 > Project: IMPALA > Issue Type: Improvement > Components: Frontend > Affects Versions: Impala 2.9.0 > Reporter: N Campbell > Assignee: Michal Ostrowski > Priority: Major > > A query may attempt to generate a function/aggregate with a window > specification. > Currently, Impala does not support a constant in the specification. Similarly > it may also fail if an expression is generated which via constant folding > becomes a constant. > Potentially an application may have to trigger dynamic expressions which > participate in a window specification. It may not know that a > value-expression that is generated might be constant folded and disallowed. > Hence, while it may attempt to decompose when it knows a literal is being > used cannot guard for all cases > Error: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. > Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, > errorMessage:AnalysisException: Expressions in the PARTITION BY clause must > not be constant: upper('a') (in sum(qty) OVER (PARTITION BY upper('a'))) > ), Query: SELECT > `sno` AS `c1`, > SUM(`qty`) > OVER( > PARTITION BY > upper('a') > ) AS `c2` > FROM `cert`.`tsupply`. > SQLState: HY000 > ErrorCode: 500051 > -vs- > SELECT > `sno` AS `c1`, > SUM(`qty`) > OVER( > PARTITION BY > upper(concat(`sno`,'')) > ) AS `c2` > FROM `cert`.`tsupply` -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org