[HIVE-12886] invalid column reference error on grouping by constant

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.3.0, 2.1.0
• Assignee: Yongzhi Chen
• Reporter: Clemens Valiente
• Created: 18/Jan/16 17:53
• Updated: 21/Jun/16 15:53
• Resolved: 27/Jan/16 18:53

Description

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

returns
Error: Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 16:2 Invalid column reference 'b' (state=42000,code=10002)

Issue Links

• relates to: HIVE-12784 Group by SemanticException: Invalid column reference