FAILED TESTS
================================================
3 tests failed.
REGRESSION:  org.apache.impala.planner.PlannerTest.testTpchNested

Error Message:

Section DISTRIBUTEDPLAN of query:
select
  sum(l_extendedprice) / 7.0 as avg_yearly
from
  customer.c_orders.o_lineitems l,
  part p
where
  p_partkey = l_partkey
  and p_brand = 'Brand#23'
  and p_container = 'MED BOX'
  and l_quantity < (
    select
      0.2 * avg(l_quantity)
    from
      customer.c_orders.o_lineitems l
    where
      l_partkey = p_partkey
  )

Actual does not match expected result:
PLAN-ROOT SINK
|
12:AGGREGATE [FINALIZE]
|  output: sum:merge(l_extendedprice)
|
11:EXCHANGE [UNPARTITIONED]
|
06:AGGREGATE
|  output: sum(l_extendedprice)
|
05:HASH JOIN [LEFT SEMI JOIN, BROADCAST]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  hash predicates: p_partkey = l_partkey
|  other join predicates: l_quantity < 0.2 * avg(l_quantity)
|  runtime filters: RF000 <- l_partkey
|
|--10:EXCHANGE [BROADCAST]
|  |
|  09:AGGREGATE [FINALIZE]
|  |  output: avg:merge(l_quantity)
|  |  group by: l_partkey
|  |
|  08:EXCHANGE [HASH(l_partkey)]
|  |
|  03:AGGREGATE [STREAMING]
|  |  output: avg(l_quantity)
|  |  group by: l_partkey
|  |
|  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
|     partitions=1/1 files=4 size=292.36MB
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: l_partkey = p_partkey
|  runtime filters: RF001 <- p_partkey
|
|--07:EXCHANGE [BROADCAST]
|  |
|  01:SCAN HDFS [tpch_nested_parquet.part p]
|     partitions=1/1 files=1 size=6.23MB
|     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
|     runtime filters: RF000 -> p_partkey
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
   partitions=1/1 files=4 size=292.36MB
   runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey

Expected:
PLAN-ROOT SINK
|
12:AGGREGATE [FINALIZE]
|  output: sum:merge(l_extendedprice)
|
11:EXCHANGE [UNPARTITIONED]
|
06:AGGREGATE
|  output: sum(l_extendedprice)
|
05:HASH JOIN [LEFT SEMI JOIN, PARTITIONED]
|  hash predicates: p_partkey = l_partkey
|  other join predicates: l_quantity < 0.2 * avg(l_quantity)
|  runtime filters: RF000 <- l_partkey
|
|--09:AGGREGATE [FINALIZE]
|  |  output: avg:merge(l_quantity)
|  |  group by: l_partkey
|  |
|  08:EXCHANGE [HASH(l_partkey)]
|  |
|  03:AGGREGATE [STREAMING]
|  |  output: avg(l_quantity)
|  |  group by: l_partkey
|  |
|  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
|     partitions=1/1 files=4 size=577.87MB
|
10:EXCHANGE [HASH(p_partkey)]
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: l_partkey = p_partkey
|  runtime filters: RF001 <- p_partkey
|
|--07:EXCHANGE [BROADCAST]
|  |
|  01:SCAN HDFS [tpch_nested_parquet.part p]
|     partitions=1/1 files=1 size=6.20MB
|     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
|     runtime filters: RF000 -> p_partkey
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
   partitions=1/1 files=4 size=577.87MB
   runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey

Verbose plan:
F04:PLAN FRAGMENT [UNPARTITIONED]
  PLAN-ROOT SINK
  |
  12:AGGREGATE [FINALIZE]
  |  output: sum:merge(l_extendedprice)
  |  hosts=2 per-host-mem=unavailable
  |  tuple-ids=6 row-size=16B cardinality=1
  |
  11:EXCHANGE [UNPARTITIONED]
     hosts=2 per-host-mem=unavailable
     tuple-ids=6 row-size=16B cardinality=1

F00:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=11, UNPARTITIONED]
  06:AGGREGATE
  |  output: sum(l_extendedprice)
  |  hosts=2 per-host-mem=10.00MB
  |  tuple-ids=6 row-size=16B cardinality=1
  |
  05:HASH JOIN [LEFT SEMI JOIN, BROADCAST]
  |  hash predicates: p_partkey = l_partkey
  |  other join predicates: l_quantity < 0.2 * avg(l_quantity)
  |  runtime filters: RF000 <- l_partkey
  |  hosts=2 per-host-mem=251.77MB
  |  tuple-ids=0,1 row-size=80B cardinality=15000000
  |
  |--10:EXCHANGE [BROADCAST]
  |     hosts=2 per-host-mem=0B
  |     tuple-ids=4 row-size=16B cardinality=15000000
  |
  04:HASH JOIN [INNER JOIN, BROADCAST]
  |  hash predicates: l_partkey = p_partkey
  |  runtime filters: RF001 <- p_partkey
  |  hosts=2 per-host-mem=59.70KB
  |  tuple-ids=0,1 row-size=80B cardinality=15000000
  |
  |--07:EXCHANGE [BROADCAST]
  |     hosts=1 per-host-mem=0B
  |     tuple-ids=1 row-size=56B cardinality=1000
  |
  00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l, RANDOM]
     partitions=1/1 files=4 size=292.36MB
     runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey
     table stats: 150000 rows total
     column stats: all
     hosts=2 per-host-mem=264.00MB
     tuple-ids=0 row-size=24B cardinality=15000000

F01:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=07, BROADCAST]
  01:SCAN HDFS [tpch_nested_parquet.part p, RANDOM]
     partitions=1/1 files=1 size=6.23MB
     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     runtime filters: RF000 -> p_partkey
     table stats: 200000 rows total
     column stats: all
     parquet statistics predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     parquet dictionary predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     hosts=1 per-host-mem=48.00MB
     tuple-ids=1 row-size=56B cardinality=1000

F03:PLAN FRAGMENT [HASH(l_partkey)]
  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=10, BROADCAST]
  09:AGGREGATE [FINALIZE]
  |  output: avg:merge(l_quantity)
  |  group by: l_partkey
  |  hosts=2 per-host-mem=128.00MB
  |  tuple-ids=4 row-size=16B cardinality=15000000
  |
  08:EXCHANGE [HASH(l_partkey)]
     hosts=2 per-host-mem=0B
     tuple-ids=3 row-size=16B cardinality=15000000

F02:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=08, HASH(l_partkey)]
  03:AGGREGATE [STREAMING]
  |  output: avg(l_quantity)
  |  group by: l_partkey
  |  hosts=2 per-host-mem=128.00MB
  |  tuple-ids=3 row-size=16B cardinality=15000000
  |
  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l, RANDOM]
     partitions=1/1 files=4 size=292.36MB
     table stats: 150000 rows total
     column stats: all
     hosts=2 per-host-mem=176.00MB
     tuple-ids=2 row-size=16B cardinality=15000000


Stack Trace:
java.lang.AssertionError:
Section DISTRIBUTEDPLAN of query:
select
  sum(l_extendedprice) / 7.0 as avg_yearly
from
  customer.c_orders.o_lineitems l,
  part p
where
  p_partkey = l_partkey
  and p_brand = 'Brand#23'
  and p_container = 'MED BOX'
  and l_quantity < (
    select
      0.2 * avg(l_quantity)
    from
      customer.c_orders.o_lineitems l
    where
      l_partkey = p_partkey
  )

Actual does not match expected result:
PLAN-ROOT SINK
|
12:AGGREGATE [FINALIZE]
|  output: sum:merge(l_extendedprice)
|
11:EXCHANGE [UNPARTITIONED]
|
06:AGGREGATE
|  output: sum(l_extendedprice)
|
05:HASH JOIN [LEFT SEMI JOIN, BROADCAST]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  hash predicates: p_partkey = l_partkey
|  other join predicates: l_quantity < 0.2 * avg(l_quantity)
|  runtime filters: RF000 <- l_partkey
|
|--10:EXCHANGE [BROADCAST]
|  |
|  09:AGGREGATE [FINALIZE]
|  |  output: avg:merge(l_quantity)
|  |  group by: l_partkey
|  |
|  08:EXCHANGE [HASH(l_partkey)]
|  |
|  03:AGGREGATE [STREAMING]
|  |  output: avg(l_quantity)
|  |  group by: l_partkey
|  |
|  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
|     partitions=1/1 files=4 size=292.36MB
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: l_partkey = p_partkey
|  runtime filters: RF001 <- p_partkey
|
|--07:EXCHANGE [BROADCAST]
|  |
|  01:SCAN HDFS [tpch_nested_parquet.part p]
|     partitions=1/1 files=1 size=6.23MB
|     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
|     runtime filters: RF000 -> p_partkey
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
   partitions=1/1 files=4 size=292.36MB
   runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey

