[
https://issues.apache.org/jira/browse/HIVE-16228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15930753#comment-15930753
]
Ashutosh Chauhan commented on HIVE-16228:
-----------------------------------------
Can you also add query 9 from TPCDS suite in TestPerfCliDriver and also
following variants in tests:
* select max(c1) > ( select count( * )-1 from t1 ) fromt1;
* select c1, (select count(distinct c2) from u where u.obid = o.obid
group by obid) tmp from o right join (select * from f where d1 > (select
avg(d1) from f)) t on t.fid = o.fid;
* SELECT DISTINCT t1.c1 , (SELECT COUNT(*) FROM t2 WHERE t2.c1 = t1.c1 GROUP
BY t2.c1) , (SELECT COUNT(*) FROM q1, t2 WHERE t2.c1 = t1.c1 AND q1.qid =
t2.qid AND (SELECT SUM(d1) FROM a1 WHERE a1.qid = q1.qid GROUP BY a1.qid) >
0) from t1;
> Support subqueries in complex expression in SELECT clause
> ---------------------------------------------------------
>
> Key: HIVE-16228
> URL: https://issues.apache.org/jira/browse/HIVE-16228
> Project: Hive
> Issue Type: Sub-task
> Components: Logical Optimizer
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Attachments: HIVE-16228.1.patch
>
>
> HIVE-16091 added support for subqueries in SELECT clause but restricted
> subqueries to top level expressions (more detail is at [LINK |
> https://cwiki.apache.org/confluence/display/Hive/Subqueries+in+SELECT])
> This restriction will be relaxed to allow subqueries in all kind of
> expression except UDAF (including UDAs and UDTFs).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
