[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16504458#comment-16504458 ]
Volodymyr Vysotskyi commented on DRILL-6212: -------------------------------------------- [~cshi], I think the more proper fix should be done in Calcite (CALCITE-2223). Please let me know if you have some suggestions for fixing this problem in Calcite. > 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)