http://git-wip-us.apache.org/repos/asf/ambari/blob/bd3a0bb7/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 deleted file mode 100644 index e77dcc4..0000000 --- a/ambari-web/app/assets/data/jobs/hive-queries.json +++ /dev/null @@ -1,232 +0,0 @@ -{ - "entities": [ - { - "starttime": 1393443850756, - "events": [ - { - "timestamp": 1393443875265, - "eventtype": "QUERY_COMPLETED", - "eventinfo": {} - }, - { - "timestamp": 1393443850756, - "eventtype": "QUERY_SUBMITTED", - "eventinfo": {} - } - ], - "otherinfo": { - "status": false, - "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" - ] - }, - "entity": "hive_20140226144444_6301b51e-d52c-4618-995f-573e3f59006c", - "entitytype": "HIVE_QUERY_ID" - }, - { - "starttime": 1394569191001, - "events": [ - { - "timestamp": 1394569191001, - "eventtype": "QUERY_SUBMITTED", - "eventinfo": {} - } - ], - "otherinfo": { - "query": "{\"queryText\":\"select c_last_name, c_first_name, ca_city, bought_city,\\n ss_ticket_number, amt, profit\\n from (select ss_ticket_number,\\n ss_customer_sk,\\n ca_city as bought_city,\\n sum(ss_coupon_amt) as amt,\\n sum(ss_net_profit) as profit\\n from store_sales, date_dim, store, household_demographics, customer_address\\n where store_sales.ss_sold_date_sk = date_dim.d_date_sk\\n and store_sales.ss_store_sk = store.s_store_sk\\n and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk\\n and store_sales.ss_addr_sk = customer_address.ca_address_sk\\n and (hou sehold_demographics.hd_dep_count = 4\\n or household_demographics.hd_vehicle_count= 3)\\n and date_dim.d_dow in (6,0)\\n and date_dim.d_year in (1999, 1999+1, 1999+2)\\n and store.s_city in ('Fairview', 'Fairview', 'Fairview', 'Midway', 'Fairview')\\n group by ss_ticket_number, ss_customer_sk, ss_addr_sk, ca_city) dn,\\n customer, customer_address current_addr\\n where dn.ss_customer_sk = customer.c_customer_sk\\n and customer.c_current_addr_sk = current_addr.ca_address_sk\\n and current_addr.ca_city <> dn.bought_city\\n order by c_last_name, c_first_name, ca_city, bought_city, ss_ticket_number\\n limit 100\",\"queryPlan\":{\"STAGE PLANS\":{\"Stage-1\":{\"Tez\" :{\"DagName:\":\"hrt_qa_20140311131919_1d932567-71c2-4341-9b50-6df1f58a9114:1\",\"Vertices:\":{\"Reducer 3\":{\"Reduce Operator Tree:\":{\"Group By Operator\":{\"mode:\":\"mergepartial\",\"aggregations:\":[\"sum(VALUE._col0)\",\"sum(VALUE._col1)\"],\"keys:\":\"KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: int), KEY._col3 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\"],\"children\":{\"Select Operator\":{\"expressions:\":\"_col0 (type: int), _col1 (type: int), _col3 (type: string), _col4 (type: decimal(17,2)), _col5 (type: decimal(17,2))\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col1 (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"_col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: decimal(17,2)), _col4 (type: decimal(17,2))\",\"Statistics:\":\"Num rows: 16473 Data size : 21775806 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col1 (type: int)\"}},\"Statistics:\":\"Num rows: 16473 Data size: 21775806 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 16473 Data size: 21775806 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 1\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"filterExpr:\":\"((hd_dep_count = 4) or (hd_vehicle_count = 3)) (type: boolean)\",\"alias:\":\"household_demographics\",\"children\":{\"Filter Operator\":{\"predicate:\":\"((hd_dep_count = 4) or (hd_vehicle_count = 3)) (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"hd_demo_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"hd_demo_sk (type: int), hd_dep_count (type: int), hd_vehicle_count (type: int)\",\"Statistics:\":\"Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"hd_demo_sk (type: int)\"}}, \"Statistics:\":\"Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 2\":{\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"store_sales\",\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"d_date_sk (type: int)\",\"0\":\"ss_sold_date_sk (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col3\",\"_col5\",\"_col6\",\"_col8\",\"_col18\",\"_col21\",\"_col22\",\"_col25\",\"_col31\",\"_col32\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"UDFToDouble(s_store_sk) (type: double)\",\"0\":\"UDFToDouble(_col22) (type: double)\"},\"outputColumnNames:\":[\"_col0\",\"_col3\",\"_col5\",\"_col6\",\"_col8\",\"_col18\",\"_col21\",\"_col22\",\"_col25\",\"_col31\",\"_col32\",\"_col55\",\"_col77\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"hd_demo_sk (type: int)\",\"0\":\"_col5 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col22\",\"_c ol31\",\"_col34\",\"_col36\",\"_col37\",\"_col39\",\"_col49\",\"_col52\",\"_col53\",\"_col56\",\"_col62\",\"_col63\",\"_col86\",\"_col89\",\"_col90\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col37 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col3\",\"_col4\",\"_col7\",\"_col29\",\"_col38\",\"_col41\",\"_col43\",\"_col44\",\"_col46\",\"_col56\",\"_col59\",\"_col60\",\"_col63\",\"_col69\",\"_col70\",\"_col93\",\"_col99\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"((((((((_col38 = _col63) and (_col60 = _col7)) and (_col43 = _col0)) and (_col44 = _col93)) and ((_col3 = 4) or (_col4 = 3))) and (_col70) IN (6, 0)) and (_col69) IN (1999, (1999 + 1), (1999 + 2))) and (_col29) IN ('Fairview', 'Fairview', 'Fairview', 'Midway', 'Fairview')) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressions:\":\"_col46 (type: int), _col41 (type: int), _col44 (type: int), _col99 (type: string), _col56 (type: decimal(7,2)), _co l59 (type: decimal(7,2))\",\"outputColumnNames:\":[\"_col46\",\"_col41\",\"_col44\",\"_col99\",\"_col56\",\"_col59\"],\"children\":{\"Group By Operator\":{\"mode:\":\"hash\",\"aggregations:\":[\"sum(_col56)\",\"sum(_col59)\"],\"keys:\":\"_col46 (type: int), _col41 (type: int), _col44 (type: int), _col99 (type: string)\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\"],\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)\",\"sort order:\":\"++++\",\"value expressions:\":\"_col4 (type: decimal(17,2)), _col5 (type: decimal(17,2))\",\"Statistics:\":\"Num rows: 32946 Data size: 43551613 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)\"}},\"Statistics:\":\"Num rows: 32946 Data size: 43551613 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 32946 Data size: 43551613 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 32946 Data size: 43551613 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 4217199 Data size: 5574753280 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_address_sk} {ca_city}\",\"0\":\"{_col86} {_col89} {_col90} {_col0} {_col22} {_col31} {_col34} {_col36} {_col37} {_col39} {_col49} {_col52} {_col53} {_col56} {_col62} {_col63}\"}}},\"Statistics:\":\"Num rows: 3833817 Data size: 5067957248 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{hd_demo_sk} {hd_dep_count} {hd_vehicle_count}\",\"0\":\"{_col55} {_col77} {_col0} {_col3} {_col5} {_col6} {_col8} {_col18} {_col21} {_col22} {_col25} {_col31} {_col32}\"}}},\"Statistics:\":\"Num rows: 3485288 Data size: 4607233536 Basic stats: COMPLETE Column st ats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{s_store_sk} {s_city}\",\"0\":\"{_col0} {_col3} {_col5} {_col6} {_col8} {_col18} {_col21} {_col22} {_col25} {_col31} {_col32}\"}}},\"Statistics:\":\"Num rows: 3168444 Data size: 4188394240 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{d_date_sk} {d_year} {d_dow}\",\"0\":\"{ss_sold_date_sk} {ss_customer_sk} {ss_hdemo_sk} {ss_addr_sk} {ss_ticket_number} {ss_coupon_amt} {ss_net_profit} {ss_store_sk}\"}}},\"Statistics:\":\"Num rows: 2880404 Data size: 3807631184 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 5\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"customer\",\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"c_customer_sk (type: int)\",\"0\":\"_col1 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\ ",\"_col9\",\"_col13\",\"_col14\"],\"children\":{\"Map Join Operator\":{\"keys:\":{\"1\":\"ca_address_sk (type: int)\",\"0\":\"_col9 (type: int)\"},\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col9\",\"_col13\",\"_col14\",\"_col25\",\"_col31\"],\"children\":{\"Filter Operator\":{\"predicate:\":\"(((_col1 = _col5) and (_col9 = _col25)) and (_col31 <> _col2)) (type: boolean)\",\"children\":{\"Select Operator\":{\"expressions:\":\"_col14 (type: string), _col13 (type: string), _col31 (type: string), _col2 (type: string), _col0 (type: int), _col3 (type: decimal(17,2)), _col4 (type: decimal(17,2))\",\"outputColumnNames:\":[\"_col0\",\"_col1\",\"_col2\",\"_col3\",\"_col4\",\"_col5\",\"_col6\"],\"children\":{\"Reduce Output Operator\":{\"TopN Hash Memory Usage:\":\"0.04\",\"sort order:\":\"+++++\",\"value expressions:\":\"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: int), _col5 (type: decimal(1 7,2)), _col6 (type: decimal(17,2))\",\"Statistics:\":\"Num rows: 30250 Data size: 25902518 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: int)\"}},\"Statistics:\":\"Num rows: 30250 Data size: 25902518 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 30250 Data size: 25902518 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 121000 Data size: 103610072 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{ca_address_sk} {ca_city}\",\"0\":\"{_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col9} {_col13} {_col14}\"}}},\"Statistics:\":\"Num rows: 110000 Data size: 94190976 Basic stats: COMPLETE Column stats: NONE\",\"condition map:\":[{\"\":\"Inner Join 0 to 1\"}],\"condition expressions:\":{\"1\":\"{c_customer_sk} {c_current_addr_sk} {c_first_nam e} {c_last_name}\",\"0\":\"{_col0} {_col1} {_col2} {_col3} {_col4}\"}}},\"Statistics:\":\"Num rows: 100000 Data size: 85628164 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 4\":{\"Map Operator Tree:\":[{\"TableScan\":{\"filterExpr:\":\"((d_dow) IN (6, 0) and (d_year) IN (1999, (1999 + 1), (1999 + 2))) (type: boolean)\",\"alias:\":\"date_dim\",\"children\":{\"Filter Operator\":{\"predicate:\":\"((d_dow) IN (6, 0) and (d_year) IN (1999, (1999 + 1), (1999 + 2))) (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"d_date_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"d_date_sk (type: int), d_year (type: int), d_dow (type: int)\",\"Statistics:\":\"Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"d_date_sk (type: int)\"}},\"Statistics:\":\"Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 73049 Data size: 817418 31 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 7\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"current_addr\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ca_address_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"ca_address_sk (type: int), ca_city (type: string)\",\"Statistics:\":\"Num rows: 50000 Data size: 55975728 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ca_address_sk (type: int)\"}},\"Statistics:\":\"Num rows: 50000 Data size: 55975728 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Reducer 6\":{\"Reduce Operator Tree:\":{\"Extract\":{\"children\":{\"Limit\":{\"children\":{\"File Output Operator\":{\"Statistics:\":\"Num rows: 100 Data size: 85600 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: 100 Data size: 85600 Basic stats: COMPLETE Column stats: NONE\",\"Number of rows:\":\"100\"}},\"Statistics:\":\"Num rows: 30250 Data size: 25902518 Basic stats: COMPLETE Column stats: NONE\"}}},\"Map 9\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"filterExpr:\":\"(s_city) IN ('Fairview', 'Fairview', 'Fairview', 'Midway', 'Fairview') (type: boolean)\",\"alias:\":\"store\",\"children\":{\"Filter Operator\":{\"predicate:\":\"(s_city) IN ('Fairview', 'Fairview', 'Fairview', 'Midway', 'Fairview') (type: boolean)\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"UDFToDouble(s_store_sk) (type: double)\",\"sort order:\":\"+\",\"value expressions:\":\"s_store_sk (type: int), s_city (type: string)\",\"Statistics:\":\"Num rows: 6 Data size: 12816 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"UDFToD ouble(s_store_sk) (type: double)\"}},\"Statistics:\":\"Num rows: 6 Data size: 12816 Basic stats: COMPLETE Column stats: NONE\"}},\"Statistics:\":\"Num rows: 12 Data size: 25632 Basic stats: COMPLETE Column stats: NONE\"}}]},\"Map 8\":{\"Execution mode:\":\"vectorized\",\"Map Operator Tree:\":[{\"TableScan\":{\"alias:\":\"customer_address\",\"children\":{\"Reduce Output Operator\":{\"Map-reduce partition columns:\":\"ca_address_sk (type: int)\",\"sort order:\":\"+\",\"value expressions:\":\"ca_address_sk (type: int), ca_city (type: string)\",\"Statistics:\":\"Num rows: 50000 Data size: 55975728 Basic stats: COMPLETE Column stats: NONE\",\"key expressions:\":\"ca_address_sk (type: int)\"}},\"Statistics:\":\"Num rows: 50000 Data size: 55975728 Basic stats: COMPLETE Column stats: NONE\"}}]}},\"Edges:\":{\"Reducer 3\":{\"parent\":\"Map 2\",\"type\":\"SIMPLE_EDGE\"},\"Map 2\":[{\"parent\":\"Map 1\",\"type\":\"BROADCAST_EDGE\"},{\"parent\":\"Map 4\",\"type\":\"BROADCAST_EDGE\"},{\"parent\" :\"Map 8\",\"type\":\"BROADCAST_EDGE\"},{\"parent\":\"Map 9\",\"type\":\"BROADCAST_EDGE\"}],\"Map 5\":[{\"parent\":\"Reducer 3\",\"type\":\"BROADCAST_EDGE\"},{\"parent\":\"Map 7\",\"type\":\"BROADCAST_EDGE\"}],\"Reducer 6\":{\"parent\":\"Map 5\",\"type\":\"SIMPLE_EDGE\"}}}},\"Stage-0\":{\"Fetch Operator\":{\"limit:\":\"100\",\"Processor Tree:\":{\"ListSink\":{}}}}},\"STAGE DEPENDENCIES\":{\"Stage-1\":{\"ROOT STAGE\":\"TRUE\"},\"Stage-0\":{\"ROOT STAGE\":\"TRUE\"}}}}" - }, - "primaryfilters": { - "user": [ - "hrt_qa" - ] - }, - "entity": "hrt_qa_20140311131919_1d932567-71c2-4341-9b50-6df1f58a9114", - "entitytype": "HIVE_QUERY_ID" - }, - { - "starttime": 1393439112167, - "events": [ - { - "timestamp": 1393439112748, - "eventtype": "QUERY_COMPLETED", - "eventinfo": {} - }, - { - "timestamp": 1393439112167, - "eventtype": "QUERY_SUBMITTED", - "eventinfo": {} - } - ], - "otherinfo": { - "status": false, - "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" - ] - }, - "entity": "hive_20140226132525_780b8f71-bd4f-4daf-b0c3-4584920186d5", - "entitytype": "HIVE_QUERY_ID" - }, - { - "starttime": 1393031638459, - "events": [ - { - "timestamp": 1393032494585, - "eventtype": "QUERY_COMPLETED", - "eventinfo": {} - }, - { - "timestamp": 1393031638459, - "eventtype": "QUERY_SUBMITTED", - "eventinfo": {} - } - ], - "otherinfo": { - "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\":{\"
<TRUNCATED>
