[IMPALA-1285] Subquery with group by and where could realize the result has one row.

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.0
• Component/s: Frontend
• Labels: planner
• Epic Link: Subquery Support
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Nong Li
• Created: 20/Sep/14 18:32
• Updated: 10/Jul/20 23:36

Description

An example is tpcds q44,

group by ss_item_sk	
--    having avg(ss_net_profit) > 0.9*(select avg(ss_net_profit) rank_col
--                                      from store_sales	
--                                      where ss_store_sk = 4	
--                                      group by ss_store_sk)

We should recognize that there is a single eq predicate and a single grouping column.

Issue Links

• is related to: IMPALA-5100 add run time scalar subquery check
• relates to: IMPALA-9905 Allow runtime scalar subquery check when group by clause is present