testdata/workloads/functional-query/queries/QueryTest/explain-level1.test

====
---- QUERY
# Explain a simple hash join query.
explain
select *
from tpch.lineitem join tpch.orders on l_orderkey = o_orderkey;
---- RESULTS: VERIFY_IS_EQUAL
row_regex:.*Max Per-Host Resource Reservation: Memory=[0-9.]*MB Threads=[0-9]*.*
row_regex:.*Per-Host Resource Estimates: Memory=[0-9.]*MB.*
''
'PLAN-ROOT SINK'
'|'
'04:EXCHANGE [UNPARTITIONED]'
'|'
'02:HASH JOIN [INNER JOIN, BROADCAST]'
'|  hash predicates: l_orderkey = o_orderkey'
'|  runtime filters: RF000 <- o_orderkey'
row_regex:.*row-size=.* cardinality=.*
'|'
'|--03:EXCHANGE [BROADCAST]'
'|  |'
'|  01:SCAN $FILESYSTEM_NAME [tpch.orders]'
row_regex:.*partitions=1/1 files=1 size=.*
row_regex:.*row-size=.* cardinality=.*
'|'
'00:SCAN $FILESYSTEM_NAME [tpch.lineitem]'
row_regex:.*partitions=1/1 files=1 size=.*
'   runtime filters: RF000 -> l_orderkey'
row_regex:.*row-size=.* cardinality=.*
====
---- 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'
====
---- QUERY
# Tests the set operation statement rewrite
explain select year, month from functional.alltypes
  intersect
select year, month from functional.alltypes where year=2009;
---- RESULTS: VERIFY_IS_SUBSET
'04:HASH JOIN [LEFT SEMI JOIN, PARTITIONED]'
====
---- QUERY
# Tests for no cache key without ENABLE_TUPLE_CACHE
explain select count(*) from tpch.region
---- RESULTS: VERIFY_IS_NOT_IN
row_regex:.* cache key: [0-9a-f][0-9a-f]*.*
row_regex:.*\[TPlanNode\(.*\]
====
---- QUERY
# Tests for cache key and no trace with ENABLE_TUPLE_CACHE
set ENABLE_TUPLE_CACHE=TRUE;
explain select count(*) from tpch.region
---- RESULTS: VERIFY_IS_SUBSET
row_regex:.* cache key: [0-9a-f][0-9a-f]*.*
====