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

Sort
    collation: [EXT_PRICE DESC, BRAND ASC, BRAND_ID ASC, I_MANUFACT_ID ASC, I_MANUFACT ASC]
    fetch: 100
    est: (rows=100)
  Project
      fieldNames: [BRAND_ID, BRAND, I_MANUFACT_ID, I_MANUFACT, EXT_PRICE]
      projection: [BRAND_ID, BRAND, I_MANUFACT_ID, I_MANUFACT, EXT_PRICE]
      est: (rows=43957)
    ColocatedHashAggregate
        fieldNames: [BRAND, BRAND_ID, I_MANUFACT_ID, I_MANUFACT, EXT_PRICE]
        group: [BRAND, BRAND_ID, I_MANUFACT_ID, I_MANUFACT]
        aggregation: [SUM(SS_EXT_SALES_PRICE)]
        est: (rows=43957)
      Project
          fieldNames: [BRAND, BRAND_ID, I_MANUFACT_ID, I_MANUFACT, SS_EXT_SALES_PRICE]
          projection: [I_BRAND, I_BRAND_ID, I_MANUFACT_ID, I_MANUFACT, SS_EXT_SALES_PRICE]
          est: (rows=74453)
        HashJoin
            predicate: AND(=(SS_CUSTOMER_SK, C_CUSTOMER_SK), <>(SUBSTR(CA_ZIP, 1, 5), SUBSTR(S_ZIP, 1, 5)))
            type: inner
            est: (rows=74453)
          HashJoin
              predicate: =(SS_STORE_SK, S_STORE_SK)
              type: inner
              est: (rows=106362)
            HashJoin
                predicate: =(SS_ITEM_SK, I_ITEM_SK)
                type: inner
                est: (rows=106362)
              HashJoin
                  predicate: =(D_DATE_SK, SS_SOLD_DATE_SK)
                  type: inner
                  est: (rows=319405)
                Exchange
                    distribution: single
                    est: (rows=2880404)
                  TableScan
                      table: PUBLIC.STORE_SALES
                      fieldNames: [SS_SOLD_DATE_SK, SS_ITEM_SK, SS_CUSTOMER_SK, SS_STORE_SK, SS_EXT_SALES_PRICE]
                      est: (rows=2880404)
                Exchange
                    distribution: single
                    est: (rows=8100)
                  TableScan
                      table: PUBLIC.DATE_DIM
                      predicate: AND(=(D_MOY, 12), =(D_YEAR, 1998))
                      fieldNames: [D_DATE_SK, D_YEAR, D_MOY]
                      est: (rows=8100)
              Exchange
                  distribution: single
                  est: (rows=5994)
                TableScan
                    table: PUBLIC.ITEM
                    predicate: =(I_MANAGER_ID, 16)
                    fieldNames: [I_ITEM_SK, I_BRAND_ID, I_BRAND, I_MANUFACT_ID, I_MANUFACT, I_MANAGER_ID]
                    est: (rows=5994)
            Exchange
                distribution: single
                est: (rows=12)
              TableScan
                  table: PUBLIC.STORE
                  fieldNames: [S_STORE_SK, S_ZIP]
                  est: (rows=12)
          HashJoin
              predicate: =(C_CURRENT_ADDR_SK, CA_ADDRESS_SK)
              type: inner
              est: (rows=100000)
            Exchange
                distribution: single
                est: (rows=100000)
              TableScan
                  table: PUBLIC.CUSTOMER
                  fieldNames: [C_CUSTOMER_SK, C_CURRENT_ADDR_SK]
                  est: (rows=100000)
            Exchange
                distribution: single
                est: (rows=50000)
              TableScan
                  table: PUBLIC.CUSTOMER_ADDRESS
                  fieldNames: [CA_ADDRESS_SK, CA_ZIP]
                  est: (rows=50000)