modules/sql-engine/src/test/resources/tpcds/plan/q65.plan

Sort
    collation: [S_STORE_NAME ASC, I_ITEM_DESC ASC]
    fetch: 100
    est: (rows=100)
  Project
      fieldNames: [S_STORE_NAME, I_ITEM_DESC, REVENUE, I_CURRENT_PRICE, I_WHOLESALE_COST, I_BRAND]
      projection: [S_STORE_NAME, I_ITEM_DESC, REVENUE, I_CURRENT_PRICE, I_WHOLESALE_COST, I_BRAND]
      est: (rows=5040261776)
    HashJoin
        predicate: AND(<=(CAST(REVENUE):DECIMAL(30, 17), *(0.1:DECIMAL(2, 1), AVE)), =(SS_STORE_SK$0, SS_STORE_SK))
        fieldNames: [I_ITEM_SK, I_ITEM_DESC, I_CURRENT_PRICE, I_WHOLESALE_COST, I_BRAND, SS_STORE_SK, SS_ITEM_SK, REVENUE, S_STORE_SK, S_STORE_NAME, SS_STORE_SK$0, AVE]
        type: inner
        est: (rows=5040261776)
      HashJoin
          predicate: =(I_ITEM_SK, SS_ITEM_SK)
          type: inner
          est: (rows=259236)
        Exchange
            distribution: single
            est: (rows=18000)
          TableScan
              table: PUBLIC.ITEM
              fieldNames: [I_ITEM_SK, I_ITEM_DESC, I_CURRENT_PRICE, I_WHOLESALE_COST, I_BRAND]
              est: (rows=18000)
        ColocatedHashAggregate
            fieldNames: [SS_STORE_SK, SS_ITEM_SK, REVENUE]
            group: [SS_STORE_SK, SS_ITEM_SK]
            aggregation: [SUM(SS_SALES_PRICE)]
            est: (rows=259236)
          Project
              fieldNames: [SS_STORE_SK, SS_ITEM_SK, SS_SALES_PRICE]
              projection: [SS_STORE_SK, SS_ITEM_SK, SS_SALES_PRICE]
              est: (rows=720101)
            HashJoin
                predicate: =(SS_SOLD_DATE_SK, D_DATE_SK)
                type: inner
                est: (rows=720101)
              Exchange
                  distribution: single
                  est: (rows=2880404)
                TableScan
                    table: PUBLIC.STORE_SALES
                    fieldNames: [SS_SOLD_DATE_SK, SS_ITEM_SK, SS_STORE_SK, SS_SALES_PRICE]
                    est: (rows=2880404)
              Exchange
                  distribution: single
                  est: (rows=18262)
                TableScan
                    table: PUBLIC.DATE_DIM
                    predicate: SEARCH(D_MONTH_SEQ, Sarg[[1186..1197]])
                    fieldNames: [D_DATE_SK, D_MONTH_SEQ]
                    est: (rows=18262)
      HashJoin
          predicate: =(SS_STORE_SK, S_STORE_SK)
          type: inner
          est: (rows=259236)
        Exchange
            distribution: single
            est: (rows=12)
          TableScan
              table: PUBLIC.STORE
              fieldNames: [S_STORE_SK, S_STORE_NAME]
              est: (rows=12)
        ColocatedHashAggregate
            fieldNames: [SS_STORE_SK, AVE]
            group: [SS_STORE_SK]
            aggregation: [AVG(REVENUE)]
            est: (rows=259236)
          Project
              fieldNames: [SS_STORE_SK, REVENUE]
              projection: [SS_STORE_SK, REVENUE]
              est: (rows=259236)
            ColocatedHashAggregate
                fieldNames: [SS_STORE_SK, SS_ITEM_SK, REVENUE]
                group: [SS_STORE_SK, SS_ITEM_SK]
                aggregation: [SUM(SS_SALES_PRICE)]
                est: (rows=259236)
              Project
                  fieldNames: [SS_STORE_SK, SS_ITEM_SK, SS_SALES_PRICE]
                  projection: [SS_STORE_SK, SS_ITEM_SK, SS_SALES_PRICE]
                  est: (rows=720101)
                HashJoin
                    predicate: =(SS_SOLD_DATE_SK, D_DATE_SK)
                    type: inner
                    est: (rows=720101)
                  Exchange
                      distribution: single
                      est: (rows=2880404)
                    TableScan
                        table: PUBLIC.STORE_SALES
                        fieldNames: [SS_SOLD_DATE_SK, SS_ITEM_SK, SS_STORE_SK, SS_SALES_PRICE]
                        est: (rows=2880404)
                  Exchange
                      distribution: single
                      est: (rows=18262)
                    TableScan
                        table: PUBLIC.DATE_DIM
                        predicate: SEARCH(D_MONTH_SEQ, Sarg[[1186..1197]])
                        fieldNames: [D_DATE_SK, D_MONTH_SEQ]
                        est: (rows=18262)