[jira] [Updated] (DRILL-3258) Add support for non-scalar subqueries in expressions within HAVING clause

2015-09-18 Thread Victoria Markman (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Victoria Markman updated DRILL-3258:

Fix Version/s: (was: 1.2.0)

> 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: Improvement
>  Components: Query Planning & Optimization
>Reporter: Abhishek Girish
>Assignee: Sean Hsuan-Yi Chu
>
> 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)

[jira] [Updated] (DRILL-3258) Add support for non-scalar subqueries in expressions within HAVING clause

2015-06-16 Thread Aman Sinha (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aman Sinha updated DRILL-3258:
--
Fix Version/s: 1.2.0

 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: Improvement
  Components: Query Planning  Optimization
Reporter: Abhishek Girish
Assignee: Sean Hsuan-Yi Chu
 Fix For: 1.2.0


 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)

[jira] [Updated] (DRILL-3258) Add support for non-scalar subqueries in expressions within HAVING clause

2015-06-05 Thread Abhishek Girish (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhishek Girish updated DRILL-3258:
---
Assignee: Sean Hsuan-Yi Chu  (was: Jinfeng Ni)

 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: Improvement
  Components: Query Planning  Optimization
Reporter: Abhishek Girish
Assignee: Sean Hsuan-Yi Chu

 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)