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) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org