drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.
Date Fri, 23 Mar 2018 09:08:00 GMT

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

Arina Ielchiieva reassigned DRILL-6212:
---------------------------------------

    Assignee: Arina Ielchiieva  (was: Volodymyr Vysotskyi)

> A simple join is recursing too deep in planning and eventually throwing stack overflow.
> ---------------------------------------------------------------------------------------
>
>                 Key: DRILL-6212
>                 URL: https://issues.apache.org/jira/browse/DRILL-6212
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning &amp; Optimization
>    Affects Versions: 1.12.0
>            Reporter: Hanumath Rao Maduri
>            Assignee: Arina Ielchiieva
>            Priority: Critical
>             Fix For: 1.14.0
>
>
> Create two views using following statements.
> {code}
> create view v1 as select cast(greeting as int) f from dfs.`/home/mapr/data/json/temp.json`;
> create view v2 as select cast(greeting as int) f from dfs.`/home/mapr/data/json/temp.json`;
> {code}
> Executing the following join query produces a stack overflow during the planning phase.
> {code}
> select t1.f from dfs.tmp.v1 as t inner join dfs.tmp.v2 as t1 on cast(t.f as int) = cast(t1.f
as int) and cast(t.f as int) = 10 and cast(t1.f as int) = 10;
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message