Abhishek Girish created DRILL-3258:
--------------------------------------
Summary: Add support for non-scalar subqueries in expressions
within HAVING clause
Key: DRILL-3258
URL: https://issues.apache.org/jira/browse/DRILL-3258
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Abhishek Girish
Assignee: Jinfeng Ni
Drill currently does not support queries with non-scalar sub-queries (which
return more than one row) used within expressions.
{code:sql}
SELECT ss_item_sk
FROM store_sales
GROUP BY ss_item_sk
HAVING Avg(ss_net_profit) > 2 *
(SELECT avg(ss_net_profit)
FROM store_sales
GROUP BY ss_store_sk);
{code}
Such queries should be supported by Drill.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