Expected:
PLAN-ROOT SINK
|
12:AGGREGATE [FINALIZE]
|  output: sum:merge(l_extendedprice)
|
11:EXCHANGE [UNPARTITIONED]
|
06:AGGREGATE
|  output: sum(l_extendedprice)
|
05:HASH JOIN [LEFT SEMI JOIN, PARTITIONED]
|  hash predicates: p_partkey = l_partkey
|  other join predicates: l_quantity < 0.2 * avg(l_quantity)
|  runtime filters: RF000 <- l_partkey
|
|--09:AGGREGATE [FINALIZE]
|  |  output: avg:merge(l_quantity)
|  |  group by: l_partkey
|  |
|  08:EXCHANGE [HASH(l_partkey)]
|  |
|  03:AGGREGATE [STREAMING]
|  |  output: avg(l_quantity)
|  |  group by: l_partkey
|  |
|  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
|     partitions=1/1 files=4 size=577.87MB
|
10:EXCHANGE [HASH(p_partkey)]
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: l_partkey = p_partkey
|  runtime filters: RF001 <- p_partkey
|
|--07:EXCHANGE [BROADCAST]
|  |
|  01:SCAN HDFS [tpch_nested_parquet.part p]
|     partitions=1/1 files=1 size=6.20MB
|     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
|     runtime filters: RF000 -> p_partkey
|
00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l]
   partitions=1/1 files=4 size=577.87MB
   runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey

Verbose plan:
F04:PLAN FRAGMENT [UNPARTITIONED]
  PLAN-ROOT SINK
  |
  12:AGGREGATE [FINALIZE]
  |  output: sum:merge(l_extendedprice)
  |  hosts=2 per-host-mem=unavailable
  |  tuple-ids=6 row-size=16B cardinality=1
  |
  11:EXCHANGE [UNPARTITIONED]
     hosts=2 per-host-mem=unavailable
     tuple-ids=6 row-size=16B cardinality=1

F00:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=11, UNPARTITIONED]
  06:AGGREGATE
  |  output: sum(l_extendedprice)
  |  hosts=2 per-host-mem=10.00MB
  |  tuple-ids=6 row-size=16B cardinality=1
  |
  05:HASH JOIN [LEFT SEMI JOIN, BROADCAST]
  |  hash predicates: p_partkey = l_partkey
  |  other join predicates: l_quantity < 0.2 * avg(l_quantity)
  |  runtime filters: RF000 <- l_partkey
  |  hosts=2 per-host-mem=251.77MB
  |  tuple-ids=0,1 row-size=80B cardinality=15000000
  |
  |--10:EXCHANGE [BROADCAST]
  |     hosts=2 per-host-mem=0B
  |     tuple-ids=4 row-size=16B cardinality=15000000
  |
  04:HASH JOIN [INNER JOIN, BROADCAST]
  |  hash predicates: l_partkey = p_partkey
  |  runtime filters: RF001 <- p_partkey
  |  hosts=2 per-host-mem=59.70KB
  |  tuple-ids=0,1 row-size=80B cardinality=15000000
  |
  |--07:EXCHANGE [BROADCAST]
  |     hosts=1 per-host-mem=0B
  |     tuple-ids=1 row-size=56B cardinality=1000
  |
  00:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l, RANDOM]
     partitions=1/1 files=4 size=292.36MB
     runtime filters: RF000 -> l.l_partkey, RF001 -> l_partkey
     table stats: 150000 rows total
     column stats: all
     hosts=2 per-host-mem=264.00MB
     tuple-ids=0 row-size=24B cardinality=15000000

F01:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=07, BROADCAST]
  01:SCAN HDFS [tpch_nested_parquet.part p, RANDOM]
     partitions=1/1 files=1 size=6.23MB
     predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     runtime filters: RF000 -> p_partkey
     table stats: 200000 rows total
     column stats: all
     parquet statistics predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     parquet dictionary predicates: p_container = 'MED BOX', p_brand = 'Brand#23'
     hosts=1 per-host-mem=48.00MB
     tuple-ids=1 row-size=56B cardinality=1000

F03:PLAN FRAGMENT [HASH(l_partkey)]
  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=10, BROADCAST]
  09:AGGREGATE [FINALIZE]
  |  output: avg:merge(l_quantity)
  |  group by: l_partkey
  |  hosts=2 per-host-mem=128.00MB
  |  tuple-ids=4 row-size=16B cardinality=15000000
  |
  08:EXCHANGE [HASH(l_partkey)]
     hosts=2 per-host-mem=0B
     tuple-ids=3 row-size=16B cardinality=15000000

F02:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=08, HASH(l_partkey)]
  03:AGGREGATE [STREAMING]
  |  output: avg(l_quantity)
  |  group by: l_partkey
  |  hosts=2 per-host-mem=128.00MB
  |  tuple-ids=3 row-size=16B cardinality=15000000
  |
  02:SCAN HDFS [tpch_nested_parquet.customer.c_orders.o_lineitems l, RANDOM]
     partitions=1/1 files=4 size=292.36MB
     table stats: 150000 rows total
     column stats: all
     hosts=2 per-host-mem=176.00MB
     tuple-ids=2 row-size=16B cardinality=15000000

        at org.junit.Assert.fail(Assert.java:88)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:741)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:750)
        at org.apache.impala.planner.PlannerTest.testTpchNested(PlannerTest.java:216)


REGRESSION:  org.apache.impala.planner.PlannerTest.testConstantFolding

Error Message:

Section PLAN of query:
select 1
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where 5 + 5 < c_custkey and o_orderkey = (2 + 2)
  and (coalesce(2, 3, 4) * 10) + l_linenumber < (0 * 1)

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=52B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=52B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=24B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=28B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=28B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=24B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey > 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey = 4
   predicates on o_lineitems: 20 + l_linenumber < 0
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey > 10
   parquet dictionary predicates: c_custkey > 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=24B cardinality=15000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=52B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=52B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=24B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=28B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=28B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=24B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey > 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey = 4
   predicates on o_lineitems: 20 + l_linenumber < 0
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey > 10
   parquet dictionary predicates: c_custkey > 10
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=24B cardinality=15000

Verbose plan:
F00:PLAN FRAGMENT [UNPARTITIONED]
  PLAN-ROOT SINK
  |
  01:SUBPLAN
  |  hosts=2 per-host-mem=unavailable
  |  tuple-ids=2,1,0 row-size=52B cardinality=1500000
  |
  |--08:NESTED LOOP JOIN [CROSS JOIN]
  |  |  hosts=2 per-host-mem=unavailable
  |  |  tuple-ids=2,1,0 row-size=52B cardinality=100
  |  |
  |  |--02:SINGULAR ROW SRC
  |  |     parent-subplan=01
  |  |     hosts=2 per-host-mem=unavailable
  |  |     tuple-ids=0 row-size=24B cardinality=1
  |  |
  |  04:SUBPLAN
  |  |  hosts=2 per-host-mem=unavailable
  |  |  tuple-ids=2,1 row-size=28B cardinality=100
  |  |
  |  |--07:NESTED LOOP JOIN [CROSS JOIN]
  |  |  |  hosts=2 per-host-mem=unavailable
  |  |  |  tuple-ids=2,1 row-size=28B cardinality=10
  |  |  |
  |  |  |--05:SINGULAR ROW SRC
  |  |  |     parent-subplan=04
  |  |  |     hosts=2 per-host-mem=unavailable
  |  |  |     tuple-ids=1 row-size=24B cardinality=1
  |  |  |
  |  |  06:UNNEST [o.o_lineitems]
  |  |     parent-subplan=04
  |  |     hosts=2 per-host-mem=unavailable
  |  |     tuple-ids=2 row-size=0B cardinality=10
  |  |
  |  03:UNNEST [c.c_orders o]
  |     parent-subplan=01
  |     hosts=2 per-host-mem=unavailable
  |     tuple-ids=1 row-size=0B cardinality=10
  |
  00:SCAN HDFS [tpch_nested_parquet.customer c]
     partitions=1/1 files=4 size=292.36MB
     predicates: c_custkey > 10, !empty(c.c_orders)
     predicates on o: !empty(o.o_lineitems), o_orderkey = 4
     predicates on o_lineitems: 20 + l_linenumber < 0
     table stats: 150000 rows total
     columns missing stats: c_orders
     parquet statistics predicates: c_custkey > 10
     parquet dictionary predicates: c_custkey > 10
     hosts=2 per-host-mem=unavailable
     tuple-ids=0 row-size=24B cardinality=15000


Stack Trace:
java.lang.AssertionError:
Section PLAN of query:
select 1
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where 5 + 5 < c_custkey and o_orderkey = (2 + 2)
  and (coalesce(2, 3, 4) * 10) + l_linenumber < (0 * 1)

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=52B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=52B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=24B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=28B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=28B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=24B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey > 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey = 4
   predicates on o_lineitems: 20 + l_linenumber < 0
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey > 10
   parquet dictionary predicates: c_custkey > 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=24B cardinality=15000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=52B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=52B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=24B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=28B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=28B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=24B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey > 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey = 4
   predicates on o_lineitems: 20 + l_linenumber < 0
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey > 10
   parquet dictionary predicates: c_custkey > 10
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=24B cardinality=15000

Verbose plan:
F00:PLAN FRAGMENT [UNPARTITIONED]
  PLAN-ROOT SINK
  |
  01:SUBPLAN
  |  hosts=2 per-host-mem=unavailable
  |  tuple-ids=2,1,0 row-size=52B cardinality=1500000
  |
  |--08:NESTED LOOP JOIN [CROSS JOIN]
  |  |  hosts=2 per-host-mem=unavailable
  |  |  tuple-ids=2,1,0 row-size=52B cardinality=100
  |  |
  |  |--02:SINGULAR ROW SRC
  |  |     parent-subplan=01
  |  |     hosts=2 per-host-mem=unavailable
  |  |     tuple-ids=0 row-size=24B cardinality=1
  |  |
  |  04:SUBPLAN
  |  |  hosts=2 per-host-mem=unavailable
  |  |  tuple-ids=2,1 row-size=28B cardinality=100
  |  |
  |  |--07:NESTED LOOP JOIN [CROSS JOIN]
  |  |  |  hosts=2 per-host-mem=unavailable
  |  |  |  tuple-ids=2,1 row-size=28B cardinality=10
  |  |  |
  |  |  |--05:SINGULAR ROW SRC
  |  |  |     parent-subplan=04
  |  |  |     hosts=2 per-host-mem=unavailable
  |  |  |     tuple-ids=1 row-size=24B cardinality=1
  |  |  |
  |  |  06:UNNEST [o.o_lineitems]
  |  |     parent-subplan=04
  |  |     hosts=2 per-host-mem=unavailable
  |  |     tuple-ids=2 row-size=0B cardinality=10
  |  |
  |  03:UNNEST [c.c_orders o]
  |     parent-subplan=01
  |     hosts=2 per-host-mem=unavailable
  |     tuple-ids=1 row-size=0B cardinality=10
  |
  00:SCAN HDFS [tpch_nested_parquet.customer c]
     partitions=1/1 files=4 size=292.36MB
     predicates: c_custkey > 10, !empty(c.c_orders)
     predicates on o: !empty(o.o_lineitems), o_orderkey = 4
     predicates on o_lineitems: 20 + l_linenumber < 0
     table stats: 150000 rows total
     columns missing stats: c_orders
     parquet statistics predicates: c_custkey > 10
     parquet dictionary predicates: c_custkey > 10
     hosts=2 per-host-mem=unavailable
     tuple-ids=0 row-size=24B cardinality=15000

        at org.junit.Assert.fail(Assert.java:88)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:741)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:705)
        at org.apache.impala.planner.PlannerTest.testConstantFolding(PlannerTest.java:56)


REGRESSION:  org.apache.impala.planner.PlannerTest.testMtDopValidation

Error Message:

Section PLAN of query:
select *
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where c_custkey < 10 and o_orderkey < 5 and l_linenumber < 3

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Verbose plan:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Section PARALLELPLANS of query:
select *
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where c_custkey < 10 and o_orderkey < 5 and l_linenumber < 3

Actual does not match expected result:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Expected:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=3 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=3 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Verbose plan:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Section PLAN of query:
select c.*
from tpch_nested_parquet.customer c, c.c_orders o1, c.c_orders o2
where o1.o_orderkey = o2.o_orderkey + 2 and o1.o_orderkey < 5

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Verbose plan:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Section PARALLELPLANS of query:
select c.*
from tpch_nested_parquet.customer c, c.c_orders o1, c.c_orders o2
where o1.o_orderkey = o2.o_orderkey + 2 and o1.o_orderkey < 5

Actual does not match expected result:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000

