[jira] [Created] (IMPALA-7348) PlannerTest.testKuduSelectivity failing due to missing Cardinality information

["nithya (JIRA)" <ji...@apache.org>]

nithya created IMPALA-7348:
------------------------------

             Summary: PlannerTest.testKuduSelectivity failing due to missing Cardinality information
                 Key: IMPALA-7348
                 URL: https://issues.apache.org/jira/browse/IMPALA-7348
             Project: IMPALA
          Issue Type: Bug
            Reporter: nithya


PlannerTest.testKuduSelectivity failed in the recent run. It is an assertion failure to unavailable cardinality information.

Assertion failure as follows

{code}

Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1

{code}

 

Verbose plan

{code}

Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id = '8600000US00601' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id != '1' and zip = '2' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id != '1' and zip = '2' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id > '1' and zip > '2' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: zip > '2', id > '1' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id > '1' and zip > '2' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: zip > '2', id > '1' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id = '1' or id = '2' or zip = '3' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id = '1' or id = '2' or zip = '3' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable
h3. Stacktrace

java.lang.AssertionError: Section PLAN of query: select * from functional_kudu.zipcode_incomes where id = '8600000US00601' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id = '8600000US00601' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id = '8600000US00601' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id != '1' and zip = '2' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id != '1' and zip = '2' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=1 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id != '1' kudu predicates: zip = '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id > '1' and zip > '2' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: zip > '2', id > '1' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id > '1' and zip > '2' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: zip > '2', id > '1' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3317 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] kudu predicates: id > '1', zip > '2' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section PLAN of query: select * from functional_kudu.zipcode_incomes where id = '1' or id = '2' or zip = '3' Actual does not match expected result: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Expected: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 Verbose plan: F00: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 | 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Section DISTRIBUTEDPLAN of query: select * from functional_kudu.zipcode_incomes where id = '1' or id = '2' or zip = '3' Actual does not match expected result: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable Expected: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=124B cardinality=3 Verbose plan: F01: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 | 01:EXCHANGE [UNPARTITIONED] mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=0B mem-reservation=0B DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=01, UNPARTITIONED] | mem-estimate=0B mem-reservation=0B 00:SCAN KUDU [functional_kudu.zipcode_incomes] predicates: id IN ('1', '2') OR zip = '3' mem-estimate=0B mem-reservation=0B tuple-ids=0 row-size=68B cardinality=unavailable at org.junit.Assert.fail(Assert.java:88) at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:841) at org.apache.impala.planner.PlannerTestBase.runPlannerTestFile(PlannerTestBase.java:779) at org.apache.impala.planner.PlannerTest.testKuduSelectivity(PlannerTest.java:355)

{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)