You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2015/12/15 23:15:31 UTC
[04/27] hive git commit: HIVE-11107 : Support for Performance
regression test suite with TPCDS (Hari Subramaniyan,
reviewed by Ashutosh Chauhan)
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>