You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/03/19 18:54:41 UTC
[jira] [Created] (IMPALA-5098) support projection combining SELECT
DISTINCT and analytic function
N Campbell created IMPALA-5098:
----------------------------------
Summary: support projection combining SELECT DISTINCT and analytic function
Key: IMPALA-5098
URL: https://issues.apache.org/jira/browse/IMPALA-5098
Project: IMPALA
Issue Type: Improvement
Components: Backend
Affects Versions: Impala 2.6.0
Reporter: N Campbell
DB2, ORACLE and various other systems will support the following statement but Impala will not
[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: cannot combine SELECT DISTINCT with analytic functions
), Query: SELECT DISTINCT
`sno` AS `c1`,
`pno` AS `c2`,
SUM(`qty`)
OVER(
) AS `c3`
FROM
`cert`.`tsupply`
ORDER BY
`sno` ASC NULLS LAST,
`pno` ASC NULLS LAST.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)