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

Limit
    fetch: 100
    est: (rows=1)
  ColocatedHashAggregate
      fieldNames: [STORE_ONLY, CATALOG_ONLY, STORE_AND_CATALOG]
      group: []
      aggregation: [SUM($f0), SUM($f1), SUM($f2)]
      est: (rows=1)
    Project
        fieldNames: [$f0, $f1, $f2]
        projection: [CASE(AND(IS NOT NULL(CUSTOMER_SK), IS NULL(CUSTOMER_SK$0)), 1, 0), CASE(AND(IS NULL(CUSTOMER_SK), IS NOT NULL(CUSTOMER_SK$0)), 1, 0), CASE(AND(IS NOT NULL(CUSTOMER_SK), IS NOT NULL(CUSTOMER_SK$0)), 1, 0)]
        est: (rows=757126078)
      HashJoin
          predicate: AND(=(CUSTOMER_SK, CUSTOMER_SK$0), =(ITEM_SK, ITEM_SK$0))
          fieldNames: [CUSTOMER_SK, ITEM_SK, CUSTOMER_SK$0, ITEM_SK$0]
          type: full
          est: (rows=757126078)
        ColocatedHashAggregate
            group: [CUSTOMER_SK, ITEM_SK]
            aggregation: []
            est: (rows=259236)
          Project
              fieldNames: [CUSTOMER_SK, ITEM_SK]
              projection: [SS_CUSTOMER_SK, SS_ITEM_SK]
              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_CUSTOMER_SK]
                    est: (rows=2880404)
              Exchange
                  distribution: single
                  est: (rows=18262)
                TableScan
                    table: PUBLIC.DATE_DIM
                    predicate: SEARCH(D_MONTH_SEQ, Sarg[[1190..1201]])
                    fieldNames: [D_DATE_SK, D_MONTH_SEQ]
                    est: (rows=18262)
        ColocatedHashAggregate
            group: [CUSTOMER_SK, ITEM_SK]
            aggregation: []
            est: (rows=129739)
          Project
              fieldNames: [CUSTOMER_SK, ITEM_SK]
              projection: [CS_BILL_CUSTOMER_SK, CS_ITEM_SK]
              est: (rows=360387)
            HashJoin
                predicate: =(CS_SOLD_DATE_SK, D_DATE_SK)
                type: inner
                est: (rows=360387)
              Exchange
                  distribution: single
                  est: (rows=1441548)
                TableScan
                    table: PUBLIC.CATALOG_SALES
                    fieldNames: [CS_SOLD_DATE_SK, CS_BILL_CUSTOMER_SK, CS_ITEM_SK]
                    est: (rows=1441548)
              Exchange
                  distribution: single
                  est: (rows=18262)
                TableScan
                    table: PUBLIC.DATE_DIM
                    predicate: SEARCH(D_MONTH_SEQ, Sarg[[1190..1201]])
                    fieldNames: [D_DATE_SK, D_MONTH_SEQ]
                    est: (rows=18262)