Expected:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=3 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=3 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=3 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=3 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000

Verbose plan:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000


Stack Trace:
java.lang.AssertionError:
Section PLAN of query:
select *
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where c_custkey < 10 and o_orderkey < 5 and l_linenumber < 3

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Verbose plan:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=unavailable
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=unavailable
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=254B cardinality=15000

Section PARALLELPLANS of query:
select *
from tpch_nested_parquet.customer c, c.c_orders o, o.o_lineitems
where c_custkey < 10 and o_orderkey < 5 and l_linenumber < 3

Actual does not match expected result:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Expected:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=3 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=3 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=3 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=3 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=3 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=3 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Verbose plan:
PLAN-ROOT SINK
|
09:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=2,1,0 row-size=562B cardinality=1500000
|
|--08:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=254B
|  |  tuple-ids=2,1,0 row-size=562B cardinality=100
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=254B cardinality=1
|  |
|  04:SUBPLAN
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=2,1 row-size=308B cardinality=100
|  |
|  |--07:NESTED LOOP JOIN [CROSS JOIN]
|  |  |  hosts=2 per-host-mem=124B
|  |  |  tuple-ids=2,1 row-size=308B cardinality=10
|  |  |
|  |  |--05:SINGULAR ROW SRC
|  |  |     parent-subplan=04
|  |  |     hosts=2 per-host-mem=0B
|  |  |     tuple-ids=1 row-size=124B cardinality=1
|  |  |
|  |  06:UNNEST [o.o_lineitems]
|  |     parent-subplan=04
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  03:UNNEST [c.c_orders o]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: c_custkey < 10, !empty(c.c_orders)
   predicates on o: !empty(o.o_lineitems), o_orderkey < 5
   predicates on o_lineitems: l_linenumber < 3
   table stats: 150000 rows total
   columns missing stats: c_orders
   parquet statistics predicates: c_custkey < 10
   parquet dictionary predicates: c_custkey < 10
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=254B cardinality=15000

Section PLAN of query:
select c.*
from tpch_nested_parquet.customer c, c.c_orders o1, c.c_orders o2
where o1.o_orderkey = o2.o_orderkey + 2 and o1.o_orderkey < 5

Actual does not match expected result:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Expected:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=3 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Verbose plan:
PLAN-ROOT SINK
|
01:SUBPLAN
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=unavailable
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=unavailable
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=unavailable
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=unavailable
   tuple-ids=0 row-size=270B cardinality=150000

Section PARALLELPLANS of query:
select c.*
from tpch_nested_parquet.customer c, c.c_orders o1, c.c_orders o2
where o1.o_orderkey = o2.o_orderkey + 2 and o1.o_orderkey < 5

Actual does not match expected result:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000

Expected:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=3 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=3 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=3 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=3 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=3 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=3 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000

Verbose plan:
PLAN-ROOT SINK
|
07:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
01:SUBPLAN
|  hosts=2 per-host-mem=0B
|  tuple-ids=1,0,2 row-size=286B cardinality=1500000
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: o1.o_orderkey = o2.o_orderkey + 2
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=1,0,2 row-size=286B cardinality=10
|  |
|  |--04:UNNEST [c.c_orders o2]
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=2 row-size=0B cardinality=10
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |  hosts=2 per-host-mem=270B
|  |  tuple-ids=1,0 row-size=278B cardinality=10
|  |
|  |--02:SINGULAR ROW SRC
|  |     parent-subplan=01
|  |     hosts=2 per-host-mem=0B
|  |     tuple-ids=0 row-size=270B cardinality=1
|  |
|  03:UNNEST [c.c_orders o1]
|     parent-subplan=01
|     hosts=2 per-host-mem=0B
|     tuple-ids=1 row-size=0B cardinality=10
|
00:SCAN HDFS [tpch_nested_parquet.customer c, RANDOM]
   partitions=1/1 files=4 size=292.36MB
   predicates: !empty(c.c_orders), !empty(c.c_orders)
   predicates on o1: o1.o_orderkey < 5
   table stats: 150000 rows total
   columns missing stats: c_orders, c_orders
   hosts=2 per-host-mem=88.00MB
   tuple-ids=0 row-size=270B cardinality=150000

        at org.junit.Assert.fail(Assert.java:88)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:741)
        at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:705)
        at org.apache.impala.planner.PlannerTest.testMtDopValidation(PlannerTest.java:323)