Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5098

Correct handling of DISTINCT in the select list

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.6.0
    • Fix Version/s: None
    • Component/s: Frontend

      Description

      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.
      

        Attachments

          Activity

            People

            • Assignee:
              kdeschle Kurt Deschler
              Reporter:
              the6campbells N Campbell
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated: