You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Clemens Valiente (JIRA)" <ji...@apache.org> on 2016/01/18 18:53:39 UTC

[jira] [Created] (HIVE-12886) invalid column reference error on grouping by constant

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)