hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16228) Support subqueries in complex expression in SELECT clause
Date Fri, 17 Mar 2017 21:27:41 GMT

    [ 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)

Mime
View raw message