Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
On master,
hive> create view v as select b.key, count(*)
> from src b
> group by b.key
> having exists
> (select a.key
> from src a
> where a.key = b.key and a.value > 'val_9'
> );
View Expanded Text: select `b`.`key`, count(*) from `default`.`src` `b` group by `b`.`key` having exists (select `a`.`key` from `default`.`src` `a` where `a`.`key` = b.key and `a`.`value` > 'val_9' )
You can see that b.key is not quoted.