[HIVE-1124] CREATE VIEW should expand the query text consistently

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.6.0
• Hadoop Flags: Reviewed
• Assignee: John Sichi
• Reporter: Zheng Shao
• Created: 02/Feb/10 08:26
• Updated: 17/Dec/11 00:03
• Resolved: 04/Feb/10 19:43

Description

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.

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

Issue Links

• relates to: HIVE-972 Support views