You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Thomas Tauber-Marshall (JIRA)" <ji...@apache.org> on 2018/09/18 20:08:00 UTC
[jira] [Resolved] (IMPALA-7348) PlannerTest.testKuduSelectivity
failing due to missing Cardinality information
[ https://issues.apache.org/jira/browse/IMPALA-7348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Tauber-Marshall resolved IMPALA-7348.
--------------------------------------------
Resolution: Fixed
Fix Version/s: Impala 3.1.0
> 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: Thomas Tauber-Marshall
> Priority: Blocker
> Labels: broken-build
> Fix For: Impala 3.1.0
>
>
> 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org