====
---- QUERY
# Explain a simple hash join query.
explain
select *
from tpch.lineitem join tpch.orders on l_orderkey = o_orderkey;
---- RESULTS: VERIFY_IS_EQUAL
'Max Per-Host Resource Reservation: Memory=34.00MB'
'Per-Host Resource Estimates: Memory=476.41MB'
''
'F02: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'
'  |'
'  04:EXCHANGE [UNPARTITIONED]'
'     mem-estimate=0B mem-reservation=0B'
'     tuple-ids=0,1 row-size=454B cardinality=5757710'
''
'F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3'
'Per-Host Resources: mem-estimate=388.41MB mem-reservation=34.00MB'
'  DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, UNPARTITIONED]'
'  |  mem-estimate=0B mem-reservation=0B'
'  02:HASH JOIN [INNER JOIN, BROADCAST]'
'  |  hash predicates: l_orderkey = o_orderkey'
'  |  fk/pk conjuncts: l_orderkey = o_orderkey'
'  |  runtime filters: RF000 <- o_orderkey'
'  |  mem-estimate=300.41MB mem-reservation=34.00MB spill-buffer=2.00MB'
'  |  tuple-ids=0,1 row-size=454B cardinality=5757710'
'  |'
'  |--03:EXCHANGE [BROADCAST]'
'  |     mem-estimate=0B mem-reservation=0B'
'  |     tuple-ids=1 row-size=191B cardinality=1500000'
'  |'
'  00:SCAN HDFS [tpch.lineitem, RANDOM]'
row_regex:.*partitions=1/1 files=1 size=.*
'     runtime filters: RF000 -> l_orderkey'
'     stats-rows=6001215 extrapolated-rows=disabled'
'     table stats: rows=6001215 size=718.94MB'
'     column stats: all'
'     mem-estimate=88.00MB mem-reservation=0B'
'     tuple-ids=0 row-size=263B cardinality=6001215'
''
'F01:PLAN FRAGMENT [RANDOM] hosts=2 instances=2'
'Per-Host Resources: mem-estimate=88.00MB mem-reservation=0B'
'  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=03, BROADCAST]'
'  |  mem-estimate=0B mem-reservation=0B'
'  01:SCAN HDFS [tpch.orders, RANDOM]'
row_regex:.*partitions=1/1 files=1 size=.*
'     stats-rows=1500000 extrapolated-rows=disabled'
'     table stats: rows=1500000 size=162.56MB'
'     column stats: all'
'     mem-estimate=88.00MB mem-reservation=0B'
'     tuple-ids=1 row-size=191B cardinality=1500000'
====
---- QUERY
# Tests the warning about missing table stats in the explain header.
explain select count(t1.int_col), avg(t2.float_col), sum(t3.bigint_col)
from functional_avro.alltypes t1
  inner join functional_parquet.alltypessmall t2 on (t1.id = t2.id)
  left outer join functional_avro.alltypes t3 on (t2.id = t3.id)
where t1.month = 1 and t2.year = 2009 and t3.bool_col = false
---- RESULTS: VERIFY_IS_SUBSET
'WARNING: The following tables are missing relevant table and/or column statistics.'
'functional_avro.alltypes, functional_parquet.alltypessmall'
====