You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/06/21 20:29:00 UTC
[jira] [Updated] (IMPALA-6323) Support a constant in a window
specification
[ https://issues.apache.org/jira/browse/IMPALA-6323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-6323:
----------------------------------
Component/s: (was: Backend)
Frontend
> 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
> 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org