| Limit | |
| fetch: 100 | |
| est: (rows=100) | |
| Project | |
| fieldNames: [S_STORE_NAME1, S_STORE_ID1, D_WEEK_SEQ1, EXPR$3, EXPR$4, EXPR$5, EXPR$6, EXPR$7, EXPR$8, EXPR$9] | |
| projection: [S_STORE_NAME1, S_STORE_ID1, D_WEEK_SEQ1, /(SUN_SALES1, SUN_SALES2), /(MON_SALES1, MON_SALES2), /(TUE_SALES1, TUE_SALES2), /(WED_SALES1, WED_SALES2), /(THU_SALES1, THU_SALES2), /(FRI_SALES1, FRI_SALES2), /(SAT_SALES1, SAT_SALES2)] | |
| est: (rows=181545469684679584) | |
| HashJoin | |
| predicate: AND(=(S_STORE_ID1, S_STORE_ID2), =(D_WEEK_SEQ1, $f9)) | |
| type: inner | |
| est: (rows=181545469684679584) | |
| Sort | |
| collation: [S_STORE_NAME1 ASC, S_STORE_ID1 ASC, D_WEEK_SEQ1 ASC] | |
| est: (rows=2840543529) | |
| Project | |
| fieldNames: [S_STORE_NAME1, D_WEEK_SEQ1, S_STORE_ID1, SUN_SALES1, MON_SALES1, TUE_SALES1, WED_SALES1, THU_SALES1, FRI_SALES1, SAT_SALES1] | |
| projection: [S_STORE_NAME, D_WEEK_SEQ$0, S_STORE_ID, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES] | |
| est: (rows=2840543529) | |
| HashJoin | |
| predicate: =(D_WEEK_SEQ, D_WEEK_SEQ$0) | |
| fieldNames: [D_MONTH_SEQ, D_WEEK_SEQ, S_STORE_SK, S_STORE_ID, S_STORE_NAME, D_WEEK_SEQ$0, SS_STORE_SK, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES] | |
| type: inner | |
| est: (rows=2840543529) | |
| Exchange | |
| distribution: single | |
| est: (rows=18262) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| predicate: SEARCH(D_MONTH_SEQ, Sarg[[1205..1216]]) | |
| fieldNames: [D_MONTH_SEQ, D_WEEK_SEQ] | |
| est: (rows=18262) | |
| HashJoin | |
| predicate: =(SS_STORE_SK, S_STORE_SK) | |
| type: inner | |
| est: (rows=1036945) | |
| Exchange | |
| distribution: single | |
| est: (rows=12) | |
| TableScan | |
| table: PUBLIC.STORE | |
| fieldNames: [S_STORE_SK, S_STORE_ID, S_STORE_NAME] | |
| est: (rows=12) | |
| ColocatedHashAggregate | |
| fieldNames: [D_WEEK_SEQ, SS_STORE_SK, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES] | |
| group: [D_WEEK_SEQ, SS_STORE_SK] | |
| aggregation: [SUM($f2), SUM($f3), SUM($f4), SUM($f5), SUM($f6), SUM($f7), SUM($f8)] | |
| est: (rows=1036945) | |
| Project | |
| fieldNames: [D_WEEK_SEQ, SS_STORE_SK, $f2, $f3, $f4, $f5, $f6, $f7, $f8] | |
| projection: [D_WEEK_SEQ, SS_STORE_SK, CASE(=(D_DAY_NAME, _UTF-8'Sunday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Monday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Tuesday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Wednesday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Thursday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Friday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Saturday'), SS_SALES_PRICE, null:DECIMAL(7, 2))] | |
| est: (rows=2880404) | |
| HashJoin | |
| predicate: =(D_DATE_SK, SS_SOLD_DATE_SK) | |
| type: inner | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=2880404) | |
| TableScan | |
| table: PUBLIC.STORE_SALES | |
| fieldNames: [SS_SOLD_DATE_SK, SS_STORE_SK, SS_SALES_PRICE] | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=73049) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| fieldNames: [D_DATE_SK, D_WEEK_SEQ, D_DAY_NAME] | |
| est: (rows=73049) | |
| Project | |
| fieldNames: [D_WEEK_SEQ2, S_STORE_ID2, SUN_SALES2, MON_SALES2, TUE_SALES2, WED_SALES2, THU_SALES2, FRI_SALES2, SAT_SALES2, $f9] | |
| projection: [D_WEEK_SEQ$0, S_STORE_ID, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES, -(D_WEEK_SEQ$0, 52)] | |
| est: (rows=2840543529) | |
| HashJoin | |
| predicate: =(D_WEEK_SEQ, D_WEEK_SEQ$0) | |
| fieldNames: [D_MONTH_SEQ, D_WEEK_SEQ, S_STORE_SK, S_STORE_ID, D_WEEK_SEQ$0, SS_STORE_SK, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES] | |
| type: inner | |
| est: (rows=2840543529) | |
| Exchange | |
| distribution: single | |
| est: (rows=18262) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| predicate: SEARCH(D_MONTH_SEQ, Sarg[[1217..1228]]) | |
| fieldNames: [D_MONTH_SEQ, D_WEEK_SEQ] | |
| est: (rows=18262) | |
| HashJoin | |
| predicate: =(SS_STORE_SK, S_STORE_SK) | |
| type: inner | |
| est: (rows=1036945) | |
| Exchange | |
| distribution: single | |
| est: (rows=12) | |
| TableScan | |
| table: PUBLIC.STORE | |
| fieldNames: [S_STORE_SK, S_STORE_ID] | |
| est: (rows=12) | |
| ColocatedHashAggregate | |
| fieldNames: [D_WEEK_SEQ, SS_STORE_SK, SUN_SALES, MON_SALES, TUE_SALES, WED_SALES, THU_SALES, FRI_SALES, SAT_SALES] | |
| group: [D_WEEK_SEQ, SS_STORE_SK] | |
| aggregation: [SUM($f2), SUM($f3), SUM($f4), SUM($f5), SUM($f6), SUM($f7), SUM($f8)] | |
| est: (rows=1036945) | |
| Project | |
| fieldNames: [D_WEEK_SEQ, SS_STORE_SK, $f2, $f3, $f4, $f5, $f6, $f7, $f8] | |
| projection: [D_WEEK_SEQ, SS_STORE_SK, CASE(=(D_DAY_NAME, _UTF-8'Sunday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Monday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Tuesday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Wednesday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Thursday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Friday'), SS_SALES_PRICE, null:DECIMAL(7, 2)), CASE(=(D_DAY_NAME, _UTF-8'Saturday'), SS_SALES_PRICE, null:DECIMAL(7, 2))] | |
| est: (rows=2880404) | |
| HashJoin | |
| predicate: =(D_DATE_SK, SS_SOLD_DATE_SK) | |
| type: inner | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=2880404) | |
| TableScan | |
| table: PUBLIC.STORE_SALES | |
| fieldNames: [SS_SOLD_DATE_SK, SS_STORE_SK, SS_SALES_PRICE] | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=73049) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| fieldNames: [D_DATE_SK, D_WEEK_SEQ, D_DAY_NAME] | |
| est: (rows=73049) |