You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Harish Butani (JIRA)" <ji...@apache.org> on 2013/11/08 20:44:17 UTC
[jira] [Commented] (HIVE-5784) Group By Operator doesn't carry
forward table aliases in its RowResolver
[ https://issues.apache.org/jira/browse/HIVE-5784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13817617#comment-13817617 ]
Harish Butani commented on HIVE-5784:
-------------------------------------
Review request: https://reviews.apache.org/r/15361/
> 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)