hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5784) Group By Operator doesn't carry forward table aliases in its RowResolver
Date Fri, 08 Nov 2013 19:56:17 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13817630#comment-13817630
] 

Xuefu Zhang commented on HIVE-5784:
-----------------------------------

[~rhbutani] This seems a dupe of HIVE-3107, which keeps the previous discussions. There is
no point to keep two. Feel free to close this one and take that one if you're are going to
work on this now.

> Group By Operator doesn't carry forward table aliases in its RowResolver
> ------------------------------------------------------------------------
>
>                 Key: HIVE-5784
>                 URL: https://issues.apache.org/jira/browse/HIVE-5784
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>         Attachments: HIVE-5784.1.patch
>
>
> The following queries fails:
> {code}
> select b.key, count(*) from src b group by key
> select key, count(*) from src b group by b.key
> {code}
> with a SemanticException; the select expression b.key (key in the 2nd query) are not
resolved by the GBy RowResolver.
> This is because the GBy RowResolver only supports resolving based on an AST.toStringTree
match. Underlying issue is that a RowResolver doesn't allow multiple mappings to the same
ColumnInfo.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message