You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Alexander Behm (JIRA)" <ji...@apache.org> on 2017/05/01 21:50:04 UTC

[jira] [Resolved] (IMPALA-3913) Flaky planner FE test in testJoins

     [ https://issues.apache.org/jira/browse/IMPALA-3913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Behm resolved IMPALA-3913.
------------------------------------
    Resolution: Duplicate

Duplicates IMPALA-3887

> Flaky planner FE test in testJoins
> ----------------------------------
>
>                 Key: IMPALA-3913
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3913
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 2.8.0
>            Reporter: Jim Apple
>            Assignee: Alexander Behm
>            Priority: Minor
>              Labels: broken-build
>
> http://sandbox.jenkins.cloudera.com/view/Impala/view/Evergreen-cdh5-trunk/job/impala-cdh5-trunk-core/640/testReport/junit/com.cloudera.impala.planner/PlannerTest/testJoins/
> {noformat}
> Section DISTRIBUTEDPLAN of query:
> select * from functional.alltypessmall a, functional.alltypessmall b where a.id = b.id limit 1
> Actual does not match expected result:
> 04:EXCHANGE [UNPARTITIONED]
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^
> |  limit: 1
> |
> 02:HASH JOIN [INNER JOIN, BROADCAST]
> |  hash predicates: a.id = b.id
> |  runtime filters: RF000 <- b.id
> |  limit: 1
> |
> |--03:EXCHANGE [BROADCAST]
> |  |
> |  01:SCAN HDFS [functional.alltypessmall b]
> |     partitions=4/4 files=4 size=6.32KB
> |
> 00:SCAN HDFS [functional.alltypessmall a]
>    partitions=4/4 files=4 size=6.32KB
>    runtime filters: RF000 -> a.id
> Expected:
> 05:EXCHANGE [UNPARTITIONED]
> |  limit: 1
> |
> 02:HASH JOIN [INNER JOIN, PARTITIONED]
> |  hash predicates: a.id = b.id
> |  runtime filters: RF000 <- b.id
> |  limit: 1
> |
> |--04:EXCHANGE [HASH(b.id)]
> |  |
> |  01:SCAN HDFS [functional.alltypessmall b]
> |     partitions=4/4 files=4 size=6.32KB
> |
> 03:EXCHANGE [HASH(a.id)]
> |
> 00:SCAN HDFS [functional.alltypessmall a]
>    partitions=4/4 files=4 size=6.32KB
>    runtime filters: RF000 -> a.id
> Verbose plan:
> F02:PLAN FRAGMENT [UNPARTITIONED]
>   04:EXCHANGE [UNPARTITIONED]
>      limit: 1
>      hosts=2 per-host-mem=unavailable
>      tuple-ids=0,1 row-size=194B cardinality=1
> F00:PLAN FRAGMENT [RANDOM]
>   DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, UNPARTITIONED]
>   02:HASH JOIN [INNER JOIN, BROADCAST]
>   |  hash predicates: a.id = b.id
>   |  runtime filters: RF000 <- b.id
>   |  limit: 1
>   |  hosts=2 per-host-mem=10.42KB
>   |  tuple-ids=0,1 row-size=194B cardinality=1
>   |
>   |--03:EXCHANGE [BROADCAST]
>   |     hosts=2 per-host-mem=0B
>   |     tuple-ids=1 row-size=97B cardinality=100
>   |
>   00:SCAN HDFS [functional.alltypessmall a, RANDOM]
>      partitions=4/4 files=4 size=6.32KB
>      runtime filters: RF000 -> a.id
>      table stats: 100 rows total
>      column stats: all
>      hosts=2 per-host-mem=48.00MB
>      tuple-ids=0 row-size=97B cardinality=100
> F01:PLAN FRAGMENT [RANDOM]
>   DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=03, BROADCAST]
>   01:SCAN HDFS [functional.alltypessmall b, RANDOM]
>      partitions=4/4 files=4 size=6.32KB
>      table stats: 100 rows total
>      column stats: all
>      hosts=2 per-host-mem=48.00MB
>      tuple-ids=1 row-size=97B cardinality=100
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)