Pengcheng Xiong created HIVE-15845:
--------------------------------------
Summary: create view on subquery_exists_having may not work well
with unparseTranslator
Key: HIVE-15845
URL: https://issues.apache.org/jira/browse/HIVE-15845
Project: Hive
Issue Type: Sub-task
Reporter: Pengcheng Xiong
On master,
{code}
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'
> );
{code}
{code}
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'
)
{code}
You can see that b.key is not quoted.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
