[
https://issues.apache.org/jira/browse/IMPALA-5098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dinesh Garg reassigned IMPALA-5098:
-----------------------------------
Assignee: Kurt Deschler
> Correct handling of DISTINCT in the select list
> -----------------------------------------------
>
> Key: IMPALA-5098
> URL: https://issues.apache.org/jira/browse/IMPALA-5098
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.6.0
> Reporter: N Campbell
> Assignee: Kurt Deschler
> Priority: Critical
> Labels: ansi-sql, sql-language
>
> DB2, ORACLE and various other systems will support the following statement
> but Impala will not
> {noformat}
> [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.
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
