[jira] [Created] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.

["Hanumath Rao Maduri (JIRA)" <ji...@apache.org>]

Hanumath Rao Maduri created DRILL-6212:
------------------------------------------

             Summary: 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 & Optimization
    Affects Versions: 1.12.0
            Reporter: Hanumath Rao Maduri
            Assignee: Hanumath Rao Maduri
             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.v1 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)