Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20265

PTF operator has an extra reducer in CBO

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.0.0
    • Fix Version/s: None
    • Component/s: Query Planning
    • Labels:
      None
    • Target Version/s:

      Description

      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
      

      Above query generates extra reducer with CBO on.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vgarg Vineet Garg
                Reporter:
                vgarg Vineet Garg
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: