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.
