hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7693) Invalid column ref error in order by when using column alias in select clause and using having
Date Thu, 19 Nov 2015 22:40:11 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sergey Shelukhin updated HIVE-7693:
-----------------------------------
    Fix Version/s:     (was: 2.0.0)

Removing fixed version (2.0) from Unresolved JIRA in preparation for the release. Please use
target version field instead (if not already set) if you think this should be shipped as part
of 2.0

> Invalid column ref error in order by when using column alias in select clause and using
having
> ----------------------------------------------------------------------------------------------
>
>                 Key: HIVE-7693
>                 URL: https://issues.apache.org/jira/browse/HIVE-7693
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.13.0
>            Reporter: Deepesh Khandelwal
>            Assignee: Pengcheng Xiong
>         Attachments: HIVE-7693.01.patch, HIVE-7693.02.patch, HIVE-7693.03.patch, HIVE-7693.04.patch,
HIVE-7693.05.patch, HIVE-7693.06.patch, HIVE-7693.07.patch
>
>
> Hive CLI session:
> {noformat}
> hive> create table abc(foo int, bar string);
> OK
> Time taken: 0.633 seconds
> hive> select foo as c0, count(*) as c1 from abc group by foo, bar having bar like
'%abc%' order by foo;
> FAILED: SemanticException [Error 10004]: Line 1:93 Invalid table alias or column reference
'foo': (possible column names are: c0, c1)
> {noformat}
> Without having clause, the query runs fine, example:
> {code}
> select foo as c0, count(*) as c1 from abc group by foo, bar order by foo;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message