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)
