Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6212

A simple join is recursing too deep in planning and eventually throwing stack overflow.

    Details

      Description

      Create two views using following statements.

      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`;
      

      Executing the following join query produces a stack overflow during the planning phase.

      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;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gparai Gautam Parai
                Reporter:
                hanu.ncr Hanumath Rao Maduri
                Reviewer:
                Hanumath Rao Maduri
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: