| ==== |
| ---- 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]' |
| '|--03:EXCHANGE [BROADCAST]' |
| '| 01:SCAN HDFS [tpch.orders]' |
| '00:SCAN HDFS [tpch.lineitem]' |
| ==== |
| ---- 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' |
| ==== |