[ https://issues.apache.org/jira/browse/IMPALA-7348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16603236#comment-16603236 ]
Philip Zeyliger commented on IMPALA-7348: ----------------------------------------- Saw this again. The two tests were: org.apache.impala.planner.PlannerTest.testMinMaxRuntimeFilters and org.apache.impala.planner.PlannerTest.testKudu Here's the plan differences: {code} hash predicates: a.int_col = b.tinyint_col + 1, a.string_col = b.string_col vs hash predicates: a.string_col = b.string_col, a.int_col = b.tinyint_col + 1 {code} and {code} predicates: bigint_col IN (NULL), bool_col IN (NULL), double_col IN (NULL), float_col IN (NULL), smallint_col IN (NULL), string_col IN (NULL), tinyint_col IN (NULL), id IN (1, NULL) vs predicates: id IN (1, NULL), bigint_col IN (NULL), bool_col IN (NULL), double_col IN (NULL), float_col IN (NULL), smallint_col IN (NULL), string_col IN (NULL), tinyint_col IN (NULL) {code} Curiously, this is all happening only within Kudu. The verbose plans indicate that cardinality is unavailable, which makes me think that {{orderConjunctsByCost}} is stable, but we're missing cardinality information. > 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 > Components: Infrastructure > Reporter: nithya > Assignee: Vuk Ercegovac > Priority: Blocker > Labels: broken-build > > PlannerTest.testKuduSelectivity failed in the recent run. It is an assertion > failure to unavailable cardinality information. > Assertion failure as follows > {code:java} > 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:java} > 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 > 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