[jira] [Created] (IMPALA-6322) Group by expression fails when expression includes a CAST

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created IMPALA-6322:
----------------------------------

             Summary: Group by expression fails when expression includes a CAST
                 Key: IMPALA-6322
                 URL: https://issues.apache.org/jira/browse/IMPALA-6322
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 2.9.0
            Reporter: N Campbell


Impala 2.5 thru 2.9 will fail to execute a Group by when it includes an expression which also includes a includes CAST.

*Fails*
SELECT
    `sno` AS `SNO`, 
    upper( cast(`pno` as varchar(32)) ) AS `PNO`
FROM
    `cert`.`tsupply` 
GROUP BY 
    `sno`, 
    upper ( cast(`pno` as varchar(32)) )

Error: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?): upper(CAST(pno AS VARCHAR(32)))
), Query: SELECT
    `sno` AS `SNO`, 
    upper( cast(`pno` as varchar(32)) ) AS `PNO`
FROM
    `cert`.`tsupply` 
GROUP BY 
    `sno`, 
    upper ( cast(`pno` as varchar(32)) ).
SQLState:  HY000
ErrorCode: 500051

*Works*

SELECT
    `sno` AS `SNO`, 
    upper(pno) AS `PNO`
FROM
    `cert`.`tsupply` 
GROUP BY 
    `sno`, 
    upper(pno)

SELECT distinct
    `sno` AS `SNO`, 
    upper( cast(`pno` as varchar(32)) ) AS `PNO`
FROM
    `cert`.`tsupply` 

select `SNO`, `PNO` from (
	SELECT
		`sno` AS `SNO`, 
		upper( cast(`pno` as varchar(32)) ) AS `PNO`
    FROM `cert`.`tsupply` 
) T
GROUP BY 
    `SNO`,
   `PNO`




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)