Vineet Garg created HIVE-20265: ---------------------------------- Summary: PTF operator has an extra reducer in CBO Key: HIVE-20265 URL: https://issues.apache.org/jira/browse/HIVE-20265 Project: Hive Issue Type: Improvement Components: Query Planning Reporter: Vineet Garg Assignee: Vineet Garg
{code:sql} explain vectorization detail select p_mfgr, p_name, p_size, min(p_retailprice), rank() over(distribute by p_mfgr sort by p_name)as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr, p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz from part group by p_mfgr, p_name, p_size {code} Above query generates extra reducer with CBO on. -- This message was sent by Atlassian JIRA (v7.6.3#76005)