You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ambari.apache.org by sr...@apache.org on 2014/02/26 23:03:01 UTC
[2/3] AMBARI-4829. Tez DAG diagram should have zoom in/out and pan
actions. (srimanth)
http://git-wip-us.apache.org/repos/asf/ambari/blob/b269ba5f/ambari-web/app/assets/data/jobs/hive-queries.json
----------------------------------------------------------------------
diff --git a/ambari-web/app/assets/data/jobs/hive-queries.json b/ambari-web/app/assets/data/jobs/hive-queries.json
index aae8ef7..ae4eed0 100644
--- a/ambari-web/app/assets/data/jobs/hive-queries.json
+++ b/ambari-web/app/assets/data/jobs/hive-queries.json
@@ -1,233 +1,237 @@
{
"entities": [
{
- "starttime": 1392936251060,
+ "starttime": 1393443850756,
"events": [
{
- "timestamp": 1392936280573,
+ "timestamp": 1393443875265,
"eventtype": "QUERY_COMPLETED",
"eventinfo": {}
},
{
- "timestamp": 1392936251060,
+ "timestamp": 1393443850756,
"eventtype": "QUERY_SUBMITTED",
"eventinfo": {}
}
],
"otherinfo": {
- "query": "{\"query\":{\"queryText\":\"select players.* from players join \\n(select school.id, topState.counts from school join (select state, count(state) as counts from school group by state sort by counts desc limit 1) topState on school.state = topState.state)\\ntopSchools on topSchools.id = players.schoolid where players.yearmin > 1990 sort by players.schoolid\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Tez\":{\"DagName:\":\"hive_20140220172727_9cb1b1a3-25bd-457b-81dc-60544c941cfa:11\",\"Vertices:\":{\"Reducer 3\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"count(VALUE._col0)\"],\"keys:\":\"KEY._col0 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expressions:\":\"_col0 (type: string),
_col1 (type: bigint)\",\"Statistics:\":\"Num rows: 251 Data size: 25132 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 251 Data size: 25132 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 251 Data size: 25132 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 1\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"school\",\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"_col0 (type: string)\",\"0\":\"state (type: string)\"},\"outputColumnNames:\":[\"_col0\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string)\",\"outputColumnNames:\":[\"_col0\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 276 Data size: 55401 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string)\"}},\"Statistics:\":\"Num rows: 276 Data size: 55401 B
asic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 276 Data size: 55401 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{id}\"}}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 2\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"school\",\"children\":{\"Select Operator\":{\"expressions:\":\"state (type: string)\",\"outputColumnNames:\":[\"state\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"count(state)\"],\"keys:\":\"state (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string)\",\"sort order:\":\"+\",\"value expressions:\":\"_col1 (type: bigint)\",\"Statistics:\":\"Num rows: 503 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: s
tring)\"}},\"Statistics:\":\"Num rows: 503 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 503 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 503 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 5\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string)\"}},\"Statistics:\":\"Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"1\"}},\"Statistics:\":\"Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: NONE\"}}},\"Reducer 4\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expr
essions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"Statistics:\":\"Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"1\"}},\"Statistics:\":\"Num rows: 251 Data size: 25132 Basic stats: COMPLETE Column stats: NONE\"}}},\"Reducer 7\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"File Output Operator\":{\"Statistics:\":\"Num rows: 361 Data size: 75296 Basic stats: COMPLETE Column stats: NONE\",\"compressed:\":\"false\",\"table:\":{\"serde:\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",\"input format:\":\"org.apache.hadoop.mapred.TextInputFormat\",\"output format:\":\"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\"}}},\"Statistics:\":\"Num rows: 361 Data size: 75296 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 6\":{\"Map Operator Tree:\":[{\"TableScan\":{\"filte
rExpr:\":\"(yearmin > 1990) (type: boolean)\",\"alias:\":\"players\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(yearmin > 1990) (type: boolean)\",\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"_col0 (type: string)\",\"0\":\"schoolid (type: string)\"},\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string), _col1 (type: string), _col2 (type: int), _col3 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\"],\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"+\",\"value expressions:\":\"_col0 (type: string), _col1 (type: string), _col2 (type: int), _col3 (type: int)\",\"Statistics:\":\"Num rows: 361 Data size: 75296 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: string)\"}},\"Statistics:\":\"Num rows: 361 Data size: 75296 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 361 Data size: 75296 Basic
stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{id} {schoolid} {yearmin} {yearmax}\"}}},\"Statistics:\":\"Num rows: 329 Data size: 68451 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 987 Data size: 205354 Basic stats: COMPLETE Column stats: NONE\"}}]}},\"Edges:\":{\"Reducer 3\":{\"parent\":\"Map 2\",\"type\":\"SIMPLE_EDGE\"},\"Map 1\":{\"parent\":\"Reducer 5\",\"type\":\"BROADCAST_EDGE\"},\"Reducer 5\":{\"parent\":\"Reducer 4\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 4\":{\"parent\":\"Reducer 3\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 7\":{\"parent\":\"Map 6\",\"type\":\"SIMPLE_EDGE\"},\"Map 6\":{\"parent\":\"Map 1\",\"type\":\"BROADCAST_EDGE\"}}}},\"Stage-0\":{\"Fetch Operator\":{\"limit:\":\"-1\",\"Processor Tree:\":{\"ListSink\":{}}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}}"
+ "status": true,
+ "query": "{\"queryText\":\"select state, count(id) as counts from school group by state sort by counts desc limit 10\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Tez\":{\"DagName:\":\":1\",\"Vertices:\":{\"Reducer 2\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"count(VALUE._col0)\"],\"keys:\":\"KEY._col0 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 B
asic stats: COMPLETE Column stats: NONE\"}}},\"Reducer 3\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"10\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 1\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"school\",\"children\":{\"Select Operator\":{\"expressions:\":\"state (type: string), id (type: string)\",\"outputColumnNames:\":[\"state\",\"id\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"count(id)\"],\"keys:\":\"state (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"chi
ldren\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string)\",\"sort order:\":\"+\",\"value expressions:\":\"_col1 (type: bigint)\",\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string)\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 4\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"File Output Operator\":{\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"compressed:\":\"false\",\"table:\":{\"serde:\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",\"input format:\":\"org.apache.hadoop.mapred.TextInputFormat\",\"output format:\":\"org.apach
e.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\"}}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"10\"}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\"}}}},\"Edges:\":{\"Reducer 2\":{\"parent\":\"Map 1\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 3\":{\"parent\":\"Reducer 2\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 4\":{\"parent\":\"Reducer 3\",\"type\":\"SIMPLE_EDGE\"}}}},\"Stage-0\":{\"Fetch Operator\":{\"limit:\":\"10\",\"Processor Tree:\":{\"ListSink\":{}}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}"
},
"primaryfilters": {
- "user": "hive"
+ "user": [
+ "hive"
+ ]
},
- "entity": "hive_20140220174444_ceb2def9-838c-44ba-bbc2-825b19b3d2d6",
+ "entity": "hive_20140226144444_6301b51e-d52c-4618-995f-573e3f59006c",
"entitytype": "HIVE_QUERY_ID"
},
{
- "starttime": 1392935263246,
+ "starttime": 1393439190536,
"events": [
{
- "timestamp": 1392935263246,
+ "timestamp": 1393439204537,
"eventtype": "QUERY_COMPLETED",
"eventinfo": {}
},
{
- "timestamp": 1392935263168,
+ "timestamp": 1393439190536,
"eventtype": "QUERY_SUBMITTED",
"eventinfo": {}
}
],
"otherinfo": {
- "query": "{\"query\":{\"queryText\":\" describe players\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Fetch Operator\":{\"limit:\":\"-1\",\"Processor Tree:\":{\"ListSink\":{}}}},\"Stage-0\":{\"Describe Table Operator:\":{\"Describe Table\":{\"table:\":\"players\"}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}}"
+ "status": true,
+ "query": "{\"queryText\":\"select state, count(id) as counts from school group by state sort by counts desc limit 10\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Tez\":{\"DagName:\":\"hive_20140226132525_780b8f71-bd4f-4daf-b0c3-4584920186d5:1\",\"Vertices:\":{\"Reducer 2\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"count(VALUE._col0)\"],\"keys:\":\"KEY._col0 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NON
E\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\"}}},\"Reducer 3\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"-\",\"value expressions:\":\"_col0 (type: string), _col1 (type: bigint)\",\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: bigint)\"}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"10\"}},\"Statistics:\":\"Num rows: 125 Data size: 25082 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 1\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"school\",\"children\":{\"Select Operator\":{\"expressions:\":\"state (type: string), id (type: string)\",\"outputColumnNames:\":[\"state\",\"id\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"count(id)\"],\"keys:\":\"state (type: stri
ng)\",\"outputColumnNames:\":[\"_col0\",\"_col1\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string)\",\"sort order:\":\"+\",\"value expressions:\":\"_col1 (type: bigint)\",\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string)\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 251 Data size: 50365 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 4\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"File Output Operator\":{\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"compressed:\":\"false\",\"table:\":{\"serde:\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",\"input format:\":\"org.apache.hadoop
.mapred.TextInputFormat\",\"output format:\":\"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\"}}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"10\"}},\"Statistics:\":\"Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE\"}}}},\"Edges:\":{\"Reducer 2\":{\"parent\":\"Map 1\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 3\":{\"parent\":\"Reducer 2\",\"type\":\"SIMPLE_EDGE\"},\"Reducer 4\":{\"parent\":\"Reducer 3\",\"type\":\"SIMPLE_EDGE\"}}}},\"Stage-0\":{\"Fetch Operator\":{\"limit:\":\"10\",\"Processor Tree:\":{\"ListSink\":{}}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}"
},
"primaryfilters": {
- "user": "hive"
+ "user": [
+ "hive"
+ ]
},
- "entity": "hive_20140220172727_9cb1b1a3-25bd-457b-81dc-60544c941cfa",
+ "entity": "hive_20140226132626_6c728aa4-47bd-4ae0-9bbc-776c491a1c41",
"entitytype": "HIVE_QUERY_ID"
},
{
- "starttime": 1392935263075,
+ "starttime": 1393439112167,
"events": [
{
- "timestamp": 1392935263156,
+ "timestamp": 1393439112748,
"eventtype": "QUERY_COMPLETED",
"eventinfo": {}
},
{
- "timestamp": 1392935263075,
+ "timestamp": 1393439112167,
"eventtype": "QUERY_SUBMITTED",
"eventinfo": {}
}
],
"otherinfo": {
- "query": "{\"query\":{\"queryText\":\"describe school\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Fetch Operator\":{\"limit:\":\"-1\",\"Processor Tree:\":{\"ListSink\":{}}}},\"Stage-0\":{\"Describe Table Operator:\":{\"Describe Table\":{\"table:\":\"school\"}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}}"
+ "status": true,
+ "query": "{\"queryText\":\"show tables\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Fetch Operator\":{\"limit:\":\"-1\",\"Processor Tree:\":{\"ListSink\":{}}}},\"Stage-0\":{\"Show Table Operator:\":{\"Show Tables\":{\"database name:\":\"default\"}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}"
},
"primaryfilters": {
- "user": "hive"
+ "user": [
+ "hive"
+ ]
},
- "entity": "hive_20140220172727_f6511c11-9788-4cab-a59e-9ce58adf5507",
+ "entity": "hive_20140226132525_780b8f71-bd4f-4daf-b0c3-4584920186d5",
"entitytype": "HIVE_QUERY_ID"
},
{
- "starttime": 1392935260100,
+ "starttime": 1393031638459,
"events": [
{
- "timestamp": 1392935260171,
+ "timestamp": 1393032494585,
"eventtype": "QUERY_COMPLETED",
"eventinfo": {}
},
{
- "timestamp": 1392935260100,
+ "timestamp": 1393031638459,
"eventtype": "QUERY_SUBMITTED",
"eventinfo": {}
}
],
"otherinfo": {
- "query": "{\"query\":{\"queryText\":\"describe school\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Fetch Operator\":{\"limit:\":\"-1\",\"Processor Tree:\":{\"ListSink\":{}}}},\"Stage-0\":{\"Describe Table Operator:\":{\"Describe Table\":{\"table:\":\"school\"}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}}"
+ "status": true,
+ "query": "{\"queryText\":\"\\nselect cs1.product_name ,cs1.store_name ,cs1.store_zip ,cs1.b_street_number ,cs1.b_streen_name ,cs1.b_city\\n ,cs1.b_zip ,cs1.c_street_number ,cs1.c_street_name ,cs1.c_city ,cs1.c_zip ,cs1.syear ,cs1.cnt\\n ,cs1.s1 ,cs1.s2 ,cs1.s3\\n ,cs2.s1 ,cs2.s2 ,cs2.s3 ,cs2.syear ,cs2.cnt\\nfrom\\n(select i_product_name as product_name ,i_item_sk as item_sk ,s_store_name as store_name\\n ,s_zip as store_zip ,ad1.ca_street_number as b_street_number ,ad1.ca_street_name as b_streen_name\\n ,ad1.ca_city as b_city ,ad1.ca_zip as b_zip ,ad2.ca_street_number as c_street_number\\n ,ad2.ca_street_name as c_street_name ,ad2.ca_city as c_city ,ad2.ca_zip as c_zip\\n ,d1.d_year as syear ,d2.d_year as fsyear ,d3.d_year as s2year ,count(*) as cnt\\n ,sum(ss_wholesale_cost) as s1 ,sum(ss_list_price) as s2 ,sum(ss_coupon_amt) as s3\\n FROM store_sales\\n JOIN store_returns ON store_sales.ss_item_sk = store_returns.sr_item_sk and st
ore_sales.ss_ticket_number = store_returns.sr_ticket_number\\n JOIN customer ON store_sales.ss_customer_sk = customer.c_customer_sk\\n JOIN date_dim d1 ON store_sales.ss_sold_date_sk = d1.d_date_sk\\n JOIN date_dim d2 ON customer.c_first_sales_date_sk = d2.d_date_sk \\n JOIN date_dim d3 ON customer.c_first_shipto_date_sk = d3.d_date_sk\\n JOIN store ON store_sales.ss_store_sk = store.s_store_sk\\n JOIN customer_demographics cd1 ON store_sales.ss_cdemo_sk= cd1.cd_demo_sk\\n JOIN customer_demographics cd2 ON customer.c_current_cdemo_sk = cd2.cd_demo_sk\\n JOIN promotion ON store_sales.ss_promo_sk = promotion.p_promo_sk\\n JOIN household_demographics hd1 ON store_sales.ss_hdemo_sk = hd1.hd_demo_sk\\n JOIN household_demographics hd2 ON customer.c_current_hdemo_sk = hd2.hd_demo_sk\\n JOIN customer_address ad1 ON store_sales.ss_addr_sk = ad1.ca_address_sk\\n JOIN customer_address ad2 ON customer.c_current_
addr_sk = ad2.ca_address_sk\\n JOIN income_band ib1 ON hd1.hd_income_band_sk = ib1.ib_income_band_sk\\n JOIN income_band ib2 ON hd2.hd_income_band_sk = ib2.ib_income_band_sk\\n JOIN item ON store_sales.ss_item_sk = item.i_item_sk\\n JOIN\\n (select cs_item_sk\\n ,sum(cs_ext_list_price) as sale,sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit) as refund\\n from catalog_sales JOIN catalog_returns\\n ON catalog_sales.cs_item_sk = catalog_returns.cr_item_sk\\n and catalog_sales.cs_order_number = catalog_returns.cr_order_number\\n group by cs_item_sk\\n having sum(cs_ext_list_price)>2*sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit)) cs_ui\\nON store_sales.ss_item_sk = cs_ui.cs_item_sk\\n WHERE \\n cd1.cd_marital_status <> cd2.cd_marital_status and\\n i_color in ('maroon','burnished','dim','steel','navajo','chocolate') and\\n i_current_price between 35 and 35 + 10 and\\n i_current_price between 35
+ 1 and 35 + 15\\ngroup by i_product_name ,i_item_sk ,s_store_name ,s_zip ,ad1.ca_street_number\\n ,ad1.ca_street_name ,ad1.ca_city ,ad1.ca_zip ,ad2.ca_street_number\\n ,ad2.ca_street_name ,ad2.ca_city ,ad2.ca_zip ,d1.d_year ,d2.d_year ,d3.d_year\\n) cs1\\nJOIN\\n(select i_product_name as product_name ,i_item_sk as item_sk ,s_store_name as store_name\\n ,s_zip as store_zip ,ad1.ca_street_number as b_street_number ,ad1.ca_street_name as b_streen_name\\n ,ad1.ca_city as b_city ,ad1.ca_zip as b_zip ,ad2.ca_street_number as c_street_number\\n ,ad2.ca_street_name as c_street_name ,ad2.ca_city as c_city ,ad2.ca_zip as c_zip\\n ,d1.d_year as syear ,d2.d_year as fsyear ,d3.d_year as s2year ,count(*) as cnt\\n ,sum(ss_wholesale_cost) as s1 ,sum(ss_list_price) as s2 ,sum(ss_coupon_amt) as s3\\n FROM store_sales\\n JOIN store_returns ON store_sales.ss_item_sk = store_returns.sr_item_sk and store_sales.ss_ticket_number = store_returns.sr_ticket_number\\
n JOIN customer ON store_sales.ss_customer_sk = customer.c_customer_sk\\n JOIN date_dim d1 ON store_sales.ss_sold_date_sk = d1.d_date_sk\\n JOIN date_dim d2 ON customer.c_first_sales_date_sk = d2.d_date_sk \\n JOIN date_dim d3 ON customer.c_first_shipto_date_sk = d3.d_date_sk\\n JOIN store ON store_sales.ss_store_sk = store.s_store_sk\\n JOIN customer_demographics cd1 ON store_sales.ss_cdemo_sk= cd1.cd_demo_sk\\n JOIN customer_demographics cd2 ON customer.c_current_cdemo_sk = cd2.cd_demo_sk\\n JOIN promotion ON store_sales.ss_promo_sk = promotion.p_promo_sk\\n JOIN household_demographics hd1 ON store_sales.ss_hdemo_sk = hd1.hd_demo_sk\\n JOIN household_demographics hd2 ON customer.c_current_hdemo_sk = hd2.hd_demo_sk\\n JOIN customer_address ad1 ON store_sales.ss_addr_sk = ad1.ca_address_sk\\n JOIN customer_address ad2 ON customer.c_current_addr_sk = ad2.ca_address_sk\\n JOIN income_band ib1 ON
hd1.hd_income_band_sk = ib1.ib_income_band_sk\\n JOIN income_band ib2 ON hd2.hd_income_band_sk = ib2.ib_income_band_sk\\n JOIN item ON store_sales.ss_item_sk = item.i_item_sk\\n JOIN\\n (select cs_item_sk\\n ,sum(cs_ext_list_price) as sale,sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit) as refund\\n from catalog_sales JOIN catalog_returns\\n ON catalog_sales.cs_item_sk = catalog_returns.cr_item_sk\\n and catalog_sales.cs_order_number = catalog_returns.cr_order_number\\n group by cs_item_sk\\n having sum(cs_ext_list_price)>2*sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit)) cs_ui\\nON store_sales.ss_item_sk = cs_ui.cs_item_sk\\n WHERE \\n cd1.cd_marital_status <> cd2.cd_marital_status and\\n i_color in ('maroon','burnished','dim','steel','navajo','chocolate') and\\n i_current_price between 35 and 35 + 10 and\\n i_current_price between 35 + 1 and 35 + 15\\ngroup by i_product_name ,i_item_sk ,s_store
_name ,s_zip ,ad1.ca_street_number\\n ,ad1.ca_street_name ,ad1.ca_city ,ad1.ca_zip ,ad2.ca_street_number\\n ,ad2.ca_street_name ,ad2.ca_city ,ad2.ca_zip ,d1.d_year ,d2.d_year ,d3.d_year\\n) cs2\\nON cs1.item_sk=cs2.item_sk\\nwhere \\n cs1.syear = 2000 and\\n cs2.syear = 2000 + 1 and\\n cs2.cnt <= cs1.cnt and\\n cs1.store_name = cs2.store_name and\\n cs1.store_zip = cs2.store_zip\\norder by cs1.product_name ,cs1.store_name ,cs2.cnt\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Tez\":{\"DagName:\":\"root_20140221171313_94b85642-2225-4317-ac6e-f337f6b1eeed:1\",\"Vertices:\":{\"Reducer 13\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"sum(VALUE._col0)\",\"sum(VALUE._col1)\"],\"keys:\":\"KEY._col0 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"(_col1 > (2 * _col2)) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressi
ons:\":\"_col0 (type: int)\",\"outputColumnNames:\":[\"_col0\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: int)\"}},\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 148520512 Data size: 12264903680 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 11\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"catalog_sales\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cs_item_sk (type: int), cs_order_number (type: int)\",\"sort order:\":\"++\",\"value expressions:\":\"cs_item_sk (type: int), cs_ext_list_price (type: float)
\",\"Statistics:\":\"Num rows: 270037278 Data size: 22299823475 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cs_item_sk (type: int), cs_order_number (type: int)\"}},\"Statistics:\":\"Num rows: 270037278 Data size: 22299823475 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 14\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col19\",\"_col39\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col141\",\"_col142\",\"_col145\",\"_col148\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col203\",\"_col233\",\"_col263\",\"_col287\",\"_col292\",\"_col304\",\"_col308\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"((((_col73 <> _col84) and (_col304) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate')) and _col292 BETWEEN 35 AND (35 + 10)) and _col292 BETWEEN (35 + 1) AND (35 + 15)) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressions:\":\"_col308 (type: string), _col287 (type: int), _col1
9 (type: string), _col39 (type: string), _col141 (type: string), _col142 (type: string), _col145 (type: string), _col148 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type: string), _col186 (type: string), _col203 (type: int), _col233 (type: int), _col263 (type: int), _col56 (type: float), _col57 (type: float), _col64 (type: float)\",\"outputColumnNames:\":[\"_col308\",\"_col287\",\"_col19\",\"_col39\",\"_col141\",\"_col142\",\"_col145\",\"_col148\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col203\",\"_col233\",\"_col263\",\"_col56\",\"_col57\",\"_col64\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"count()\",\"sum(_col56)\",\"sum(_col57)\",\"sum(_col64)\"],\"keys:\":\"_col308 (type: string), _col287 (type: int), _col19 (type: string), _col39 (type: string), _col141 (type: string), _col142 (type: string), _col145 (type: string), _col148 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type:
string), _col186 (type: string), _col203 (type: int), _col233 (type: int), _col263 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col13\",\"_col14\",\"_col15\",\"_col16\",\"_col17\",\"_col18\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string), _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col13 (type: int), _col14 (type: int)\",\"sort order:\":\"+++++++++++++++\",\"value expressions:\":\"_col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double)\",\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\",\"key expression
s:\":\"_col0 (type: string), _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col13 (type: int), _col14 (type: int)\"}},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 5055175680 Data size: 258801614848 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"},{\"\":\"Inner Join 0 to 2\"}],\"condition expressions:\":{\"2\":\"\",\"1\":\"{VALUE._col0} {VALUE._col5} {VALUE._col17} {VALUE._col21}\",\"0\":\"{VALUE._col19} {VALUE._col39} {VALUE._col56} {
VALUE._col57} {VALUE._col64} {VALUE._col73} {VALUE._col84} {VALUE._col141} {VALUE._col142} {VALUE._col145} {VALUE._col148} {VALUE._col184} {VALUE._col185} {VALUE._col188} {VALUE._col191} {VALUE._col203} {VALUE._col233} {VALUE._col263}\"}}}},\"Reducer 12\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col15\",\"_col25\",\"_col60\",\"_col61\",\"_col62\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col15 (type: int), _col25 (type: float), _col60 (type: float), _col61 (type: float), _col62 (type: float)\",\"outputColumnNames:\":[\"_col15\",\"_col25\",\"_col60\",\"_col61\",\"_col62\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"sum(_col25)\",\"sum(((_col60 + _col61) + _col62))\"],\"keys:\":\"_col15 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"_col1 (t
ype: double), _col2 (type: double)\",\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: int)\"}},\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{VALUE._col23} {VALUE._col24} {VALUE._col25}\",\"0\":\"{VALUE._col15} {VALUE._col25}\"}}}},\"Map 10\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ib1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ib_income_band_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats
: NONE\",\"key expressions:\":\"ib_income_band_sk (type: int)\"}},\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 19\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"customer\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"c_customer_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"c_current_cdemo_sk (type: int), c_current_hdemo_sk (type: int), c_current_addr_sk (type: int), c_first_shipto_date_sk (type: int), c_first_sales_date_sk (type: int)\",\"Statistics:\":\"Num rows: 1600000 Data size: 59241136 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"c_customer_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1600000 Data size: 59241136 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 16\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store_sales\",\"children\":{\"Reduce Output Operator
\":{\"Map-reduce partition columns:\":\"ss_item_sk (type: int), ss_ticket_number (type: int)\",\"sort order:\":\"++\",\"value expressions:\":\"ss_sold_date_sk (type: int), ss_item_sk (type: int), ss_customer_sk (type: int), ss_cdemo_sk (type: int), ss_hdemo_sk (type: int), ss_addr_sk (type: int), ss_store_sk (type: int), ss_promo_sk (type: int), ss_wholesale_cost (type: float), ss_list_price (type: float), ss_coupon_amt (type: float)\",\"Statistics:\":\"Num rows: 550076554 Data size: 28161379051 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ss_item_sk (type: int), ss_ticket_number (type: int)\"}},\"Statistics:\":\"Num rows: 550076554 Data size: 28161379051 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 17\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col0\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col11\",\"_col12\",\"_col19\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"c_custome
r_sk (type: int)\",\"0\":\"_col3 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col2\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col11\",\"_col12\",\"_col19\",\"_col51\",\"_col52\",\"_col53\",\"_col54\",\"_col55\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col0 (type: int)\"},\"outputColumnNames:\":[\"_col2\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col11\",\"_col12\",\"_col19\",\"_col28\",\"_col29\",\"_col30\",\"_col31\",\"_col32\",\"_col75\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col32 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col32\",\"_col34\",\"_col35\",\"_col36\",\"_col37\",\"_col38\",\"_col41\",\"_col42\",\"_col49\",\"_col58\",\"_col59\",\"_col60\",\"_col61\",\"_col105\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col61 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col62\",\"_col6
4\",\"_col65\",\"_col66\",\"_col67\",\"_col68\",\"_col71\",\"_col72\",\"_col79\",\"_col88\",\"_col89\",\"_col90\",\"_col135\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"s_store_sk (type: int)\",\"0\":\"_col67 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col92\",\"_col94\",\"_col95\",\"_col96\",\"_col98\",\"_col101\",\"_col102\",\"_col109\",\"_col118\",\"_col119\",\"_col120\",\"_col164\",\"_col184\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"cd_demo_sk (type: int)\",\"0\":\"_col94 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\"_col129\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col150\",\"_col151\",\"_col192\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"cd_demo_sk (type: int)\",\"0\":\"_col149 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\
"_col129\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col161\",\"_col162\",\"_col203\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"p_promo_sk (type: int)\",\"0\":\"_col129 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col160\",\"_col172\",\"_col173\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"hd_demo_sk (type: int)\",\"0\":\"_col126 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col127\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col160\",\"_col193\",\"_col194\",\"_col234\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"hd_demo_sk (type: int)\",\"0\":\"_col193 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col91\",\"_col102\",\"_col122\",\"_col130\",\"_col134\",\"_col139\",\"_col140\",\"_col147\",\"_col156\",\"
_col167\",\"_col201\",\"_col241\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col134 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col13\",\"_col43\",\"_col73\",\"_col98\",\"_col109\",\"_col129\",\"_col137\",\"_col146\",\"_col147\",\"_col154\",\"_col163\",\"_col174\",\"_col208\",\"_col249\",\"_col250\",\"_col253\",\"_col256\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col208 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col8\",\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col178\",\"_col208\",\"_col238\",\"_col264\",\"_col265\",\"_col268\",\"_col271\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ib_income_band_sk (type: int)\",\"0\":\"_col8 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_c
ol84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col174\",\"_col175\",\"_col178\",\"_col181\",\"_col193\",\"_col223\",\"_col253\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ib_income_band_sk (type: int)\",\"0\":\"_col1 (type: int)\"},\"outputColumnNames:\":[\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col198\",\"_col228\",\"_col258\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col47 (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"_col19 (type: string), _col39 (type: string), _col56 (type: float), _col57 (type: float), _col64 (type: float), _col73 (type: string), _col84 (type: string), _col136 (type: string), _col137 (type: string), _col140 (type: string), _col143 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type: string), _col186 (type: string),
_col198 (type: int), _col228 (type: int), _col258 (type: int)\",\"Statistics:\":\"Num rows: 2297807104 Data size: 117637095424 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col47 (type: int)\"}},\"Statistics:\":\"Num rows: 2297807104 Data size: 117637095424 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col19} {_col39} {_col47} {_col56} {_col57} {_col64} {_col73} {_col84} {_col136} {_col137} {_col140} {_col143} {_col174} {_col175} {_col178} {_col181} {_col193} {_col223} {_col253}\"}}},\"Statistics:\":\"Num rows: 2088915456 Data size: 106942808064 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col1} {_col19} {_col39} {_col47} {_col56} {_col57} {_col64} {_col73} {_col84} {_col136} {_col137} {_col140} {_col143} {_col264} {_col265} {_col268} {_col271} {_col178} {_col208} {_col23
8}\"}}},\"Statistics:\":\"Num rows: 1899014016 Data size: 97220730880 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_street_number} {ca_street_name} {ca_city} {ca_zip}\",\"0\":\"{_col1} {_col98} {_col109} {_col129} {_col137} {_col146} {_col147} {_col154} {_col163} {_col174} {_col249} {_col250} {_col253} {_col256} {_col13} {_col43} {_col73}\"}}},\"Statistics:\":\"Num rows: 1726376320 Data size: 88382480384 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_street_number} {ca_street_name} {ca_city} {ca_zip}\",\"0\":\"{_col241} {_col6} {_col36} {_col66} {_col91} {_col102} {_col122} {_col130} {_col139} {_col140} {_col147} {_col156} {_col167} {_col201}\"}}},\"Statistics:\":\"Num rows: 1569432960 Data size: 80347709440 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition e
xpressions:\":{\"1\":\"{hd_income_band_sk}\",\"0\":\"{_col6} {_col36} {_col66} {_col234} {_col95} {_col115} {_col123} {_col127} {_col132} {_col133} {_col140} {_col149} {_col160} {_col194}\"}}},\"Statistics:\":\"Num rows: 1426757248 Data size: 73043369984 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{hd_income_band_sk}\",\"0\":\"{_col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col127} {_col132} {_col133} {_col140} {_col149} {_col160} {_col172} {_col173}\"}}},\"Statistics:\":\"Num rows: 1297052032 Data size: 66403065856 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col126} {_col127} {_col132} {_col133} {_col140} {_col149} {_col203} {_col161} {_col162}\"}}},\"Statistics:\":\"Num rows: 1179138176 Data size: 60366422016 Basic stats: COMPLETE Column
stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{cd_marital_status}\",\"0\":\"{_col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col126} {_col127} {_col129} {_col132} {_col133} {_col140} {_col192} {_col150} {_col151}\"}}},\"Statistics:\":\"Num rows: 1071943808 Data size: 54878564352 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{cd_marital_status}\",\"0\":\"{_col6} {_col36} {_col66} {_col164} {_col184} {_col92} {_col95} {_col96} {_col98} {_col101} {_col102} {_col109} {_col118} {_col119} {_col120}\"}}},\"Statistics:\":\"Num rows: 974494336 Data size: 49889603584 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{s_store_name} {s_zip}\",\"0\":\"{_col6} {_col36} {_col135} {_col62} {_col64} {_col65} {_col66} {_col68} {_col71} {_col72} {_col79} {_col88} {_col89} {_col90}\
"}}},\"Statistics:\":\"Num rows: 885903936 Data size: 45354184704 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col6} {_col105} {_col32} {_col34} {_col35} {_col36} {_col37} {_col38} {_col41} {_col42} {_col49} {_col58} {_col59} {_col60}\"}}},\"Statistics:\":\"Num rows: 805367168 Data size: 41231077376 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col75} {_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19} {_col28} {_col29} {_col30} {_col31}\"}}},\"Statistics:\":\"Num rows: 732151936 Data size: 37482795008 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19} {_col51} {_col52} {_col53} {_col54
} {_col55}\"}}},\"Statistics:\":\"Num rows: 665592640 Data size: 34075269120 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{c_current_cdemo_sk} {c_current_hdemo_sk} {c_current_addr_sk} {c_first_shipto_date_sk} {c_first_sales_date_sk}\",\"0\":\"{_col0} {_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19}\"}}},\"Statistics:\":\"Num rows: 605084224 Data size: 30977517568 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{VALUE._col0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12} {VALUE._col19}\"}}}},\"Map 18\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"cd1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cd_demo_sk (type: int)\",\"sort or
der:\":\"+\",\"value expressions:\":\"cd_marital_status (type: string)\",\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 15\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"count(VALUE._col0)\",\"sum(VALUE._col1)\",\"sum(VALUE._col2)\",\"sum(VALUE._col3)\"],\"keys:\":\"KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: string), KEY._col3 (type: string), KEY._col4 (type: string), KEY._col5 (type: string), KEY._col6 (type: string), KEY._col7 (type: string), KEY._col8 (type: string), KEY._col9 (type: string), KEY._col10 (type: string), KEY._col11 (type: string), KEY._col12 (type: int), KEY._col13 (type: int), KEY._col14 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\"
,\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col13\",\"_col14\",\"_col15\",\"_col16\",\"_col17\",\"_col18\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: string), _col1 (type: int), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col10\",\"_col11\",\"_col12\",\"_col15\",\"_col16\",\"_col17\",\"_col18\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col1 (type: int), _col2 (type: string), _col3 (type: string)\",\"sort order:\":\"+++\",\"value expressions:\":\"_col0 (type: string), _col2 (type
: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double)\",\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: int), _col2 (type: string), _col3 (type: string)\"}},\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 25\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"catalog_returns\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cr_item_sk (type: int), cr_order_number (type: int)\",\"sort order:\":\
"++\",\"value expressions:\":\"cr_refunded_cash (type: float), cr_reversed_charge (type: float), cr_store_credit (type: float)\",\"Statistics:\":\"Num rows: 28798881 Data size: 1681267447 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cr_item_sk (type: int), cr_order_number (type: int)\"}},\"Statistics:\":\"Num rows: 28798881 Data size: 1681267447 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 24\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store_returns\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"sr_item_sk (type: int), sr_ticket_number (type: int)\",\"sort order:\":\"++\",\"Statistics:\":\"Num rows: 79762591 Data size: 2561677244 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"sr_item_sk (type: int), sr_ticket_number (type: int)\"}},\"Statistics:\":\"Num rows: 79762591 Data size: 2561677244 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 23\":{\"Map Ope
rator Tree:\":[{\"TableScan\":{\"alias:\":\"item\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND (35 + 10)) and i_current_price BETWEEN (35 + 1) AND (35 + 15)) (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"i_item_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"i_item_sk (type: int), i_current_price (type: float), i_color (type: string), i_product_name (type: string)\",\"Statistics:\":\"Num rows: 6000 Data size: 433429 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"i_item_sk (type: int)\"}},\"Statistics:\":\"Num rows: 6000 Data size: 433429 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 48000 Data size: 3467433 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 22\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"hd
1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"hd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"hd_income_band_sk (type: int)\",\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"hd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 21\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"hd2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"hd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"hd_income_band_sk (type: int)\",\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"hd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 20\":{\"Execution mode:\":\"vectorized\",\"Ma
p Operator Tree:\":[{\"TableScan\":{\"alias:\":\"cd2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"cd_marital_status (type: string)\",\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 29\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d3\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_year (type: int)\",\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE
\"}}]},\"Reducer 27\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col15\",\"_col25\",\"_col60\",\"_col61\",\"_col62\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col15 (type: int), _col25 (type: float), _col60 (type: float), _col61 (type: float), _col62 (type: float)\",\"outputColumnNames:\":[\"_col15\",\"_col25\",\"_col60\",\"_col61\",\"_col62\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"sum(_col25)\",\"sum(((_col60 + _col61) + _col62))\"],\"keys:\":\"_col15 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"_col1 (type: double), _col2 (type: double)\",\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: int)\"}},\"Statistics:\":\"Num rows: 297041024 Data size:
24529807360 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 297041024 Data size: 24529807360 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{VALUE._col23} {VALUE._col24} {VALUE._col25}\",\"0\":\"{VALUE._col15} {VALUE._col25}\"}}}},\"Reducer 28\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"sum(VALUE._col0)\",\"sum(VALUE._col1)\"],\"keys:\":\"KEY._col0 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"(_col1 > (2 * _col2)) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: int)\",\"outputColumnNames:\":[\"_col0\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: int)\",\"sort
order:\":\"+\",\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: int)\"}},\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 49506837 Data size: 4088301199 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 148520512 Data size: 12264903680 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 26\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"catalog_sales\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cs_item_sk (type: int), cs_order_number (type: int)\",\"sort order:\":\"++\",\"value expressions:\":\"cs_item_sk (type: int), cs_ext_list_price (type: float)\",\"Statistics:\":\"Num rows: 270037278 Data size: 22299823475 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cs_item_sk (type: int), cs_order_number
(type: int)\"}},\"Statistics:\":\"Num rows: 270037278 Data size: 22299823475 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 30\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ad2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ca_address_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"ca_street_number (type: string), ca_street_name (type: string), ca_city (type: string), ca_zip (type: string)\",\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ca_address_sk (type: int)\"}},\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 32\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ad1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ca_address_sk (type: int)\",\"sort order:\":\"+\",\"value expressi
ons:\":\"ca_street_number (type: string), ca_street_name (type: string), ca_city (type: string), ca_zip (type: string)\",\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ca_address_sk (type: int)\"}},\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 31\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"customer\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"c_customer_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"c_current_cdemo_sk (type: int), c_current_hdemo_sk (type: int), c_current_addr_sk (type: int), c_first_shipto_date_sk (type: int), c_first_sales_date_sk (type: int)\",\"Statistics:\":\"Num rows: 1600000 Data size: 59241136 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"c_customer_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1600000 Data s
ize: 59241136 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 34\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"s_store_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"s_store_name (type: string), s_zip (type: string)\",\"Statistics:\":\"Num rows: 74 Data size: 15175 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"s_store_sk (type: int)\"}},\"Statistics:\":\"Num rows: 74 Data size: 15175 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 33\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store_returns\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"sr_item_sk (type: int), sr_ticket_number (type: int)\",\"sort order:\":\"++\",\"Statistics:\":\"Num rows: 79762591 Data size: 2561677244 Basic stats: COMPLETE Column stats: NONE\",\"key expression
s:\":\"sr_item_sk (type: int), sr_ticket_number (type: int)\"}},\"Statistics:\":\"Num rows: 79762591 Data size: 2561677244 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 1\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"hd1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"hd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"hd_income_band_sk (type: int)\",\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"hd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 36\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_year (type: int)\",\"Statistics:\":\"Num rows: 7
3049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 2\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"hd2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"hd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"hd_income_band_sk (type: int)\",\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"hd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 7200 Data size: 713 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 35\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d1\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(d_year = 2000) (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition colu
mns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_year (type: int)\",\"Statistics:\":\"Num rows: 36524 Data size: 163993 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 36524 Data size: 163993 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 3\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"promotion\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"p_promo_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 450 Data size: 14450 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"p_promo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 450 Data size: 14450 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 38\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableSca
n\":{\"alias:\":\"catalog_returns\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cr_item_sk (type: int), cr_order_number (type: int)\",\"sort order:\":\"++\",\"value expressions:\":\"cr_refunded_cash (type: float), cr_reversed_charge (type: float), cr_store_credit (type: float)\",\"Statistics:\":\"Num rows: 28798881 Data size: 1681267447 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cr_item_sk (type: int), cr_order_number (type: int)\"}},\"Statistics:\":\"Num rows: 28798881 Data size: 1681267447 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 5\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col0\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col11\",\"_col12\",\"_col19\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"c_customer_sk (type: int)\",\"0\":\"_col3 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col2\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",
\"_col8\",\"_col11\",\"_col12\",\"_col19\",\"_col51\",\"_col52\",\"_col53\",\"_col54\",\"_col55\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col0 (type: int)\"},\"outputColumnNames:\":[\"_col2\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col11\",\"_col12\",\"_col19\",\"_col28\",\"_col29\",\"_col30\",\"_col31\",\"_col32\",\"_col75\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col32 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col32\",\"_col34\",\"_col35\",\"_col36\",\"_col37\",\"_col38\",\"_col41\",\"_col42\",\"_col49\",\"_col58\",\"_col59\",\"_col60\",\"_col61\",\"_col105\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"_col61 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col62\",\"_col64\",\"_col65\",\"_col66\",\"_col67\",\"_col68\",\"_col71\",\"_col72\",\"_col79\",\"_col88\",\"_col89\",\"_col90\",\"_col135\"],\"chi
ldren\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"s_store_sk (type: int)\",\"0\":\"_col67 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col92\",\"_col94\",\"_col95\",\"_col96\",\"_col98\",\"_col101\",\"_col102\",\"_col109\",\"_col118\",\"_col119\",\"_col120\",\"_col164\",\"_col184\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"cd_demo_sk (type: int)\",\"0\":\"_col94 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\"_col129\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col150\",\"_col151\",\"_col192\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"cd_demo_sk (type: int)\",\"0\":\"_col149 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\"_col129\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col161\",\"_col162\",\"_col203\"],\"children\":{\"Map Join Operator\":
{\"keys:\":{\"1\":\"p_promo_sk (type: int)\",\"0\":\"_col129 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col126\",\"_col127\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col160\",\"_col172\",\"_col173\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"hd_demo_sk (type: int)\",\"0\":\"_col126 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col95\",\"_col115\",\"_col123\",\"_col127\",\"_col132\",\"_col133\",\"_col140\",\"_col149\",\"_col160\",\"_col193\",\"_col194\",\"_col234\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"hd_demo_sk (type: int)\",\"0\":\"_col193 (type: int)\"},\"outputColumnNames:\":[\"_col6\",\"_col36\",\"_col66\",\"_col91\",\"_col102\",\"_col122\",\"_col130\",\"_col134\",\"_col139\",\"_col140\",\"_col147\",\"_col156\",\"_col167\",\"_col201\",\"_col241\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col1
34 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col13\",\"_col43\",\"_col73\",\"_col98\",\"_col109\",\"_col129\",\"_col137\",\"_col146\",\"_col147\",\"_col154\",\"_col163\",\"_col174\",\"_col208\",\"_col249\",\"_col250\",\"_col253\",\"_col256\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col208 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col8\",\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col178\",\"_col208\",\"_col238\",\"_col264\",\"_col265\",\"_col268\",\"_col271\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ib_income_band_sk (type: int)\",\"0\":\"_col8 (type: int)\"},\"outputColumnNames:\":[\"_col1\",\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col174\",\"_col175\",\"_col178\",\"_col181\",\"_col193\",\"_col223\",\"_co
l253\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ib_income_band_sk (type: int)\",\"0\":\"_col1 (type: int)\"},\"outputColumnNames:\":[\"_col19\",\"_col39\",\"_col47\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col136\",\"_col137\",\"_col140\",\"_col143\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col198\",\"_col228\",\"_col258\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col47 (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"_col19 (type: string), _col39 (type: string), _col56 (type: float), _col57 (type: float), _col64 (type: float), _col73 (type: string), _col84 (type: string), _col136 (type: string), _col137 (type: string), _col140 (type: string), _col143 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type: string), _col186 (type: string), _col198 (type: int), _col228 (type: int), _col258 (type: int)\",\"Statistics:\":\"Num rows: 2297807104 Data size: 117637095424 Basi
c stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col47 (type: int)\"}},\"Statistics:\":\"Num rows: 2297807104 Data size: 117637095424 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col19} {_col39} {_col47} {_col56} {_col57} {_col64} {_col73} {_col84} {_col136} {_col137} {_col140} {_col143} {_col174} {_col175} {_col178} {_col181} {_col193} {_col223} {_col253}\"}}},\"Statistics:\":\"Num rows: 2088915456 Data size: 106942808064 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col1} {_col19} {_col39} {_col47} {_col56} {_col57} {_col64} {_col73} {_col84} {_col136} {_col137} {_col140} {_col143} {_col264} {_col265} {_col268} {_col271} {_col178} {_col208} {_col238}\"}}},\"Statistics:\":\"Num rows: 1899014016 Data size: 97220730880 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":
[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_street_number} {ca_street_name} {ca_city} {ca_zip}\",\"0\":\"{_col1} {_col98} {_col109} {_col129} {_col137} {_col146} {_col147} {_col154} {_col163} {_col174} {_col249} {_col250} {_col253} {_col256} {_col13} {_col43} {_col73}\"}}},\"Statistics:\":\"Num rows: 1726376320 Data size: 88382480384 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_street_number} {ca_street_name} {ca_city} {ca_zip}\",\"0\":\"{_col241} {_col6} {_col36} {_col66} {_col91} {_col102} {_col122} {_col130} {_col139} {_col140} {_col147} {_col156} {_col167} {_col201}\"}}},\"Statistics:\":\"Num rows: 1569432960 Data size: 80347709440 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{hd_income_band_sk}\",\"0\":\"{_col6} {_col36} {_col66} {_col234} {_col95} {_col115} {_col123} {_col127} {_co
l132} {_col133} {_col140} {_col149} {_col160} {_col194}\"}}},\"Statistics:\":\"Num rows: 1426757248 Data size: 73043369984 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{hd_income_band_sk}\",\"0\":\"{_col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col127} {_col132} {_col133} {_col140} {_col149} {_col160} {_col172} {_col173}\"}}},\"Statistics:\":\"Num rows: 1297052032 Data size: 66403065856 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{_col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col126} {_col127} {_col132} {_col133} {_col140} {_col149} {_col203} {_col161} {_col162}\"}}},\"Statistics:\":\"Num rows: 1179138176 Data size: 60366422016 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{cd_marital_status}\",\"0\":\"{_
col6} {_col36} {_col66} {_col95} {_col115} {_col123} {_col126} {_col127} {_col129} {_col132} {_col133} {_col140} {_col192} {_col150} {_col151}\"}}},\"Statistics:\":\"Num rows: 1071943808 Data size: 54878564352 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{cd_marital_status}\",\"0\":\"{_col6} {_col36} {_col66} {_col164} {_col184} {_col92} {_col95} {_col96} {_col98} {_col101} {_col102} {_col109} {_col118} {_col119} {_col120}\"}}},\"Statistics:\":\"Num rows: 974494336 Data size: 49889603584 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{s_store_name} {s_zip}\",\"0\":\"{_col6} {_col36} {_col135} {_col62} {_col64} {_col65} {_col66} {_col68} {_col71} {_col72} {_col79} {_col88} {_col89} {_col90}\"}}},\"Statistics:\":\"Num rows: 885903936 Data size: 45354184704 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"
\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col6} {_col105} {_col32} {_col34} {_col35} {_col36} {_col37} {_col38} {_col41} {_col42} {_col49} {_col58} {_col59} {_col60}\"}}},\"Statistics:\":\"Num rows: 805367168 Data size: 41231077376 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col75} {_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19} {_col28} {_col29} {_col30} {_col31}\"}}},\"Statistics:\":\"Num rows: 732151936 Data size: 37482795008 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_year}\",\"0\":\"{_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19} {_col51} {_col52} {_col53} {_col54} {_col55}\"}}},\"Statistics:\":\"Num rows: 665592640 Data size: 34075269120 Basic stats: COMPLETE Column stats: NONE\",\"condition
map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{c_current_cdemo_sk} {c_current_hdemo_sk} {c_current_addr_sk} {c_first_shipto_date_sk} {c_first_sales_date_sk}\",\"0\":\"{_col0} {_col2} {_col4} {_col5} {_col6} {_col7} {_col8} {_col11} {_col12} {_col19}\"}}},\"Statistics:\":\"Num rows: 605084224 Data size: 30977517568 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"\",\"0\":\"{VALUE._col0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12} {VALUE._col19}\"}}}},\"Map 37\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ib2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ib_income_band_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"
ib_income_band_sk (type: int)\"}},\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 7\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"count(VALUE._col0)\",\"sum(VALUE._col1)\",\"sum(VALUE._col2)\",\"sum(VALUE._col3)\"],\"keys:\":\"KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: string), KEY._col3 (type: string), KEY._col4 (type: string), KEY._col5 (type: string), KEY._col6 (type: string), KEY._col7 (type: string), KEY._col8 (type: string), KEY._col9 (type: string), KEY._col10 (type: string), KEY._col11 (type: string), KEY._col12 (type: int), KEY._col13 (type: int), KEY._col14 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col13\",\"_col14\",\"_col15\",\"_col16\",\"_col17\",\"_col18\"],\"children\":{\"Select Operator\":{\"expressions:\":
\"_col1 (type: int), _col12 (type: int), _col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col2 (type: string), _col3 (type: string)\",\"outputColumnNames:\":[\"_col1\",\"_col12\",\"_col15\",\"_col16\",\"_col17\",\"_col18\",\"_col2\",\"_col3\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col1 (type: int), _col2 (type: string), _col3 (type: string)\",\"sort order:\":\"+++\",\"value expressions:\":\"_col2 (type: string), _col3 (type: string), _col12 (type: int), _col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double)\",\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: int), _col2 (type: string), _col3 (type: string)\"}},\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 315948480 Data size: 16175100928 B
asic stats: COMPLETE Column stats: NONE\"}}},\"Map 39\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"item\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND (35 + 10)) and i_current_price BETWEEN (35 + 1) AND (35 + 15)) (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"i_item_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"i_item_sk (type: int), i_current_price (type: float), i_color (type: string), i_product_name (type: string)\",\"Statistics:\":\"Num rows: 6000 Data size: 433429 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"i_item_sk (type: int)\"}},\"Statistics:\":\"Num rows: 6000 Data size: 433429 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 48000 Data size: 3467433 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 6\":{\"Reduce Operator Tre
e:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col19\",\"_col39\",\"_col56\",\"_col57\",\"_col64\",\"_col73\",\"_col84\",\"_col141\",\"_col142\",\"_col145\",\"_col148\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col203\",\"_col233\",\"_col263\",\"_col287\",\"_col292\",\"_col304\",\"_col308\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"((((_col73 <> _col84) and (_col304) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate')) and _col292 BETWEEN 35 AND (35 + 10)) and _col292 BETWEEN (35 + 1) AND (35 + 15)) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressions:\":\"_col308 (type: string), _col287 (type: int), _col19 (type: string), _col39 (type: string), _col141 (type: string), _col142 (type: string), _col145 (type: string), _col148 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type: string), _col186 (type: string), _col203 (type: int), _col233 (type: int), _col263 (type: int), _col56 (type: float), _col57 (type:
float), _col64 (type: float)\",\"outputColumnNames:\":[\"_col308\",\"_col287\",\"_col19\",\"_col39\",\"_col141\",\"_col142\",\"_col145\",\"_col148\",\"_col179\",\"_col180\",\"_col183\",\"_col186\",\"_col203\",\"_col233\",\"_col263\",\"_col56\",\"_col57\",\"_col64\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"count()\",\"sum(_col56)\",\"sum(_col57)\",\"sum(_col64)\"],\"keys:\":\"_col308 (type: string), _col287 (type: int), _col19 (type: string), _col39 (type: string), _col141 (type: string), _col142 (type: string), _col145 (type: string), _col148 (type: string), _col179 (type: string), _col180 (type: string), _col183 (type: string), _col186 (type: string), _col203 (type: int), _col233 (type: int), _col263 (type: int)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col13\",\"_col14\",\"_col15\",\"_col16\",\"_col17\",\"_col18\"],\"children
\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: string), _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col13 (type: int), _col14 (type: int)\",\"sort order:\":\"+++++++++++++++\",\"value expressions:\":\"_col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double)\",\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string), _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col13 (type: int), _col14 (type: int)\"}
},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 631896960 Data size: 32350201856 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 5055175680 Data size: 258801614848 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"},{\"\":\"Inner Join 0 to 2\"}],\"condition expressions:\":{\"2\":\"\",\"1\":\"{VALUE._col0} {VALUE._col5} {VALUE._col17} {VALUE._col21}\",\"0\":\"{VALUE._col19} {VALUE._col39} {VALUE._col56} {VALUE._col57} {VALUE._col64} {VALUE._col73} {VALUE._col84} {VALUE._col141} {VALUE._col142} {VALUE._col145} {VALUE._col148} {VALUE._col184} {VALUE._col185} {VALUE._col188} {VALUE._col191} {VALUE._col203} {VALUE._col233} {VALUE._col263}\"}}}},\"Reducer 9\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"File Output Operato
r\":{\"Statistics:\":\"Num rows: 7240486 Data size: 370679424 Basic stats: COMPLETE Column stats: NONE\",\"compressed:\":\"false\",\"table:\":{\"serde:\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",\"input format:\":\"org.apache.hadoop.mapred.TextInputFormat\",\"output format:\":\"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\"}}},\"Statistics:\":\"Num rows: 7240486 Data size: 370679424 Basic stats: COMPLETE Column stats: NONE\"}}},\"Reducer 8\":{\"Reduce Operator Tree:\":{\"Join Operator\":{\"outputColumnNames:\":[\"_col0\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col15\",\"_col16\",\"_col17\",\"_col18\",\"_col21\",\"_col22\",\"_col31\",\"_col34\",\"_col35\",\"_col36\",\"_col37\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"(((((_col12 = 2000) and (_col31 = (2000 + 1))) and (_col34 <= _col15)) and (_col2 = _col21)) and (_col3 = _col22)) (type: boolean)\",\"children\":{\"Select
Operator\":{\"expressions:\":\"_col0 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: string), _col12 (type: int), _col15 (type: bigint), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col35 (type: double), _col36 (type: double), _col37 (type: double), _col31 (type: int), _col34 (type: bigint)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\",\"_col7\",\"_col8\",\"_col9\",\"_col10\",\"_col11\",\"_col12\",\"_col13\",\"_col14\",\"_col15\",\"_col16\",\"_col17\",\"_col18\",\"_col19\",\"_col20\"],\"children\":{\"Reduce Output Operator\":{\"sort order:\":\"+++\",\"value expressions:\":\"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7
(type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: int), _col12 (type: bigint), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: int), _col20 (type: bigint)\",\"Statistics:\":\"Num rows: 7240486 Data size: 370679424 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string), _col1 (type: string), _col20 (type: bigint)\"}},\"Statistics:\":\"Num rows: 7240486 Data size: 370679424 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 7240486 Data size: 370679424 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 347543328 Data size: 17792612352 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{VALUE._col2} {VALUE._col3} {VALUE._col12} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18
}\",\"0\":\"{VALUE._col0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col9} {VALUE._col10} {VALUE._col11} {VALUE._col12} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}\"}}}},\"Map 4\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store_sales\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ss_item_sk (type: int), ss_ticket_number (type: int)\",\"sort order:\":\"++\",\"value expressions:\":\"ss_sold_date_sk (type: int), ss_item_sk (type: int), ss_customer_sk (type: int), ss_cdemo_sk (type: int), ss_hdemo_sk (type: int), ss_addr_sk (type: int), ss_store_sk (type: int), ss_promo_sk (type: int), ss_wholesale_cost (type: float), ss_list_price (type: float), ss_coupon_amt (type: float)\",\"Statistics:\":\"Num rows: 550076554 Data size: 28161379051 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ss_item_sk (type: int), ss_tic
ket_number (type: int)\"}},\"Statistics:\":\"Num rows: 550076554 Data size: 28161379051 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 43\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"cd2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"cd_marital_status (type: string)\",\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"cd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 42\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ib2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ib_income_band_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\
",\"key expressions:\":\"ib_income_band_sk (type: int)\"}},\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 41\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ib1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ib_income_band_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ib_income_band_sk (type: int)\"}},\"Statistics:\":\"Num rows: 20 Data size: 306 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 40\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"cd1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"cd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"cd_marital_status (type: string)\",\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Co
lumn stats: NONE\",\"key expressions:\":\"cd_demo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 1920800 Data size: 31322 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 47\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d3\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_year (type: int)\",\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 46\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d2\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_year (type: int)\",\"Statistics:\":\"Num rows: 73049 D
ata size: 327991 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 73049 Data size: 327991 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 45\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"promotion\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"p_promo_sk (type: int)\",\"sort order:\":\"+\",\"Statistics:\":\"Num rows: 450 Data size: 14450 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"p_promo_sk (type: int)\"}},\"Statistics:\":\"Num rows: 450 Data size: 14450 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 44\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"ad1\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ca_address_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"ca_street_number (type: string), ca_street_name (type:
string), ca_city (type: string), ca_zip (type: string)\",\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ca_address_sk (type: int)\"}},\"Statistics:\":\"Num rows: 800000 Data size: 9327264 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 49\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"d1\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(d_year = (
<TRUNCATED>