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 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.