[ https://issues.apache.org/jira/browse/HIVE-12886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15108924#comment-15108924 ]
Yongzhi Chen commented on HIVE-12886: ------------------------------------- [~cvaliente], it should be the same issue as HIVE-12784 , it is fixed in the master branch. > invalid column reference error on grouping by constant > ------------------------------------------------------ > > Key: HIVE-12886 > URL: https://issues.apache.org/jira/browse/HIVE-12886 > Project: Hive > Issue Type: Bug > Affects Versions: 1.1.0 > Reporter: Clemens Valiente > > {code:sql} > CREATE TABLE some_table (c INT); > WITH t1 AS ( > SELECT > 0 AS a, > 0 AS b > FROM > some_table > ) > SELECT > a, > b, > count(1) AS cnt > FROM > t1 > GROUP BY > a, > b > {code} > returns > Error: Error while compiling statement: FAILED: SemanticException \[Error > 10002\]: Line 16:2 Invalid column reference 'b' (state=42000,code=10002) -- This message was sent by Atlassian JIRA (v6.3.4#6332)