[ https://issues.apache.org/jira/browse/HIVE-1124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12829369#action_12829369 ]
Zheng Shao commented on HIVE-1124: ---------------------------------- Patch line 993: {code} - ColumnInfo paraExprInfo = groupByInputRowResolver.get("", text); + ColumnInfo paraExprInfo = groupByInputRowResolver.get("", entry.getKey()); {code} Shall we use getExpression? Otherwise it looks good. > 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 > Fix For: 0.6.0 > > 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.