| Sort | |
| collation: [I_ITEM_ID ASC, S_STATE ASC] | |
| fetch: 100 | |
| est: (rows=100) | |
| ColocatedHashAggregate | |
| fieldNames: [I_ITEM_ID, S_STATE, G_STATE, AGG1, AGG2, AGG3, AGG4] | |
| group: [I_ITEM_ID, S_STATE] | |
| groupSets: [[I_ITEM_ID, S_STATE], [I_ITEM_ID], []] | |
| aggregation: [GROUPING(S_STATE), AVG(SS_QUANTITY), AVG(SS_LIST_PRICE), AVG(SS_COUPON_AMT), AVG(SS_SALES_PRICE)] | |
| est: (rows=12751) | |
| Project | |
| fieldNames: [I_ITEM_ID, S_STATE, SS_QUANTITY, SS_LIST_PRICE, SS_COUPON_AMT, SS_SALES_PRICE] | |
| projection: [I_ITEM_ID, S_STATE, SS_QUANTITY, SS_LIST_PRICE, SS_COUPON_AMT, SS_SALES_PRICE] | |
| est: (rows=35419) | |
| HashJoin | |
| predicate: =(SS_STORE_SK, S_STORE_SK) | |
| type: inner | |
| est: (rows=35419) | |
| HashJoin | |
| predicate: =(SS_ITEM_SK, I_ITEM_SK) | |
| type: inner | |
| est: (rows=35419) | |
| HashJoin | |
| predicate: =(SS_SOLD_DATE_SK, D_DATE_SK) | |
| type: inner | |
| est: (rows=35419) | |
| HashJoin | |
| predicate: =(SS_CDEMO_SK, CD_DEMO_SK) | |
| type: inner | |
| est: (rows=106362) | |
| Exchange | |
| distribution: single | |
| est: (rows=2880404) | |
| TableScan | |
| table: PUBLIC.STORE_SALES | |
| fieldNames: [SS_SOLD_DATE_SK, SS_ITEM_SK, SS_CDEMO_SK, SS_STORE_SK, SS_QUANTITY, SS_LIST_PRICE, SS_SALES_PRICE, SS_COUPON_AMT] | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=70928) | |
| TableScan | |
| table: PUBLIC.CUSTOMER_DEMOGRAPHICS | |
| predicate: AND(=(CD_GENDER, _UTF-8'F'), =(CD_MARITAL_STATUS, _UTF-8'U'), =(CD_EDUCATION_STATUS, _UTF-8'2 yr Degree')) | |
| fieldNames: [CD_DEMO_SK, CD_GENDER, CD_MARITAL_STATUS, CD_EDUCATION_STATUS] | |
| est: (rows=70928) | |
| Exchange | |
| distribution: single | |
| est: (rows=24325) | |
| TableScan | |
| table: PUBLIC.DATE_DIM | |
| predicate: =(D_YEAR, 2000) | |
| fieldNames: [D_DATE_SK, D_YEAR] | |
| est: (rows=24325) | |
| Exchange | |
| distribution: single | |
| est: (rows=18000) | |
| TableScan | |
| table: PUBLIC.ITEM | |
| fieldNames: [I_ITEM_SK, I_ITEM_ID] | |
| est: (rows=18000) | |
| Exchange | |
| distribution: single | |
| est: (rows=12) | |
| TableScan | |
| table: PUBLIC.STORE | |
| predicate: SEARCH(S_STATE, Sarg[_UTF-8'AL':VARCHAR(2) CHARACTER SET "UTF-8", _UTF-8'FL':VARCHAR(2) CHARACTER SET "UTF-8", _UTF-8'IN':VARCHAR(2) CHARACTER SET "UTF-8", _UTF-8'NY':VARCHAR(2) CHARACTER SET "UTF-8", _UTF-8'OH':VARCHAR(2) CHARACTER SET "UTF-8", _UTF-8'SC':VARCHAR(2) CHARACTER SET "UTF-8"]:VARCHAR(2) CHARACTER SET "UTF-8") | |
| fieldNames: [S_STORE_SK, S_STATE] | |
| est: (rows=12) |