Query (id=224d077232d997b2:93e0ccc000000000): Summary: Session ID: 54b98d387638fcf:91a3e5f49544fb93 Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2018-05-18 15:16:04.267015000 End Time: 2018-05-18 15:16:31.496905000 Query Type: QUERY Query State: EXCEPTION Query Status: HDFS scan min reservation 0 must be >= min buffer size 8192 Impala Version: impalad version 2.13.0-SNAPSHOT RELEASE (build acf733ae7006d639f385c098f39897fb764ff0dc) User: systest@HALXG.CLOUDERA.COM Connected User: systest@HALXG.CLOUDERA.COM Delegated User: Network Address: 172.28.196.155:58081 Default Db: tpcds_10000_decimal_parquet Sql Statement: /* Mem: 2375 MB. Coordinator: vc1504.halxg.cloudera.com. */ -- RESULT MISMATCH FROM ORIGINAL -- FIXED. TAKE ACTUAL RESULT AS EXPECTED with ss as (select s_store_sk, sum(ss_ext_sales_price) as sales, sum(ss_net_profit) as profit from store_sales, date_dim, store where ss_sold_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) and ss_store_sk = s_store_sk group by s_store_sk) , sr as (select s_store_sk, sum(sr_return_amt) as return_amt, sum(sr_net_loss) as profit_loss from store_returns, date_dim, store where sr_returned_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) and sr_store_sk = s_store_sk group by s_store_sk), cs as (select cs_call_center_sk, sum(cs_ext_sales_price) as sales, sum(cs_net_profit) as profit from catalog_sales, date_dim where cs_sold_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) group by cs_call_center_sk ), cr as (select cr_call_center_sk, sum(cr_return_amount) as return_amt, sum(cr_net_loss) as profit_loss from catalog_returns, date_dim where cr_returned_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) group by cr_call_center_sk ), ws as ( select wp_web_page_sk, sum(ws_ext_sales_price) as sales, sum(ws_net_profit) as profit from web_sales, date_dim, web_page where ws_sold_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) and ws_web_page_sk = wp_web_page_sk group by wp_web_page_sk), wr as (select wp_web_page_sk, sum(wr_return_amt) as return_amt, sum(wr_net_loss) as profit_loss from web_returns, date_dim, web_page where wr_returned_date_sk = d_date_sk and cast(d_date as timestamp) between cast('2000-08-23' as timestamp) and (cast('2000-08-23' as timestamp) + interval 30 days) and wr_web_page_sk = wp_web_page_sk group by wp_web_page_sk) , results as (select channel , id , sum(sales) as sales , sum(return_amt) as return_amt , sum(profit) as profit from (select 'store channel' as channel , ss.s_store_sk as id , sales , coalesce(return_amt, 0) as return_amt , (profit - coalesce(profit_loss,0)) as profit from ss left join sr on ss.s_store_sk = sr.s_store_sk union all select 'catalog channel' as channel , cs_call_center_sk as id , sales , return_amt , (profit - profit_loss) as profit from cs , cr union all select 'web channel' as channel , ws.wp_web_page_sk as id , sales , coalesce(return_amt, 0) return_amt , (profit - coalesce(profit_loss,0)) as profit from ws left join wr on ws.wp_web_page_sk = wr.wp_web_page_sk ) x group by channel, id ) select * from ( select channel, id, sales, return_amt, profit from results union select channel, NULL AS id, sum(sales) as sales, sum(return_amt) as return_amt, sum(profit) as profit from results group by channel union select NULL AS channel, NULL AS id, sum(sales) as sales, sum(return_amt) as return_amt, sum(profit) as profit from results ) foo order by channel, id limit 100; Coordinator: vc1504.halxg.cloudera.com:22000 Query Options (set by configuration): ABORT_ON_ERROR=1,MEM_LIMIT=2490368000 Query Options (set by configuration and planner): ABORT_ON_ERROR=1,MEM_LIMIT=2490368000,MT_DOP=0 Plan: ---------------- Max Per-Host Resource Reservation: Memory=145.12MB Per-Host Resource Estimates: Memory=2.32GB F76:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=0B mem-reservation=0B PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B | 198:MERGING-EXCHANGE [UNPARTITIONED] | order by: channel ASC, id ASC | limit: 100 | mem-estimate=0B mem-reservation=0B | tuple-ids=100 row-size=68B cardinality=100 | F75:PLAN FRAGMENT [HASH(channel,id,sales,return_amt,profit)] hosts=129 instances=129 Per-Host Resources: mem-estimate=10.01MB mem-reservation=1.94MB 115:TOP-N [LIMIT=100] | order by: channel ASC, id ASC | mem-estimate=6.64KB mem-reservation=0B | tuple-ids=100 row-size=68B cardinality=100 | 197:AGGREGATE [FINALIZE] | group by: channel, id, sales, return_amt, profit | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=98 row-size=68B cardinality=8365 | 196:EXCHANGE [HASH(channel,id,sales,return_amt,profit)] | mem-estimate=0B mem-reservation=0B | tuple-ids=98 row-size=68B cardinality=8365 | F74:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 Per-Host Resources: mem-estimate=20.00MB mem-reservation=3.94MB 114:AGGREGATE [STREAMING] | group by: channel, id, sales, return_amt, profit | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | tuple-ids=98 row-size=68B cardinality=8365 | 00:UNION | mem-estimate=0B mem-reservation=0B | tuple-ids=98 row-size=68B cardinality=8365 | |--195:EXCHANGE [RANDOM] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=97 row-size=48B cardinality=1 | | | F73:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B | 194:AGGREGATE [FINALIZE] | | output: sum:merge(sales), sum:merge(return_amt), sum:merge(profit) | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB | | tuple-ids=97 row-size=48B cardinality=1 | | | 193:EXCHANGE [UNPARTITIONED] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=97 row-size=48B cardinality=1 | | | F72:PLAN FRAGMENT [HASH(channel,id)] hosts=129 instances=129 | Per-Host Resources: mem-estimate=20.00MB mem-reservation=1.94MB | 113:AGGREGATE | | output: sum(sum(sales)), sum(sum(return_amt)), sum(sum(profit)) | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB | | tuple-ids=97 row-size=48B cardinality=1 | | | 192:AGGREGATE [FINALIZE] | | output: sum:merge(sales), sum:merge(return_amt), sum:merge(profit) | | group by: channel, id | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=95 row-size=68B cardinality=8361 | | | 191:EXCHANGE [HASH(channel,id)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=95 row-size=68B cardinality=8361 | | | F71:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=31.94MB mem-reservation=7.81MB | 112:AGGREGATE [STREAMING] | | output: sum(sales), sum(return_amt), sum(profit) | | group by: channel, id | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=95 row-size=68B cardinality=8361 | | | 76:UNION | | mem-estimate=0B mem-reservation=0B | | tuple-ids=93 row-size=68B cardinality=8361 | | | |--111:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | | | hash predicates: wp_web_page_sk = wp_web_page_sk | | | fk/pk conjuncts: wp_web_page_sk = wp_web_page_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=86,91N row-size=72B cardinality=3976 | | | | | |--190:AGGREGATE [FINALIZE] | | | | output: sum:merge(wr_return_amt), sum:merge(wr_net_loss) | | | | group by: wp_web_page_sk | | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=91 row-size=36B cardinality=3976 | | | | | | | 189:EXCHANGE [HASH(wp_web_page_sk)] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=91 row-size=36B cardinality=3976 | | | | | | | F67:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | | 110:AGGREGATE [STREAMING] | | | | output: sum(wr_return_amt), sum(wr_net_loss) | | | | group by: wp_web_page_sk | | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | | tuple-ids=91 row-size=36B cardinality=3976 | | | | | | | 109:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: wr_web_page_sk = wp_web_page_sk | | | | fk/pk conjuncts: wr_web_page_sk = wp_web_page_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=88,89,90 row-size=50B cardinality=720020485 | | | | | | | |--188:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=90 row-size=4B cardinality=4002 | | | | | | | | | F69:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | | 107:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | | | partitions=1/1 files=1 size=79.93KB | | | | stored statistics: | | | | table: rows=4002 size=79.93KB | | | | columns: all | | | | extrapolated-rows=disabled | | | | mem-estimate=16.00MB mem-reservation=0B | | | | tuple-ids=90 row-size=4B cardinality=4002 | | | | | | | 108:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: wr_returned_date_sk = d_date_sk | | | | fk/pk conjuncts: wr_returned_date_sk = d_date_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=88,89 row-size=46B cardinality=720020485 | | | | | | | |--187:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=89 row-size=30B cardinality=7305 | | | | | | | | | F68:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | | 106:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | | partitions=1/1 files=1 size=2.15MB | | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | stored statistics: | | | | table: rows=73049 size=2.15MB | | | | columns: all | | | | extrapolated-rows=disabled | | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | mem-estimate=32.00MB mem-reservation=0B | | | | tuple-ids=89 row-size=30B cardinality=7305 | | | | | | | 105:SCAN HDFS [tpcds_10000_decimal_parquet.web_returns, RANDOM] | | | partitions=2185/2185 files=283267 size=74.77GB | | | stored statistics: | | | table: rows=720020485 size=74.77GB | | | partitions: 2185/2185 rows=720020485 | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=48.00MB mem-reservation=0B | | | tuple-ids=88 row-size=16B cardinality=720020485 | | | | | 186:AGGREGATE [FINALIZE] | | | output: sum:merge(ws_ext_sales_price), sum:merge(ws_net_profit) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=86 row-size=36B cardinality=3976 | | | | | 185:EXCHANGE [HASH(wp_web_page_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=86 row-size=36B cardinality=3976 | | | | | F63:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | 104:AGGREGATE [STREAMING] | | | output: sum(ws_ext_sales_price), sum(ws_net_profit) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=86 row-size=36B cardinality=3976 | | | | | 103:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: ws_web_page_sk = wp_web_page_sk | | | fk/pk conjuncts: ws_web_page_sk = wp_web_page_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=83,84,85 row-size=50B cardinality=7199963324 | | | | | |--184:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=85 row-size=4B cardinality=4002 | | | | | | | F65:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | 101:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | | partitions=1/1 files=1 size=79.93KB | | | stored statistics: | | | table: rows=4002 size=79.93KB | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=16.00MB mem-reservation=0B | | | tuple-ids=85 row-size=4B cardinality=4002 | | | | | 102:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: ws_sold_date_sk = d_date_sk | | | fk/pk conjuncts: ws_sold_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=83,84 row-size=46B cardinality=7199963324 | | | | | |--183:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=84 row-size=30B cardinality=7305 | | | | | | | F64:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 100:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=84 row-size=30B cardinality=7305 | | | | | 99:SCAN HDFS [tpcds_10000_decimal_parquet.web_sales, RANDOM] | | partitions=1824/1824 files=237120 size=663.40GB | | stored statistics: | | table: rows=7199963324 size=663.40GB | | partitions: 1824/1824 rows=7199963324 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=83 row-size=16B cardinality=7199963324 | | | |--98:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | | | mem-estimate=1.90KB mem-reservation=0B | | | tuple-ids=77,81 row-size=72B cardinality=2916 | | | | | |--182:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=81 row-size=36B cardinality=54 | | | | | | | F62:PLAN FRAGMENT [HASH(cr_call_center_sk)] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=10.00MB mem-reservation=1.94MB | | | 181:AGGREGATE [FINALIZE] | | | | output: sum:merge(cr_return_amount), sum:merge(cr_net_loss) | | | | group by: cr_call_center_sk | | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=81 row-size=36B cardinality=54 | | | | | | | 180:EXCHANGE [HASH(cr_call_center_sk)] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=81 row-size=36B cardinality=54 | | | | | | | F60:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=59.94MB mem-reservation=3.94MB | | | 97:AGGREGATE [STREAMING] | | | | output: sum(cr_return_amount), sum(cr_net_loss) | | | | group by: cr_call_center_sk | | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | | tuple-ids=81 row-size=36B cardinality=54 | | | | | | | 96:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: cr_returned_date_sk = d_date_sk | | | | fk/pk conjuncts: cr_returned_date_sk = d_date_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=79,80 row-size=46B cardinality=1440033112 | | | | | | | |--179:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=80 row-size=30B cardinality=7305 | | | | | | | | | F61:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | | 95:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | | partitions=1/1 files=1 size=2.15MB | | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | stored statistics: | | | | table: rows=73049 size=2.15MB | | | | columns: all | | | | extrapolated-rows=disabled | | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | mem-estimate=32.00MB mem-reservation=0B | | | | tuple-ids=80 row-size=30B cardinality=7305 | | | | | | | 94:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_returns, RANDOM] | | | partitions=2104/2104 files=267484 size=151.99GB | | | stored statistics: | | | table: rows=1440033112 size=151.99GB | | | partitions: 2104/2104 rows=1440033112 | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=48.00MB mem-reservation=0B | | | tuple-ids=79 row-size=16B cardinality=1440033112 | | | | | 178:AGGREGATE [FINALIZE] | | | output: sum:merge(cs_ext_sales_price), sum:merge(cs_net_profit) | | | group by: cs_call_center_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=77 row-size=36B cardinality=54 | | | | | 177:EXCHANGE [HASH(cs_call_center_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=77 row-size=36B cardinality=54 | | | | | F57:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=155.94MB mem-reservation=3.94MB | | 93:AGGREGATE [STREAMING] | | | output: sum(cs_ext_sales_price), sum(cs_net_profit) | | | group by: cs_call_center_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=77 row-size=36B cardinality=54 | | | | | 92:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: cs_sold_date_sk = d_date_sk | | | fk/pk conjuncts: cs_sold_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=75,76 row-size=50B cardinality=14399964710 | | | | | |--176:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=76 row-size=30B cardinality=7305 | | | | | | | F58:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 91:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=76 row-size=30B cardinality=7305 | | | | | 90:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_sales, RANDOM] | | partitions=1837/1837 files=29733 size=1.00TB | | stored statistics: | | table: rows=14399964710 size=1.00TB | | partitions: 1837/1837 rows=14399964710 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=144.00MB mem-reservation=0B | | tuple-ids=75 row-size=20B cardinality=14399964710 | | | 89:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | | hash predicates: s_store_sk = s_store_sk | | fk/pk conjuncts: s_store_sk = s_store_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=68,73N row-size=72B cardinality=1469 | | | |--175:AGGREGATE [FINALIZE] | | | output: sum:merge(sr_return_amt), sum:merge(sr_net_loss) | | | group by: s_store_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=73 row-size=36B cardinality=1469 | | | | | 174:EXCHANGE [HASH(s_store_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=73 row-size=36B cardinality=1469 | | | | | F53:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | 88:AGGREGATE [STREAMING] | | | output: sum(sr_return_amt), sum(sr_net_loss) | | | group by: s_store_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=73 row-size=36B cardinality=1469 | | | | | 87:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: sr_store_sk = s_store_sk | | | fk/pk conjuncts: sr_store_sk = s_store_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=70,71,72 row-size=50B cardinality=2879513368 | | | | | |--173:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=72 row-size=4B cardinality=1500 | | | | | | | F55:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | 85:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | | | partitions=1/1 files=1 size=132.82KB | | | stored statistics: | | | table: rows=1500 size=132.82KB | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=16.00MB mem-reservation=0B | | | tuple-ids=72 row-size=4B cardinality=1500 | | | | | 86:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: sr_returned_date_sk = d_date_sk | | | fk/pk conjuncts: sr_returned_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=70,71 row-size=46B cardinality=2879513368 | | | | | |--172:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=71 row-size=30B cardinality=7305 | | | | | | | F54:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 84:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=71 row-size=30B cardinality=7305 | | | | | 83:SCAN HDFS [tpcds_10000_decimal_parquet.store_returns, RANDOM] | | partitions=2004/2004 files=260520 size=215.11GB | | stored statistics: | | table: rows=2879513368 size=215.11GB | | partitions: 2004/2004 rows=2879513368 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=70 row-size=16B cardinality=2879513368 | | | 171:AGGREGATE [FINALIZE] | | output: sum:merge(ss_ext_sales_price), sum:merge(ss_net_profit) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=68 row-size=36B cardinality=1469 | | | 170:EXCHANGE [HASH(s_store_sk)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=68 row-size=36B cardinality=1469 | | | F49:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | 82:AGGREGATE [STREAMING] | | output: sum(ss_ext_sales_price), sum(ss_net_profit) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=68 row-size=36B cardinality=1469 | | | 81:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ss_store_sk = s_store_sk | | fk/pk conjuncts: ss_store_sk = s_store_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=65,66,67 row-size=50B cardinality=28800426268 | | | |--169:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=67 row-size=4B cardinality=1500 | | | | | F51:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | 79:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | | partitions=1/1 files=1 size=132.82KB | | stored statistics: | | table: rows=1500 size=132.82KB | | columns: all | | extrapolated-rows=disabled | | mem-estimate=16.00MB mem-reservation=0B | | tuple-ids=67 row-size=4B cardinality=1500 | | | 80:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ss_sold_date_sk = d_date_sk | | fk/pk conjuncts: ss_sold_date_sk = d_date_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=65,66 row-size=46B cardinality=28800426268 | | | |--168:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=66 row-size=30B cardinality=7305 | | | | | F50:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | 78:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | partitions=1/1 files=1 size=2.15MB | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | stored statistics: | | table: rows=73049 size=2.15MB | | columns: all | | extrapolated-rows=disabled | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | mem-estimate=32.00MB mem-reservation=0B | | tuple-ids=66 row-size=30B cardinality=7305 | | | 77:SCAN HDFS [tpcds_10000_decimal_parquet.store_sales, RANDOM] | partitions=1824/1824 files=237250 size=1.51TB | stored statistics: | table: rows=28800426268 size=1.51TB | partitions: 1824/1824 rows=28800426268 | columns: all | extrapolated-rows=disabled | mem-estimate=48.00MB mem-reservation=0B | tuple-ids=65 row-size=16B cardinality=28800426268 | |--167:AGGREGATE [FINALIZE] | | output: sum:merge(sales), sum:merge(return_amt), sum:merge(profit) | | group by: channel | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=64 row-size=64B cardinality=3 | | | 166:EXCHANGE [HASH(channel)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=64 row-size=64B cardinality=3 | | | F47:PLAN FRAGMENT [HASH(channel,id)] hosts=129 instances=129 | Per-Host Resources: mem-estimate=20.00MB mem-reservation=3.94MB | 75:AGGREGATE [STREAMING] | | output: sum(sum(sales)), sum(sum(return_amt)), sum(sum(profit)) | | group by: channel | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=64 row-size=64B cardinality=3 | | | 165:AGGREGATE [FINALIZE] | | output: sum:merge(sales), sum:merge(return_amt), sum:merge(profit) | | group by: channel, id | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=62 row-size=68B cardinality=8361 | | | 164:EXCHANGE [HASH(channel,id)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=62 row-size=68B cardinality=8361 | | | F46:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=31.94MB mem-reservation=7.81MB | 74:AGGREGATE [STREAMING] | | output: sum(sales), sum(return_amt), sum(profit) | | group by: channel, id | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=62 row-size=68B cardinality=8361 | | | 38:UNION | | mem-estimate=0B mem-reservation=0B | | tuple-ids=60 row-size=68B cardinality=8361 | | | |--73:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | | | hash predicates: wp_web_page_sk = wp_web_page_sk | | | fk/pk conjuncts: wp_web_page_sk = wp_web_page_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=53,58N row-size=72B cardinality=3976 | | | | | |--163:AGGREGATE [FINALIZE] | | | | output: sum:merge(wr_return_amt), sum:merge(wr_net_loss) | | | | group by: wp_web_page_sk | | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=58 row-size=36B cardinality=3976 | | | | | | | 162:EXCHANGE [HASH(wp_web_page_sk)] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=58 row-size=36B cardinality=3976 | | | | | | | F42:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | | 72:AGGREGATE [STREAMING] | | | | output: sum(wr_return_amt), sum(wr_net_loss) | | | | group by: wp_web_page_sk | | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | | tuple-ids=58 row-size=36B cardinality=3976 | | | | | | | 71:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: wr_web_page_sk = wp_web_page_sk | | | | fk/pk conjuncts: wr_web_page_sk = wp_web_page_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=55,56,57 row-size=50B cardinality=720020485 | | | | | | | |--161:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=57 row-size=4B cardinality=4002 | | | | | | | | | F44:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | | 69:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | | | partitions=1/1 files=1 size=79.93KB | | | | stored statistics: | | | | table: rows=4002 size=79.93KB | | | | columns: all | | | | extrapolated-rows=disabled | | | | mem-estimate=16.00MB mem-reservation=0B | | | | tuple-ids=57 row-size=4B cardinality=4002 | | | | | | | 70:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: wr_returned_date_sk = d_date_sk | | | | fk/pk conjuncts: wr_returned_date_sk = d_date_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=55,56 row-size=46B cardinality=720020485 | | | | | | | |--160:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=56 row-size=30B cardinality=7305 | | | | | | | | | F43:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | | 68:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | | partitions=1/1 files=1 size=2.15MB | | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | stored statistics: | | | | table: rows=73049 size=2.15MB | | | | columns: all | | | | extrapolated-rows=disabled | | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | mem-estimate=32.00MB mem-reservation=0B | | | | tuple-ids=56 row-size=30B cardinality=7305 | | | | | | | 67:SCAN HDFS [tpcds_10000_decimal_parquet.web_returns, RANDOM] | | | partitions=2185/2185 files=283267 size=74.77GB | | | stored statistics: | | | table: rows=720020485 size=74.77GB | | | partitions: 2185/2185 rows=720020485 | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=48.00MB mem-reservation=0B | | | tuple-ids=55 row-size=16B cardinality=720020485 | | | | | 159:AGGREGATE [FINALIZE] | | | output: sum:merge(ws_ext_sales_price), sum:merge(ws_net_profit) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=53 row-size=36B cardinality=3976 | | | | | 158:EXCHANGE [HASH(wp_web_page_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=53 row-size=36B cardinality=3976 | | | | | F38:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | 66:AGGREGATE [STREAMING] | | | output: sum(ws_ext_sales_price), sum(ws_net_profit) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=53 row-size=36B cardinality=3976 | | | | | 65:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: ws_web_page_sk = wp_web_page_sk | | | fk/pk conjuncts: ws_web_page_sk = wp_web_page_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=50,51,52 row-size=50B cardinality=7199963324 | | | | | |--157:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=52 row-size=4B cardinality=4002 | | | | | | | F40:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | 63:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | | partitions=1/1 files=1 size=79.93KB | | | stored statistics: | | | table: rows=4002 size=79.93KB | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=16.00MB mem-reservation=0B | | | tuple-ids=52 row-size=4B cardinality=4002 | | | | | 64:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: ws_sold_date_sk = d_date_sk | | | fk/pk conjuncts: ws_sold_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=50,51 row-size=46B cardinality=7199963324 | | | | | |--156:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=51 row-size=30B cardinality=7305 | | | | | | | F39:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 62:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=51 row-size=30B cardinality=7305 | | | | | 61:SCAN HDFS [tpcds_10000_decimal_parquet.web_sales, RANDOM] | | partitions=1824/1824 files=237120 size=663.40GB | | stored statistics: | | table: rows=7199963324 size=663.40GB | | partitions: 1824/1824 rows=7199963324 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=50 row-size=16B cardinality=7199963324 | | | |--60:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | | | mem-estimate=1.90KB mem-reservation=0B | | | tuple-ids=44,48 row-size=72B cardinality=2916 | | | | | |--155:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=48 row-size=36B cardinality=54 | | | | | | | F37:PLAN FRAGMENT [HASH(cr_call_center_sk)] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=10.00MB mem-reservation=1.94MB | | | 154:AGGREGATE [FINALIZE] | | | | output: sum:merge(cr_return_amount), sum:merge(cr_net_loss) | | | | group by: cr_call_center_sk | | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=48 row-size=36B cardinality=54 | | | | | | | 153:EXCHANGE [HASH(cr_call_center_sk)] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=48 row-size=36B cardinality=54 | | | | | | | F35:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | | Per-Host Resources: mem-estimate=59.94MB mem-reservation=3.94MB | | | 59:AGGREGATE [STREAMING] | | | | output: sum(cr_return_amount), sum(cr_net_loss) | | | | group by: cr_call_center_sk | | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | | tuple-ids=48 row-size=36B cardinality=54 | | | | | | | 58:HASH JOIN [INNER JOIN, BROADCAST] | | | | hash predicates: cr_returned_date_sk = d_date_sk | | | | fk/pk conjuncts: cr_returned_date_sk = d_date_sk | | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | | tuple-ids=46,47 row-size=46B cardinality=1440033112 | | | | | | | |--152:EXCHANGE [BROADCAST] | | | | | mem-estimate=0B mem-reservation=0B | | | | | tuple-ids=47 row-size=30B cardinality=7305 | | | | | | | | | F36:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | | 57:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | | partitions=1/1 files=1 size=2.15MB | | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | stored statistics: | | | | table: rows=73049 size=2.15MB | | | | columns: all | | | | extrapolated-rows=disabled | | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | | mem-estimate=32.00MB mem-reservation=0B | | | | tuple-ids=47 row-size=30B cardinality=7305 | | | | | | | 56:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_returns, RANDOM] | | | partitions=2104/2104 files=267484 size=151.99GB | | | stored statistics: | | | table: rows=1440033112 size=151.99GB | | | partitions: 2104/2104 rows=1440033112 | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=48.00MB mem-reservation=0B | | | tuple-ids=46 row-size=16B cardinality=1440033112 | | | | | 151:AGGREGATE [FINALIZE] | | | output: sum:merge(cs_ext_sales_price), sum:merge(cs_net_profit) | | | group by: cs_call_center_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=44 row-size=36B cardinality=54 | | | | | 150:EXCHANGE [HASH(cs_call_center_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=44 row-size=36B cardinality=54 | | | | | F32:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=155.94MB mem-reservation=3.94MB | | 55:AGGREGATE [STREAMING] | | | output: sum(cs_ext_sales_price), sum(cs_net_profit) | | | group by: cs_call_center_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=44 row-size=36B cardinality=54 | | | | | 54:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: cs_sold_date_sk = d_date_sk | | | fk/pk conjuncts: cs_sold_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=42,43 row-size=50B cardinality=14399964710 | | | | | |--149:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=43 row-size=30B cardinality=7305 | | | | | | | F33:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 53:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=43 row-size=30B cardinality=7305 | | | | | 52:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_sales, RANDOM] | | partitions=1837/1837 files=29733 size=1.00TB | | stored statistics: | | table: rows=14399964710 size=1.00TB | | partitions: 1837/1837 rows=14399964710 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=144.00MB mem-reservation=0B | | tuple-ids=42 row-size=20B cardinality=14399964710 | | | 51:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | | hash predicates: s_store_sk = s_store_sk | | fk/pk conjuncts: s_store_sk = s_store_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=35,40N row-size=72B cardinality=1469 | | | |--148:AGGREGATE [FINALIZE] | | | output: sum:merge(sr_return_amt), sum:merge(sr_net_loss) | | | group by: s_store_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=40 row-size=36B cardinality=1469 | | | | | 147:EXCHANGE [HASH(s_store_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=40 row-size=36B cardinality=1469 | | | | | F28:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | | 50:AGGREGATE [STREAMING] | | | output: sum(sr_return_amt), sum(sr_net_loss) | | | group by: s_store_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=40 row-size=36B cardinality=1469 | | | | | 49:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: sr_store_sk = s_store_sk | | | fk/pk conjuncts: sr_store_sk = s_store_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=37,38,39 row-size=50B cardinality=2879513368 | | | | | |--146:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=39 row-size=4B cardinality=1500 | | | | | | | F30:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | 47:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | | | partitions=1/1 files=1 size=132.82KB | | | stored statistics: | | | table: rows=1500 size=132.82KB | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=16.00MB mem-reservation=0B | | | tuple-ids=39 row-size=4B cardinality=1500 | | | | | 48:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: sr_returned_date_sk = d_date_sk | | | fk/pk conjuncts: sr_returned_date_sk = d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=37,38 row-size=46B cardinality=2879513368 | | | | | |--145:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=38 row-size=30B cardinality=7305 | | | | | | | F29:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 46:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=38 row-size=30B cardinality=7305 | | | | | 45:SCAN HDFS [tpcds_10000_decimal_parquet.store_returns, RANDOM] | | partitions=2004/2004 files=260520 size=215.11GB | | stored statistics: | | table: rows=2879513368 size=215.11GB | | partitions: 2004/2004 rows=2879513368 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=37 row-size=16B cardinality=2879513368 | | | 144:AGGREGATE [FINALIZE] | | output: sum:merge(ss_ext_sales_price), sum:merge(ss_net_profit) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=35 row-size=36B cardinality=1469 | | | 143:EXCHANGE [HASH(s_store_sk)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=35 row-size=36B cardinality=1469 | | | F24:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=61.88MB mem-reservation=5.88MB | 44:AGGREGATE [STREAMING] | | output: sum(ss_ext_sales_price), sum(ss_net_profit) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=35 row-size=36B cardinality=1469 | | | 43:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ss_store_sk = s_store_sk | | fk/pk conjuncts: ss_store_sk = s_store_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=32,33,34 row-size=50B cardinality=28800426268 | | | |--142:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=34 row-size=4B cardinality=1500 | | | | | F26:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | 41:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | | partitions=1/1 files=1 size=132.82KB | | stored statistics: | | table: rows=1500 size=132.82KB | | columns: all | | extrapolated-rows=disabled | | mem-estimate=16.00MB mem-reservation=0B | | tuple-ids=34 row-size=4B cardinality=1500 | | | 42:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ss_sold_date_sk = d_date_sk | | fk/pk conjuncts: ss_sold_date_sk = d_date_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=32,33 row-size=46B cardinality=28800426268 | | | |--141:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=33 row-size=30B cardinality=7305 | | | | | F25:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | 40:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | partitions=1/1 files=1 size=2.15MB | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | stored statistics: | | table: rows=73049 size=2.15MB | | columns: all | | extrapolated-rows=disabled | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | mem-estimate=32.00MB mem-reservation=0B | | tuple-ids=33 row-size=30B cardinality=7305 | | | 39:SCAN HDFS [tpcds_10000_decimal_parquet.store_sales, RANDOM] | partitions=1824/1824 files=237250 size=1.51TB | stored statistics: | table: rows=28800426268 size=1.51TB | partitions: 1824/1824 rows=28800426268 | columns: all | extrapolated-rows=disabled | mem-estimate=48.00MB mem-reservation=0B | tuple-ids=32 row-size=16B cardinality=28800426268 | 140:AGGREGATE [FINALIZE] | output: sum:merge(sales), sum:merge(return_amt), sum:merge(profit) | group by: channel, id | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=30 row-size=68B cardinality=8361 | 139:EXCHANGE [HASH(channel,id)] | mem-estimate=0B mem-reservation=0B | tuple-ids=30 row-size=68B cardinality=8361 | F22:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 Per-Host Resources: mem-estimate=31.94MB mem-reservation=7.81MB 37:AGGREGATE [STREAMING] | output: sum(sales), sum(return_amt), sum(profit) | group by: channel, id | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | tuple-ids=30 row-size=68B cardinality=8361 | 01:UNION | mem-estimate=0B mem-reservation=0B | tuple-ids=28 row-size=68B cardinality=8361 | |--36:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | | hash predicates: wp_web_page_sk = wp_web_page_sk | | fk/pk conjuncts: wp_web_page_sk = wp_web_page_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=21,26N row-size=72B cardinality=3976 | | | |--138:AGGREGATE [FINALIZE] | | | output: sum:merge(wr_return_amt), sum:merge(wr_net_loss) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=26 row-size=36B cardinality=3976 | | | | | 137:EXCHANGE [HASH(wp_web_page_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=26 row-size=36B cardinality=3976 | | | | | F18:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=63.88MB mem-reservation=7.88MB runtime-filters-memory=2.00MB | | 35:AGGREGATE [STREAMING] | | | output: sum(wr_return_amt), sum(wr_net_loss) | | | group by: wp_web_page_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=26 row-size=36B cardinality=3976 | | | | | 34:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: wr_web_page_sk = wp_web_page_sk | | | fk/pk conjuncts: wr_web_page_sk = wp_web_page_sk | | | runtime filters: RF016[bloom] <- wp_web_page_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=23,24,25 row-size=50B cardinality=720020485 | | | | | |--136:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=25 row-size=4B cardinality=4002 | | | | | | | F20:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | | 32:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | | partitions=1/1 files=1 size=79.93KB | | | stored statistics: | | | table: rows=4002 size=79.93KB | | | columns: all | | | extrapolated-rows=disabled | | | mem-estimate=16.00MB mem-reservation=0B | | | tuple-ids=25 row-size=4B cardinality=4002 | | | | | 33:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: wr_returned_date_sk = d_date_sk | | | fk/pk conjuncts: wr_returned_date_sk = d_date_sk | | | runtime filters: RF018[bloom] <- d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=23,24 row-size=46B cardinality=720020485 | | | | | |--135:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=24 row-size=30B cardinality=7305 | | | | | | | F19:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 31:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=24 row-size=30B cardinality=7305 | | | | | 30:SCAN HDFS [tpcds_10000_decimal_parquet.web_returns, RANDOM] | | partitions=2185/2185 files=283267 size=74.77GB | | runtime filters: RF016[bloom] -> wr_web_page_sk, RF018[bloom] -> wr_returned_date_sk | | stored statistics: | | table: rows=720020485 size=74.77GB | | partitions: 2185/2185 rows=720020485 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=23 row-size=16B cardinality=720020485 | | | 134:AGGREGATE [FINALIZE] | | output: sum:merge(ws_ext_sales_price), sum:merge(ws_net_profit) | | group by: wp_web_page_sk | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=21 row-size=36B cardinality=3976 | | | 133:EXCHANGE [HASH(wp_web_page_sk)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=21 row-size=36B cardinality=3976 | | | F14:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=63.88MB mem-reservation=7.88MB runtime-filters-memory=2.00MB | 29:AGGREGATE [STREAMING] | | output: sum(ws_ext_sales_price), sum(ws_net_profit) | | group by: wp_web_page_sk | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=21 row-size=36B cardinality=3976 | | | 28:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ws_web_page_sk = wp_web_page_sk | | fk/pk conjuncts: ws_web_page_sk = wp_web_page_sk | | runtime filters: RF012[bloom] <- wp_web_page_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=18,19,20 row-size=50B cardinality=7199963324 | | | |--132:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=20 row-size=4B cardinality=4002 | | | | | F16:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | 26:SCAN HDFS [tpcds_10000_decimal_parquet.web_page, RANDOM] | | partitions=1/1 files=1 size=79.93KB | | stored statistics: | | table: rows=4002 size=79.93KB | | columns: all | | extrapolated-rows=disabled | | mem-estimate=16.00MB mem-reservation=0B | | tuple-ids=20 row-size=4B cardinality=4002 | | | 27:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: ws_sold_date_sk = d_date_sk | | fk/pk conjuncts: ws_sold_date_sk = d_date_sk | | runtime filters: RF014[bloom] <- d_date_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=18,19 row-size=46B cardinality=7199963324 | | | |--131:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=19 row-size=30B cardinality=7305 | | | | | F15:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | 25:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | partitions=1/1 files=1 size=2.15MB | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | stored statistics: | | table: rows=73049 size=2.15MB | | columns: all | | extrapolated-rows=disabled | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | mem-estimate=32.00MB mem-reservation=0B | | tuple-ids=19 row-size=30B cardinality=7305 | | | 24:SCAN HDFS [tpcds_10000_decimal_parquet.web_sales, RANDOM] | partitions=1824/1824 files=237120 size=663.40GB | runtime filters: RF012[bloom] -> ws_web_page_sk, RF014[bloom] -> ws_sold_date_sk | stored statistics: | table: rows=7199963324 size=663.40GB | partitions: 1824/1824 rows=7199963324 | columns: all | extrapolated-rows=disabled | mem-estimate=48.00MB mem-reservation=0B | tuple-ids=18 row-size=16B cardinality=7199963324 | |--23:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | | mem-estimate=1.90KB mem-reservation=0B | | tuple-ids=12,16 row-size=72B cardinality=2916 | | | |--130:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=16 row-size=36B cardinality=54 | | | | | F13:PLAN FRAGMENT [HASH(cr_call_center_sk)] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=10.00MB mem-reservation=1.94MB | | 129:AGGREGATE [FINALIZE] | | | output: sum:merge(cr_return_amount), sum:merge(cr_net_loss) | | | group by: cr_call_center_sk | | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=16 row-size=36B cardinality=54 | | | | | 128:EXCHANGE [HASH(cr_call_center_sk)] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=16 row-size=36B cardinality=54 | | | | | F11:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | | Per-Host Resources: mem-estimate=60.94MB mem-reservation=4.94MB runtime-filters-memory=1.00MB | | 22:AGGREGATE [STREAMING] | | | output: sum(cr_return_amount), sum(cr_net_loss) | | | group by: cr_call_center_sk | | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | | tuple-ids=16 row-size=36B cardinality=54 | | | | | 21:HASH JOIN [INNER JOIN, BROADCAST] | | | hash predicates: cr_returned_date_sk = d_date_sk | | | fk/pk conjuncts: cr_returned_date_sk = d_date_sk | | | runtime filters: RF010[bloom] <- d_date_sk | | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | | tuple-ids=14,15 row-size=46B cardinality=1440033112 | | | | | |--127:EXCHANGE [BROADCAST] | | | | mem-estimate=0B mem-reservation=0B | | | | tuple-ids=15 row-size=30B cardinality=7305 | | | | | | | F12:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | | 20:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | | partitions=1/1 files=1 size=2.15MB | | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | stored statistics: | | | table: rows=73049 size=2.15MB | | | columns: all | | | extrapolated-rows=disabled | | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | | mem-estimate=32.00MB mem-reservation=0B | | | tuple-ids=15 row-size=30B cardinality=7305 | | | | | 19:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_returns, RANDOM] | | partitions=2104/2104 files=267484 size=151.99GB | | runtime filters: RF010[bloom] -> cr_returned_date_sk | | stored statistics: | | table: rows=1440033112 size=151.99GB | | partitions: 2104/2104 rows=1440033112 | | columns: all | | extrapolated-rows=disabled | | mem-estimate=48.00MB mem-reservation=0B | | tuple-ids=14 row-size=16B cardinality=1440033112 | | | 126:AGGREGATE [FINALIZE] | | output: sum:merge(cs_ext_sales_price), sum:merge(cs_net_profit) | | group by: cs_call_center_sk | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=12 row-size=36B cardinality=54 | | | 125:EXCHANGE [HASH(cs_call_center_sk)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=12 row-size=36B cardinality=54 | | | F08:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=156.94MB mem-reservation=4.94MB runtime-filters-memory=1.00MB | 18:AGGREGATE [STREAMING] | | output: sum(cs_ext_sales_price), sum(cs_net_profit) | | group by: cs_call_center_sk | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=12 row-size=36B cardinality=54 | | | 17:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: cs_sold_date_sk = d_date_sk | | fk/pk conjuncts: cs_sold_date_sk = d_date_sk | | runtime filters: RF008[bloom] <- d_date_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=10,11 row-size=50B cardinality=14399964710 | | | |--124:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=11 row-size=30B cardinality=7305 | | | | | F09:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | 16:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | partitions=1/1 files=1 size=2.15MB | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | stored statistics: | | table: rows=73049 size=2.15MB | | columns: all | | extrapolated-rows=disabled | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | mem-estimate=32.00MB mem-reservation=0B | | tuple-ids=11 row-size=30B cardinality=7305 | | | 15:SCAN HDFS [tpcds_10000_decimal_parquet.catalog_sales, RANDOM] | partitions=1837/1837 files=29733 size=1.00TB | runtime filters: RF008[bloom] -> cs_sold_date_sk | stored statistics: | table: rows=14399964710 size=1.00TB | partitions: 1837/1837 rows=14399964710 | columns: all | extrapolated-rows=disabled | mem-estimate=144.00MB mem-reservation=0B | tuple-ids=10 row-size=20B cardinality=14399964710 | 14:HASH JOIN [LEFT OUTER JOIN, PARTITIONED] | hash predicates: s_store_sk = s_store_sk | fk/pk conjuncts: s_store_sk = s_store_sk | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=3,8N row-size=72B cardinality=1469 | |--123:AGGREGATE [FINALIZE] | | output: sum:merge(sr_return_amt), sum:merge(sr_net_loss) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=8 row-size=36B cardinality=1469 | | | 122:EXCHANGE [HASH(s_store_sk)] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=8 row-size=36B cardinality=1469 | | | F04:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 | Per-Host Resources: mem-estimate=63.88MB mem-reservation=7.88MB runtime-filters-memory=2.00MB | 13:AGGREGATE [STREAMING] | | output: sum(sr_return_amt), sum(sr_net_loss) | | group by: s_store_sk | | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | | tuple-ids=8 row-size=36B cardinality=1469 | | | 12:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: sr_store_sk = s_store_sk | | fk/pk conjuncts: sr_store_sk = s_store_sk | | runtime filters: RF004[bloom] <- s_store_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=5,6,7 row-size=50B cardinality=2879513368 | | | |--121:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=7 row-size=4B cardinality=1500 | | | | | F06:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | | 10:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | | partitions=1/1 files=1 size=132.82KB | | stored statistics: | | table: rows=1500 size=132.82KB | | columns: all | | extrapolated-rows=disabled | | mem-estimate=16.00MB mem-reservation=0B | | tuple-ids=7 row-size=4B cardinality=1500 | | | 11:HASH JOIN [INNER JOIN, BROADCAST] | | hash predicates: sr_returned_date_sk = d_date_sk | | fk/pk conjuncts: sr_returned_date_sk = d_date_sk | | runtime filters: RF006[bloom] <- d_date_sk | | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | | tuple-ids=5,6 row-size=46B cardinality=2879513368 | | | |--120:EXCHANGE [BROADCAST] | | | mem-estimate=0B mem-reservation=0B | | | tuple-ids=6 row-size=30B cardinality=7305 | | | | | F05:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | | 09:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | | partitions=1/1 files=1 size=2.15MB | | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | stored statistics: | | table: rows=73049 size=2.15MB | | columns: all | | extrapolated-rows=disabled | | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | | mem-estimate=32.00MB mem-reservation=0B | | tuple-ids=6 row-size=30B cardinality=7305 | | | 08:SCAN HDFS [tpcds_10000_decimal_parquet.store_returns, RANDOM] | partitions=2004/2004 files=260520 size=215.11GB | runtime filters: RF004[bloom] -> sr_store_sk, RF006[bloom] -> sr_returned_date_sk | stored statistics: | table: rows=2879513368 size=215.11GB | partitions: 2004/2004 rows=2879513368 | columns: all | extrapolated-rows=disabled | mem-estimate=48.00MB mem-reservation=0B | tuple-ids=5 row-size=16B cardinality=2879513368 | 119:AGGREGATE [FINALIZE] | output: sum:merge(ss_ext_sales_price), sum:merge(ss_net_profit) | group by: s_store_sk | mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=3 row-size=36B cardinality=1469 | 118:EXCHANGE [HASH(s_store_sk)] | mem-estimate=0B mem-reservation=0B | tuple-ids=3 row-size=36B cardinality=1469 | F00:PLAN FRAGMENT [RANDOM] hosts=129 instances=129 Per-Host Resources: mem-estimate=63.88MB mem-reservation=7.88MB runtime-filters-memory=2.00MB 07:AGGREGATE [STREAMING] | output: sum(ss_ext_sales_price), sum(ss_net_profit) | group by: s_store_sk | mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB | tuple-ids=3 row-size=36B cardinality=1469 | 06:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: ss_store_sk = s_store_sk | fk/pk conjuncts: ss_store_sk = s_store_sk | runtime filters: RF000[bloom] <- s_store_sk | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=0,1,2 row-size=50B cardinality=28800426268 | |--117:EXCHANGE [BROADCAST] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=2 row-size=4B cardinality=1500 | | | F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | Per-Host Resources: mem-estimate=16.00MB mem-reservation=0B | 04:SCAN HDFS [tpcds_10000_decimal_parquet.store, RANDOM] | partitions=1/1 files=1 size=132.82KB | stored statistics: | table: rows=1500 size=132.82KB | columns: all | extrapolated-rows=disabled | mem-estimate=16.00MB mem-reservation=0B | tuple-ids=2 row-size=4B cardinality=1500 | 05:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: ss_sold_date_sk = d_date_sk | fk/pk conjuncts: ss_sold_date_sk = d_date_sk | runtime filters: RF002[bloom] <- d_date_sk | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB | tuple-ids=0,1 row-size=46B cardinality=28800426268 | |--116:EXCHANGE [BROADCAST] | | mem-estimate=0B mem-reservation=0B | | tuple-ids=1 row-size=30B cardinality=7305 | | | F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 | Per-Host Resources: mem-estimate=32.00MB mem-reservation=0B | 03:SCAN HDFS [tpcds_10000_decimal_parquet.date_dim, RANDOM] | partitions=1/1 files=1 size=2.15MB | predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | stored statistics: | table: rows=73049 size=2.15MB | columns: all | extrapolated-rows=disabled | parquet dictionary predicates: CAST(d_date AS TIMESTAMP) <= TIMESTAMP '2000-09-22 00:00:00', CAST(d_date AS TIMESTAMP) >= TIMESTAMP '2000-08-23 00:00:00' | mem-estimate=32.00MB mem-reservation=0B | tuple-ids=1 row-size=30B cardinality=7305 | 02:SCAN HDFS [tpcds_10000_decimal_parquet.store_sales, RANDOM] partitions=1824/1824 files=237250 size=1.51TB runtime filters: RF000[bloom] -> ss_store_sk, RF002[bloom] -> ss_sold_date_sk stored statistics: table: rows=28800426268 size=1.51TB partitions: 1824/1824 rows=28800426268 columns: all extrapolated-rows=disabled mem-estimate=48.00MB mem-reservation=0B tuple-ids=0 row-size=16B cardinality=28800426268 ---------------- Estimated Per-Host Mem: 2489260688 Per Host Min Memory Reservation: va1026.halxg.cloudera.com:22000(145.12 MB) va1027.halxg.cloudera.com:22000(145.12 MB) va1028.halxg.cloudera.com:22000(145.12 MB) va1029.halxg.cloudera.com:22000(145.12 MB) va1030.halxg.cloudera.com:22000(145.12 MB) va1031.halxg.cloudera.com:22000(145.12 MB) va1032.halxg.cloudera.com:22000(145.12 MB) va1033.halxg.cloudera.com:22000(145.12 MB) va1034.halxg.cloudera.com:22000(145.12 MB) va1035.halxg.cloudera.com:22000(145.12 MB) va1036.halxg.cloudera.com:22000(145.12 MB) va1037.halxg.cloudera.com:22000(145.12 MB) va1039.halxg.cloudera.com:22000(145.12 MB) va1041.halxg.cloudera.com:22000(145.12 MB) va1042.halxg.cloudera.com:22000(145.12 MB) va1043.halxg.cloudera.com:22000(145.12 MB) va1044.halxg.cloudera.com:22000(145.12 MB) va1045.halxg.cloudera.com:22000(145.12 MB) va1046.halxg.cloudera.com:22000(145.12 MB) vc1501.halxg.cloudera.com:22000(145.12 MB) vc1502.halxg.cloudera.com:22000(145.12 MB) vc1503.halxg.cloudera.com:22000(145.12 MB) vc1504.halxg.cloudera.com:22000(145.12 MB) vc1505.halxg.cloudera.com:22000(145.12 MB) vc1507.halxg.cloudera.com:22000(145.12 MB) vc1508.halxg.cloudera.com:22000(145.12 MB) vc1509.halxg.cloudera.com:22000(145.12 MB) vc1510.halxg.cloudera.com:22000(145.12 MB) vc1511.halxg.cloudera.com:22000(145.12 MB) vc1513.halxg.cloudera.com:22000(145.12 MB) vc1515.halxg.cloudera.com:22000(145.12 MB) vc1516.halxg.cloudera.com:22000(145.12 MB) vc1517.halxg.cloudera.com:22000(145.12 MB) vc1518.halxg.cloudera.com:22000(145.12 MB) vc1519.halxg.cloudera.com:22000(145.12 MB) vc1520.halxg.cloudera.com:22000(145.12 MB) vc1522.halxg.cloudera.com:22000(145.12 MB) vc1523.halxg.cloudera.com:22000(145.12 MB) vc1524.halxg.cloudera.com:22000(145.12 MB) vc1525.halxg.cloudera.com:22000(145.12 MB) vc1526.halxg.cloudera.com:22000(145.12 MB) vc1527.halxg.cloudera.com:22000(145.12 MB) vc1528.halxg.cloudera.com:22000(145.12 MB) vc1529.halxg.cloudera.com:22000(145.12 MB) vc1531.halxg.cloudera.com:22000(145.12 MB) vc1532.halxg.cloudera.com:22000(145.12 MB) vc1533.halxg.cloudera.com:22000(145.12 MB) vc1534.halxg.cloudera.com:22000(145.12 MB) vc1535.halxg.cloudera.com:22000(145.12 MB) vc1536.halxg.cloudera.com:22000(145.12 MB) vc1537.halxg.cloudera.com:22000(145.12 MB) vc1538.halxg.cloudera.com:22000(145.12 MB) vc1539.halxg.cloudera.com:22000(145.12 MB) vc1540.halxg.cloudera.com:22000(145.12 MB) vc1541.halxg.cloudera.com:22000(145.12 MB) vc1542.halxg.cloudera.com:22000(145.12 MB) vd1101.halxg.cloudera.com:22000(145.12 MB) vd1102.halxg.cloudera.com:22000(145.12 MB) vd1103.halxg.cloudera.com:22000(145.12 MB) vd1104.halxg.cloudera.com:22000(145.12 MB) vd1105.halxg.cloudera.com:22000(145.12 MB) vd1107.halxg.cloudera.com:22000(145.12 MB) vd1108.halxg.cloudera.com:22000(145.12 MB) vd1109.halxg.cloudera.com:22000(145.12 MB) vd1110.halxg.cloudera.com:22000(145.12 MB) vd1111.halxg.cloudera.com:22000(145.12 MB) vd1112.halxg.cloudera.com:22000(145.12 MB) vd1113.halxg.cloudera.com:22000(145.12 MB) vd1114.halxg.cloudera.com:22000(145.12 MB) vd1115.halxg.cloudera.com:22000(145.12 MB) vd1116.halxg.cloudera.com:22000(145.12 MB) vd1117.halxg.cloudera.com:22000(145.12 MB) vd1118.halxg.cloudera.com:22000(145.12 MB) vd1119.halxg.cloudera.com:22000(145.12 MB) vd1120.halxg.cloudera.com:22000(145.12 MB) vd1121.halxg.cloudera.com:22000(145.12 MB) vd1122.halxg.cloudera.com:22000(145.12 MB) vd1123.halxg.cloudera.com:22000(145.12 MB) vd1124.halxg.cloudera.com:22000(145.12 MB) vd1125.halxg.cloudera.com:22000(145.12 MB) vd1126.halxg.cloudera.com:22000(145.12 MB) vd1127.halxg.cloudera.com:22000(145.12 MB) vd1129.halxg.cloudera.com:22000(145.12 MB) vd1130.halxg.cloudera.com:22000(145.12 MB) vd1131.halxg.cloudera.com:22000(145.12 MB) vd1132.halxg.cloudera.com:22000(145.12 MB) vd1133.halxg.cloudera.com:22000(145.12 MB) vd1134.halxg.cloudera.com:22000(145.12 MB) vd1135.halxg.cloudera.com:22000(145.12 MB) vd1136.halxg.cloudera.com:22000(145.12 MB) vd1138.halxg.cloudera.com:22000(145.12 MB) vd1139.halxg.cloudera.com:22000(145.12 MB) vd1140.halxg.cloudera.com:22000(145.12 MB) vd1141.halxg.cloudera.com:22000(145.12 MB) vd1142.halxg.cloudera.com:22000(145.12 MB) vd1326.halxg.cloudera.com:22000(145.12 MB) vd1327.halxg.cloudera.com:22000(145.12 MB) vd1328.halxg.cloudera.com:22000(145.12 MB) vd1329.halxg.cloudera.com:22000(145.12 MB) vd1330.halxg.cloudera.com:22000(145.12 MB) vd1331.halxg.cloudera.com:22000(145.12 MB) vd1332.halxg.cloudera.com:22000(145.12 MB) vd1333.halxg.cloudera.com:22000(145.12 MB) vd1334.halxg.cloudera.com:22000(145.12 MB) vd1335.halxg.cloudera.com:22000(145.12 MB) vd1336.halxg.cloudera.com:22000(145.12 MB) vd1337.halxg.cloudera.com:22000(145.12 MB) vd1338.halxg.cloudera.com:22000(145.12 MB) vd1339.halxg.cloudera.com:22000(145.12 MB) vd1340.halxg.cloudera.com:22000(145.12 MB) vd1341.halxg.cloudera.com:22000(145.12 MB) vd1342.halxg.cloudera.com:22000(145.12 MB) ve1125.halxg.cloudera.com:22000(145.12 MB) ve1126.halxg.cloudera.com:22000(145.12 MB) ve1127.halxg.cloudera.com:22000(145.12 MB) ve1128.halxg.cloudera.com:22000(145.12 MB) ve1129.halxg.cloudera.com:22000(145.12 MB) ve1130.halxg.cloudera.com:22000(145.12 MB) ve1131.halxg.cloudera.com:22000(145.12 MB) ve1132.halxg.cloudera.com:22000(145.12 MB) ve1134.halxg.cloudera.com:22000(145.12 MB) ve1135.halxg.cloudera.com:22000(145.12 MB) ve1136.halxg.cloudera.com:22000(145.12 MB) ve1137.halxg.cloudera.com:22000(145.12 MB) ve1138.halxg.cloudera.com:22000(145.12 MB) ve1139.halxg.cloudera.com:22000(145.12 MB) ve1140.halxg.cloudera.com:22000(145.12 MB) ve1141.halxg.cloudera.com:22000(145.12 MB) ve1142.halxg.cloudera.com:22000(145.12 MB) Request Pool: root.default Admission result: Admitted immediately ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------------------------------ 198:MERGING-EXCHANGE 1 0.000ns 0.000ns 0 100 0 0 UNPARTITIONED 115:TOP-N 129 0.000ns 0.000ns 0 100 0 6.64 KB 197:AGGREGATE 129 0.000ns 0.000ns 0 8.37K 0 10.00 MB FINALIZE 196:EXCHANGE 129 0.000ns 0.000ns 0 8.37K 0 0 HASH(channel,id,sales,return_amt,profit) 114:AGGREGATE 129 0.000ns 0.000ns 0 8.37K 0 10.00 MB STREAMING 00:UNION 129 0.000ns 0.000ns 0 8.37K 0 0 |--167:AGGREGATE 129 0.000ns 0.000ns 0 3 0 10.00 MB FINALIZE | 166:EXCHANGE 129 0.000ns 0.000ns 0 3 0 0 HASH(channel) | 75:AGGREGATE 129 0.000ns 0.000ns 0 3 0 10.00 MB STREAMING | 165:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB FINALIZE | 164:EXCHANGE 129 0.000ns 0.000ns 0 8.36K 0 0 HASH(channel,id) | 74:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB STREAMING | 38:UNION 129 0.000ns 0.000ns 0 8.36K 0 0 | |--60:NESTED LOOP JOIN 129 0.000ns 0.000ns 0 2.92K 0 1.90 KB CROSS JOIN, BROADCAST | | |--155:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 BROADCAST | | | 154:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | | | 153:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cr_call_center_sk) | | | 59:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | | | 58:HASH JOIN 129 0.000ns 0.000ns 0 1.44B 0 1.94 MB INNER JOIN, BROADCAST | | | |--152:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | | 57:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | | 56:SCAN HDFS 129 0.000ns 0.000ns 0 1.44B 0 48.00 MB tpcds_10000_decimal_parquet.catalog_returns | | 151:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | | 150:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cs_call_center_sk) | | 55:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | | 54:HASH JOIN 129 0.000ns 0.000ns 0 14.40B 0 1.94 MB INNER JOIN, BROADCAST | | |--149:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 53:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 52:SCAN HDFS 129 0.000ns 0.000ns 0 14.40B 0 144.00 MB tpcds_10000_decimal_parquet.catalog_sales | |--73:HASH JOIN 129 0.000ns 0.000ns 0 3.98K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED | | |--163:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | | | 162:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | | | 72:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | | | 71:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | | |--161:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | | | 69:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | | | 70:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | | |--160:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | | 68:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | | 67:SCAN HDFS 129 0.000ns 0.000ns 0 720.02M 0 48.00 MB tpcds_10000_decimal_parquet.web_returns | | 159:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | | 158:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | | 66:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | | 65:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | | |--157:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | | 63:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | | 64:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | | |--156:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 62:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 61:SCAN HDFS 129 0.000ns 0.000ns 0 7.20B 0 48.00 MB tpcds_10000_decimal_parquet.web_sales | 51:HASH JOIN 129 0.000ns 0.000ns 0 1.47K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED | |--148:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE | | 147:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) | | 50:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING | | 49:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | | |--146:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | | | 47:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store | | 48:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | | |--145:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 46:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 45:SCAN HDFS 129 0.000ns 0.000ns 0 2.88B 0 48.00 MB tpcds_10000_decimal_parquet.store_returns | 144:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE | 143:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) | 44:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING | 43:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST | |--142:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | | 41:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store | 42:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST | |--141:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | 40:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | 39:SCAN HDFS 129 0.000ns 0.000ns 0 28.80B 0 48.00 MB tpcds_10000_decimal_parquet.store_sales |--195:EXCHANGE 129 0.000ns 0.000ns 0 1 0 0 RANDOM | 194:AGGREGATE 1 0.000ns 0.000ns 0 1 0 10.00 MB FINALIZE | 193:EXCHANGE 1 0.000ns 0.000ns 0 1 0 0 UNPARTITIONED | 113:AGGREGATE 129 0.000ns 0.000ns 0 1 0 10.00 MB | 192:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB FINALIZE | 191:EXCHANGE 129 0.000ns 0.000ns 0 8.36K 0 0 HASH(channel,id) | 112:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB STREAMING | 76:UNION 129 0.000ns 0.000ns 0 8.36K 0 0 | |--98:NESTED LOOP JOIN 129 0.000ns 0.000ns 0 2.92K 0 1.90 KB CROSS JOIN, BROADCAST | | |--182:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 BROADCAST | | | 181:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | | | 180:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cr_call_center_sk) | | | 97:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | | | 96:HASH JOIN 129 0.000ns 0.000ns 0 1.44B 0 1.94 MB INNER JOIN, BROADCAST | | | |--179:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | | 95:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | | 94:SCAN HDFS 129 0.000ns 0.000ns 0 1.44B 0 48.00 MB tpcds_10000_decimal_parquet.catalog_returns | | 178:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | | 177:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cs_call_center_sk) | | 93:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | | 92:HASH JOIN 129 0.000ns 0.000ns 0 14.40B 0 1.94 MB INNER JOIN, BROADCAST | | |--176:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 91:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 90:SCAN HDFS 129 0.000ns 0.000ns 0 14.40B 0 144.00 MB tpcds_10000_decimal_parquet.catalog_sales | |--111:HASH JOIN 129 0.000ns 0.000ns 0 3.98K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED | | |--190:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | | | 189:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | | | 110:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | | | 109:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | | |--188:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | | | 107:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | | | 108:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | | |--187:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | | 106:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | | 105:SCAN HDFS 129 0.000ns 0.000ns 0 720.02M 0 48.00 MB tpcds_10000_decimal_parquet.web_returns | | 186:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | | 185:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | | 104:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | | 103:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | | |--184:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | | 101:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | | 102:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | | |--183:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 100:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 99:SCAN HDFS 129 0.000ns 0.000ns 0 7.20B 0 48.00 MB tpcds_10000_decimal_parquet.web_sales | 89:HASH JOIN 129 0.000ns 0.000ns 0 1.47K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED | |--175:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE | | 174:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) | | 88:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING | | 87:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | | |--173:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | | | 85:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store | | 86:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | | |--172:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 84:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 83:SCAN HDFS 129 0.000ns 0.000ns 0 2.88B 0 48.00 MB tpcds_10000_decimal_parquet.store_returns | 171:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE | 170:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) | 82:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING | 81:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST | |--169:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | | 79:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store | 80:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST | |--168:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | 78:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | 77:SCAN HDFS 129 0.000ns 0.000ns 0 28.80B 0 48.00 MB tpcds_10000_decimal_parquet.store_sales 140:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB FINALIZE 139:EXCHANGE 129 0.000ns 0.000ns 0 8.36K 0 0 HASH(channel,id) 37:AGGREGATE 129 0.000ns 0.000ns 0 8.36K 0 10.00 MB STREAMING 01:UNION 129 0.000ns 0.000ns 0 8.36K 0 0 |--23:NESTED LOOP JOIN 129 0.000ns 0.000ns 0 2.92K 0 1.90 KB CROSS JOIN, BROADCAST | |--130:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 BROADCAST | | 129:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | | 128:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cr_call_center_sk) | | 22:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | | 21:HASH JOIN 129 0.000ns 0.000ns 0 1.44B 0 1.94 MB INNER JOIN, BROADCAST | | |--127:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 20:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 19:SCAN HDFS 129 0.000ns 0.000ns 0 1.44B 0 48.00 MB tpcds_10000_decimal_parquet.catalog_returns | 126:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB FINALIZE | 125:EXCHANGE 129 0.000ns 0.000ns 0 54 0 0 HASH(cs_call_center_sk) | 18:AGGREGATE 129 0.000ns 0.000ns 0 54 0 10.00 MB STREAMING | 17:HASH JOIN 129 0.000ns 0.000ns 0 14.40B 0 1.94 MB INNER JOIN, BROADCAST | |--124:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | 16:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | 15:SCAN HDFS 129 0.000ns 0.000ns 0 14.40B 0 144.00 MB tpcds_10000_decimal_parquet.catalog_sales |--36:HASH JOIN 129 0.000ns 0.000ns 0 3.98K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED | |--138:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | | 137:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | | 35:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | | 34:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | |--136:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | | 32:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | | 33:HASH JOIN 129 0.000ns 0.000ns 0 720.02M 0 1.94 MB INNER JOIN, BROADCAST | | |--135:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | | 31:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | | 30:SCAN HDFS 129 0.000ns 0.000ns 0 720.02M 0 48.00 MB tpcds_10000_decimal_parquet.web_returns | 134:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB FINALIZE | 133:EXCHANGE 129 0.000ns 0.000ns 0 3.98K 0 0 HASH(wp_web_page_sk) | 29:AGGREGATE 129 0.000ns 0.000ns 0 3.98K 0 10.00 MB STREAMING | 28:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | |--132:EXCHANGE 129 0.000ns 0.000ns 0 4.00K 0 0 BROADCAST | | 26:SCAN HDFS 1 0.000ns 0.000ns 0 4.00K 0 16.00 MB tpcds_10000_decimal_parquet.web_page | 27:HASH JOIN 129 0.000ns 0.000ns 0 7.20B 0 1.94 MB INNER JOIN, BROADCAST | |--131:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | 25:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | 24:SCAN HDFS 129 0.000ns 0.000ns 0 7.20B 0 48.00 MB tpcds_10000_decimal_parquet.web_sales 14:HASH JOIN 129 0.000ns 0.000ns 0 1.47K 0 1.94 MB LEFT OUTER JOIN, PARTITIONED |--123:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE | 122:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) | 13:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING | 12:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | |--121:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | | 10:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store | 11:HASH JOIN 129 0.000ns 0.000ns 0 2.88B 0 1.94 MB INNER JOIN, BROADCAST | |--120:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | | 09:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim | 08:SCAN HDFS 129 0.000ns 0.000ns 0 2.88B 0 48.00 MB tpcds_10000_decimal_parquet.store_returns 119:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB FINALIZE 118:EXCHANGE 129 0.000ns 0.000ns 0 1.47K 0 0 HASH(s_store_sk) 07:AGGREGATE 129 0.000ns 0.000ns 0 1.47K 0 10.00 MB STREAMING 06:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST |--117:EXCHANGE 129 0.000ns 0.000ns 0 1.50K 0 0 BROADCAST | 04:SCAN HDFS 1 0.000ns 0.000ns 0 1.50K 0 16.00 MB tpcds_10000_decimal_parquet.store 05:HASH JOIN 129 0.000ns 0.000ns 0 28.80B 0 1.94 MB INNER JOIN, BROADCAST |--116:EXCHANGE 129 0.000ns 0.000ns 0 7.30K 0 0 BROADCAST | 03:SCAN HDFS 1 0.000ns 0.000ns 0 7.30K 0 32.00 MB tpcds_10000_decimal_parquet.date_dim 02:SCAN HDFS 129 0.000ns 0.000ns 0 28.80B 0 48.00 MB tpcds_10000_decimal_parquet.store_sales Errors: Query Compilation: 6s037ms - Metadata of all 9 tables cached: 5.371ms (5.371ms) - Analysis finished: 67.655ms (62.284ms) - Value transfer graph computed: 69.409ms (1.753ms) - Single node plan created: 5s873ms (5s804ms) - Runtime filters computed: 5s886ms (12.989ms) - Distributed plan created: 5s887ms (518.328us) - Lineage info computed: 5s888ms (984.378us) - Planning finished: 6s037ms (149.121ms) Query Timeline: 27s235ms - Query submitted: 28.118us (28.118us) - Planning finished: 14s248ms (14s248ms) - Submit for admission: 23s363ms (9s114ms) - Completed admission: 23s363ms (101.798us) - Ready to start on 129 backends: 23s466ms (102.865ms) - All 129 execution backends (3644 fragment instances) started: 26s893ms (3s427ms) - Released admission control resources: 26s896ms (2.407ms) - Unregister query: 27s229ms (333.709ms) - ComputeScanRangeAssignmentTimer: 5s689ms ImpalaServer: - ClientFetchWaitTimer: 0.000ns - RowMaterializationTimer: 0.000ns