hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clemens Valiente (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12886) invalid column reference error on grouping by constant
Date Mon, 18 Jan 2016 17:53:39 GMT
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)

Mime
View raw message