Clemens Valiente created HIVE-12886:
---------------------------------------
Summary: 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)
