You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/06/06 00:40:00 UTC
[jira] [Created] (DRILL-3258) Add support for non-scalar subqueries
in expressions within HAVING clause
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)