Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4804

PlannerTest shows wrong number of hosts

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • Impala 2.9.0
    • None
    • Frontend

    Description

      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
         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
         hosts=3 per-host-mem=unavailable
         tuple-ids=0 row-size=254B cardinality=15000
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            twmarshall Thomas Tauber-Marshall
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: