modules/sql-engine/src/test/resources/tpch/plan/q17.plan

Project
    fieldNames: [AVG_YEARLY]
    projection: [/($f0, 7.0:DECIMAL(2, 1))]
    est: (rows=1)
  ColocatedHashAggregate
      fieldNames: [$f0]
      group: []
      aggregation: [SUM(L_EXTENDEDPRICE)]
      est: (rows=1)
    Project
        fieldNames: [L_EXTENDEDPRICE]
        projection: [L_EXTENDEDPRICE]
        est: (rows=465828)
      HashJoin
          predicate: AND(<(CAST(L_QUANTITY):DECIMAL(31, 17) NOT NULL, *(0.2:DECIMAL(2, 1), $f1)), =(P_PARTKEY, L_PARTKEY))
          fieldNames: [L_PARTKEY, L_QUANTITY, L_EXTENDEDPRICE, L_PARTKEY$0, $f1, P_PARTKEY, P_BRAND, P_CONTAINER]
          type: inner
          est: (rows=465828)
        Exchange
            distribution: single
            est: (rows=6001215)
          TableScan
              table: PUBLIC.LINEITEM
              fieldNames: [L_PARTKEY, L_QUANTITY, L_EXTENDEDPRICE]
              est: (rows=6001215)
        MergeJoin
            predicate: =(P_PARTKEY, L_PARTKEY)
            type: inner
            est: (rows=133094)
          Project
              fieldNames: [L_PARTKEY, $f1]
              projection: [f0, DECIMAL_DIVIDE(CAST(f0_1):DECIMAL(30, 2) NOT NULL, f1_2, 29, 16)]
              est: (rows=1200243)
            ReduceSortAggregate
                fieldNames: [f0, f0_1, f1_2]
                collation: [f0 ASC]
                group: [0]
                aggregation: [SUM(1), $SUM0(2)]
                est: (rows=1200243)
              Project
                  fieldNames: [0, 1, 2]
                  projection: [L_PARTKEY, CAST(_ACC0):DECIMAL(60, 2) NOT NULL, CAST(_ACC1):DECIMAL(38, 0) NOT NULL]
                  est: (rows=1200243)
                Exchange
                    distribution: single
                    est: (rows=1200243)
                  MapSortAggregate
                      fieldNames: [L_PARTKEY, _ACC0, _ACC1]
                      collation: [L_PARTKEY ASC]
                      group: [L_PARTKEY]
                      aggregation: [SUM(L_QUANTITY), COUNT(L_QUANTITY)]
                      est: (rows=1200243)
                    IndexScan
                        table: PUBLIC.LINEITEM
                        index: L_PK_SK
                        type: SORTED
                        fieldNames: [L_PARTKEY, L_QUANTITY]
                        collation: [L_PARTKEY ASC]
                        est: (rows=6001215)
          Exchange
              distribution: single
              est: (rows=22178)
            Sort
                collation: [P_PARTKEY ASC]
                est: (rows=22178)
              TableScan
                  table: PUBLIC.PART
                  predicate: AND(=(P_BRAND, _UTF-8'Brand#23'), =(P_CONTAINER, _UTF-8'MED BOX'))
                  fieldNames: [P_PARTKEY, P_BRAND, P_CONTAINER]
                  est: (rows=22178)