[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16461897#comment-16461897 ]
Pritesh Maker commented on DRILL-6212: -------------------------------------- [~hanu.ncr], [~cshi] is there is a PR for the fix being referenced here? > 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: Chunhui Shi > 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)