hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-1124) create view should expand the query text consistently
Date Wed, 03 Feb 2010 23:03:27 GMT

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

John Sichi updated HIVE-1124:
-----------------------------

    Attachment: HIVE-1124.1.patch

The problem turned out to be with the way we resolve common subexpressions for matching expressions
in the SELECT list and GROUP BY.  As soon as we saw the match, we were skipping over the SELECT
item subtree without performing any translations, leading to the inconsistency later on when
the view was referenced.

The fix in this patch is a bit involved, since I had to make the UnparseTranslator capable
of copying the translations for the common subexpressions.

I have not yet run through all tests yet, but the patch is available for review now.


> create view should expand the query text consistently
> -----------------------------------------------------
>
>                 Key: HIVE-1124
>                 URL: https://issues.apache.org/jira/browse/HIVE-1124
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.6.0
>            Reporter: Zheng Shao
>            Assignee: John Sichi
>         Attachments: HIVE-1124.1.patch
>
>
> We should expand the omitted alias in the same way in "select" and in "group by".
> Hive "Group By" recognize "group by" expressions by comparing the literal string.
> {code}
> hive> create view zshao_view as select d, count(1) as cnt from zshao_tt group by d;
> OK
> Time taken: 0.286 seconds
> hive> select * from zshao_view;
> FAILED: Error in semantic analysis: line 1:7 Expression Not In Group By Key d in definition
of VIEW zshao_view [
> select d, count(1) as `cnt` from `zshao_tt` group by `zshao_tt`.`d`
> ] used as zshao_view at line 1:14
> {code}
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message