http://git-wip-us.apache.org/repos/asf/hive/blob/09b6f9a3/ql/src/test/results/clientpositive/perf/query88.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query88.q.out b/ql/src/test/results/clientpositive/perf/query88.q.out new file mode 100644 index 0000000..f70bc7f --- /dev/null +++ b/ql/src/test/results/clientpositive/perf/query88.q.out @@ -0,0 +1,1157 @@ +Warning: Shuffle Join MERGEJOIN[421][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 6' is a cross product +Warning: Shuffle Join MERGEJOIN[422][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 7' is a cross product +Warning: Shuffle Join MERGEJOIN[423][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 8' is a cross product +Warning: Shuffle Join MERGEJOIN[424][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4]] in Stage 'Reducer 9' is a cross product +Warning: Shuffle Join MERGEJOIN[425][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5]] in Stage 'Reducer 10' is a cross product +Warning: Shuffle Join MERGEJOIN[426][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6]] in Stage 'Reducer 11' is a cross product +Warning: Shuffle Join MERGEJOIN[427][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7]] in Stage 'Reducer 12' is a cross product +PREHOOK: query: explain +select * +from + (select count(*) h8_30_to_9 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 8 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s1, + (select count(*) h9_to_9_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 9 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s2, + (select count(*) h9_30_to_10 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 9 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s3, + (select count(*) h10_to_10_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 10 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s4, + (select count(*) h10_30_to_11 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 10 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s5, + (select count(*) h11_to_11_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 11 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s6, + (select count(*) h11_30_to_12 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 11 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s7, + (select count(*) h12_to_12_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 12 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s8 +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * +from + (select count(*) h8_30_to_9 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 8 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s1, + (select count(*) h9_to_9_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 9 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s2, + (select count(*) h9_30_to_10 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 9 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s3, + (select count(*) h10_to_10_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 10 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s4, + (select count(*) h10_30_to_11 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 10 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s5, + (select count(*) h11_to_11_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 11 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s6, + (select count(*) h11_30_to_12 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 11 + and time_dim.t_minute >= 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s7, + (select count(*) h12_to_12_30 + from store_sales, household_demographics , time_dim, store + where store_sales.ss_sold_time_sk = time_dim.t_time_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_store_sk = store.s_store_sk + and time_dim.t_hour = 12 + and time_dim.t_minute < 30 + and ((household_demographics.hd_dep_count = 3 and household_demographics.hd_vehicle_count<=3+2) or + (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or + (household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2)) + and store.s_store_name = 'ese') s8 +POSTHOOK: type: QUERY +Plan optimized by CBO. + +Vertex dependency in root stage +Reducer 10 <- Reducer 52 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE) +Reducer 11 <- Reducer 10 (SIMPLE_EDGE), Reducer 60 (SIMPLE_EDGE) +Reducer 12 <- Reducer 11 (SIMPLE_EDGE), Reducer 68 (SIMPLE_EDGE) +Reducer 17 <- Map 16 (SIMPLE_EDGE), Map 21 (SIMPLE_EDGE) +Reducer 18 <- Map 22 (SIMPLE_EDGE), Reducer 17 (SIMPLE_EDGE) +Reducer 19 <- Map 23 (SIMPLE_EDGE), Reducer 18 (SIMPLE_EDGE) +Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 13 (SIMPLE_EDGE) +Reducer 20 <- Reducer 19 (SIMPLE_EDGE) +Reducer 25 <- Map 24 (SIMPLE_EDGE), Map 29 (SIMPLE_EDGE) +Reducer 26 <- Map 30 (SIMPLE_EDGE), Reducer 25 (SIMPLE_EDGE) +Reducer 27 <- Map 31 (SIMPLE_EDGE), Reducer 26 (SIMPLE_EDGE) +Reducer 28 <- Reducer 27 (SIMPLE_EDGE) +Reducer 3 <- Map 14 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) +Reducer 33 <- Map 32 (SIMPLE_EDGE), Map 37 (SIMPLE_EDGE) +Reducer 34 <- Map 38 (SIMPLE_EDGE), Reducer 33 (SIMPLE_EDGE) +Reducer 35 <- Map 39 (SIMPLE_EDGE), Reducer 34 (SIMPLE_EDGE) +Reducer 36 <- Reducer 35 (SIMPLE_EDGE) +Reducer 4 <- Map 15 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE) +Reducer 41 <- Map 40 (SIMPLE_EDGE), Map 45 (SIMPLE_EDGE) +Reducer 42 <- Map 46 (SIMPLE_EDGE), Reducer 41 (SIMPLE_EDGE) +Reducer 43 <- Map 47 (SIMPLE_EDGE), Reducer 42 (SIMPLE_EDGE) +Reducer 44 <- Reducer 43 (SIMPLE_EDGE) +Reducer 49 <- Map 48 (SIMPLE_EDGE), Map 53 (SIMPLE_EDGE) +Reducer 5 <- Reducer 4 (SIMPLE_EDGE) +Reducer 50 <- Map 54 (SIMPLE_EDGE), Reducer 49 (SIMPLE_EDGE) +Reducer 51 <- Map 55 (SIMPLE_EDGE), Reducer 50 (SIMPLE_EDGE) +Reducer 52 <- Reducer 51 (SIMPLE_EDGE) +Reducer 57 <- Map 56 (SIMPLE_EDGE), Map 61 (SIMPLE_EDGE) +Reducer 58 <- Map 62 (SIMPLE_EDGE), Reducer 57 (SIMPLE_EDGE) +Reducer 59 <- Map 63 (SIMPLE_EDGE), Reducer 58 (SIMPLE_EDGE) +Reducer 6 <- Reducer 20 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE) +Reducer 60 <- Reducer 59 (SIMPLE_EDGE) +Reducer 65 <- Map 64 (SIMPLE_EDGE), Map 69 (SIMPLE_EDGE) +Reducer 66 <- Map 70 (SIMPLE_EDGE), Reducer 65 (SIMPLE_EDGE) +Reducer 67 <- Map 71 (SIMPLE_EDGE), Reducer 66 (SIMPLE_EDGE) +Reducer 68 <- Reducer 67 (SIMPLE_EDGE) +Reducer 7 <- Reducer 28 (SIMPLE_EDGE), Reducer 6 (SIMPLE_EDGE) +Reducer 8 <- Reducer 36 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE) +Reducer 9 <- Reducer 44 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE) + +Stage-0 + Fetch Operator + limit:-1 + Stage-1 + Reducer 12 + File Output Operator [FS_285] + compressed:false + Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"} + Merge Join Operator [MERGEJOIN_427] + | condition map:[{"":"Inner Join 0 to 1"}] + | keys:{} + | outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] + | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + |<-Reducer 11 [SIMPLE_EDGE] + | Reduce Output Operator [RS_281] + | sort order: + | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | value expressions:_col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6 (type: bigint) + | Merge Join Operator [MERGEJOIN_426] + | | condition map:[{"":"Inner Join 0 to 1"}] + | | keys:{} + | | outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | |<-Reducer 10 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_278] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint) + | | Merge Join Operator [MERGEJOIN_425] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{} + | | | outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 52 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_276] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_190] + | | | | aggregations:["count(VALUE._col0)"] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 51 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_189] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_188] + | | | aggregations:["count()"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_414] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 55 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_185] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_171] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_388] + | | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_169] + | | | | alias:store + | | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 50 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_183] + | | | key expressions:_col2 (type: int) + | | | Map-reduce partition columns:_col2 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_413] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col2"] + | | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 54 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_180] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_168] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_387] + | | | | predicate:(((t_hour = 11) and (t_minute < 30)) and t_time_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_166] + | | | | alias:time_dim + | | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 49 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_178] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col2 (type: int) + | | | Merge Join Operator [MERGEJOIN_412] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col0","_col2"] + | | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 48 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_173] + | | | | key expressions:_col1 (type: int) + | | | | Map-reduce partition columns:_col1 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | | Select Operator [SEL_162] + | | | | outputColumnNames:["_col0","_col1","_col2"] + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | Filter Operator [FIL_385] + | | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | TableScan [TS_160] + | | | | alias:store_sales + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | |<-Map 53 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_175] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_165] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_386] + | | | predicate:((((hd_dep_count = 3) and (hd_vehicle_count <= 5)) or ((hd_dep_count = 0) and (hd_vehicle_count <= 2)) or ((hd_dep_count = 1) and (hd_vehicle_count <= 3))) and hd_demo_sk is not null) (type: boolean) + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_163] + | | | alias:household_demographics + | | | Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 9 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_275] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint) + | | Merge Join Operator [MERGEJOIN_424] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{} + | | | outputColumnNames:["_col0","_col1","_col2","_col3","_col4"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 44 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_273] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_158] + | | | | aggregations:["count(VALUE._col0)"] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 43 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_157] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_156] + | | | aggregations:["count()"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_411] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 47 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_153] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_139] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_384] + | | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_137] + | | | | alias:store + | | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 42 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_151] + | | | key expressions:_col2 (type: int) + | | | Map-reduce partition columns:_col2 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_410] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col2"] + | | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 46 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_148] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_136] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_383] + | | | | predicate:(((t_hour = 10) and (t_minute >= 30)) and t_time_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_134] + | | | | alias:time_dim + | | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 41 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_146] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col2 (type: int) + | | | Merge Join Operator [MERGEJOIN_409] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col0","_col2"] + | | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 40 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_141] + | | | | key expressions:_col1 (type: int) + | | | | Map-reduce partition columns:_col1 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | | Select Operator [SEL_130] + | | | | outputColumnNames:["_col0","_col1","_col2"] + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | Filter Operator [FIL_381] + | | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | TableScan [TS_128] + | | | | alias:store_sales + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | |<-Map 45 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_143] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_133] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_382] + | | | predicate:((((hd_dep_count = 3) and (hd_vehicle_count <= 5)) or ((hd_dep_count = 0) and (hd_vehicle_count <= 2)) or ((hd_dep_count = 1) and (hd_vehicle_count <= 3))) and hd_demo_sk is not null) (type: boolean) + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_131] + | | | alias:household_demographics + | | | Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 8 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_272] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint), _col3 (type: bigint) + | | Merge Join Operator [MERGEJOIN_423] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{} + | | | outputColumnNames:["_col0","_col1","_col2","_col3"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 36 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_270] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_126] + | | | | aggregations:["count(VALUE._col0)"] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 35 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_125] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_124] + | | | aggregations:["count()"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_408] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 39 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_121] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_107] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_380] + | | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_105] + | | | | alias:store + | | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 34 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_119] + | | | key expressions:_col2 (type: int) + | | | Map-reduce partition columns:_col2 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_407] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col2"] + | | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 38 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_116] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_104] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_379] + | | | | predicate:(((t_hour = 10) and (t_minute < 30)) and t_time_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_102] + | | | | alias:time_dim + | | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 33 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_114] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col2 (type: int) + | | | Merge Join Operator [MERGEJOIN_406] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col0","_col2"] + | | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 32 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_109] + | | | | key expressions:_col1 (type: int) + | | | | Map-reduce partition columns:_col1 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | | Select Operator [SEL_98] + | | | | outputColumnNames:["_col0","_col1","_col2"] + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | Filter Operator [FIL_377] + | | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | TableScan [TS_96] + | | | | alias:store_sales + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | |<-Map 37 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_111] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_101] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_378] + | | | predicate:((((hd_dep_count = 3) and (hd_vehicle_count <= 5)) or ((hd_dep_count = 0) and (hd_vehicle_count <= 2)) or ((hd_dep_count = 1) and (hd_vehicle_count <= 3))) and hd_demo_sk is not null) (type: boolean) + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_99] + | | | alias:household_demographics + | | | Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 7 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_269] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint) + | | Merge Join Operator [MERGEJOIN_422] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{} + | | | outputColumnNames:["_col0","_col1","_col2"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 28 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_267] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_94] + | | | | aggregations:["count(VALUE._col0)"] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 27 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_93] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_92] + | | | aggregations:["count()"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_405] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 31 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_89] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_75] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_376] + | | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_73] + | | | | alias:store + | | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 26 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_87] + | | | key expressions:_col2 (type: int) + | | | Map-reduce partition columns:_col2 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_404] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col2"] + | | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 30 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_84] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_72] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_375] + | | | | predicate:(((t_minute >= 30) and (t_hour = 9)) and t_time_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_70] + | | | | alias:time_dim + | | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 25 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_82] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col2 (type: int) + | | | Merge Join Operator [MERGEJOIN_403] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col0","_col2"] + | | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 24 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_77] + | | | | key expressions:_col1 (type: int) + | | | | Map-reduce partition columns:_col1 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | | Select Operator [SEL_66] + | | | | outputColumnNames:["_col0","_col1","_col2"] + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | Filter Operator [FIL_373] + | | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | TableScan [TS_64] + | | | | alias:store_sales + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | |<-Map 29 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_79] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_69] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_374] + | | | predicate:((((hd_dep_count = 3) and (hd_vehicle_count <= 5)) or ((hd_dep_count = 0) and (hd_vehicle_count <= 2)) or ((hd_dep_count = 1) and (hd_vehicle_count <= 3))) and hd_demo_sk is not null) (type: boolean) + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_67] + | | | alias:household_demographics + | | | Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 6 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_266] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint), _col1 (type: bigint) + | | Merge Join Operator [MERGEJOIN_421] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{} + | | | outputColumnNames:["_col0","_col1"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 20 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_264] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_62] + | | | | aggregations:["count(VALUE._col0)"] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 19 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_61] + | | | sort order: + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col0 (type: bigint) + | | | Group By Operator [GBY_60] + | | | aggregations:["count()"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_402] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 23 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_57] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_43] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_372] + | | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_41] + | | | | alias:store + | | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 18 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_55] + | | | key expressions:_col2 (type: int) + | | | Map-reduce partition columns:_col2 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | Merge Join Operator [MERGEJOIN_401] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col2"] + | | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 22 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_52] + | | | | key expressions:_col0 (type: int) + | | | | Map-reduce partition columns:_col0 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Select Operator [SEL_40] + | | | | outputColumnNames:["_col0"] + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | Filter Operator [FIL_371] + | | | | predicate:(((t_hour = 9) and (t_minute < 30)) and t_time_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | | TableScan [TS_38] + | | | | alias:time_dim + | | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | | |<-Reducer 17 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_50] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | value expressions:_col2 (type: int) + | | | Merge Join Operator [MERGEJOIN_400] + | | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | | outputColumnNames:["_col0","_col2"] + | | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | | |<-Map 16 [SIMPLE_EDGE] + | | | | Reduce Output Operator [RS_45] + | | | | key expressions:_col1 (type: int) + | | | | Map-reduce partition columns:_col1 (type: int) + | | | | sort order:+ + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | | Select Operator [SEL_34] + | | | | outputColumnNames:["_col0","_col1","_col2"] + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | Filter Operator [FIL_369] + | | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | | TableScan [TS_32] + | | | | alias:store_sales + | | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | |<-Map 21 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_47] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_37] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_370] + | | | predicate:((((hd_dep_count = 3) and (hd_vehicle_count <= 5)) or ((hd_dep_count = 0) and (hd_vehicle_count <= 2)) or ((hd_dep_count = 1) and (hd_vehicle_count <= 3))) and hd_demo_sk is not null) (type: boolean) + | | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_35] + | | | alias:household_demographics + | | | Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 5 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_263] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint) + | | Group By Operator [GBY_30] + | | | aggregations:["count(VALUE._col0)"] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 4 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_29] + | | sort order: + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col0 (type: bigint) + | | Group By Operator [GBY_28] + | | aggregations:["count()"] + | | outputColumnNames:["_col0"] + | | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + | | Merge Join Operator [MERGEJOIN_399] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"} + | | | Statistics:Num rows: 17424 Data size: 8206704 Basic stats: COMPLETE Column stats: NONE + | | |<-Map 15 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_25] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_11] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_368] + | | | predicate:((s_store_name = 'ese') and s_store_sk is not null) (type: boolean) + | | | Statistics:Num rows: 852 Data size: 1628138 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_9] + | | | alias:store + | | | Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 3 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_23] + | | key expressions:_col2 (type: int) + | | Map-reduce partition columns:_col2 (type: int) + | | sort order:+ + | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | Merge Join Operator [MERGEJOIN_398] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"} + | | | outputColumnNames:["_col2"] + | | | Statistics:Num rows: 15840 Data size: 7460640 Basic stats: COMPLETE Column stats: NONE + | | |<-Map 14 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_20] + | | | key expressions:_col0 (type: int) + | | | Map-reduce partition columns:_col0 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | Select Operator [SEL_8] + | | | outputColumnNames:["_col0"] + | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | Filter Operator [FIL_367] + | | | predicate:(((t_minute >= 30) and (t_hour = 8)) and t_time_sk is not null) (type: boolean) + | | | Statistics:Num rows: 14400 Data size: 6782400 Basic stats: COMPLETE Column stats: NONE + | | | TableScan [TS_6] + | | | alias:time_dim + | | | Statistics:Num rows: 86400 Data size: 40694400 Basic stats: COMPLETE Column stats: NONE + | | |<-Reducer 2 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_18] + | | key expressions:_col0 (type: int) + | | Map-reduce partition columns:_col0 (type: int) + | | sort order:+ + | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | value expressions:_col2 (type: int) + | | Merge Join Operator [MERGEJOIN_397] + | | | condition map:[{"":"Inner Join 0 to 1"}] + | | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"} + | | | outputColumnNames:["_col0","_col2"] + | | | Statistics:Num rows: 3960 Data size: 423720 Basic stats: COMPLETE Column stats: NONE + | | |<-Map 1 [SIMPLE_EDGE] + | | | Reduce Output Operator [RS_13] + | | | key expressions:_col1 (type: int) + | | | Map-reduce partition columns:_col1 (type: int) + | | | sort order:+ + | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | value expressions:_col0 (type: int), _col2 (type: int) + | | | Select Operator [SEL_2] + | | | outputColumnNames:["_col0","_col1","_col2"] + | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | Filter Operator [FIL_365] + | | | predicate:((ss_hdemo_sk is not null and ss_sold_time_sk is not null) and ss_store_sk is not null) (type: boolean) + | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | | TableScan [TS_0] + | | | alias:store_sales + | | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + | | |<-Map 13 [SIMPLE_EDGE] + | | Reduce Output Operator [RS_15] + | | key expressions:_col0 (type: int) + | | Map-reduce partition columns:_col0 (type: int) + | | sort order:+ + | | Statistics:Num rows: 3600 Data size: 385200 Basic stats: COMPLETE Column stats: NONE +
<TRUNCATED>