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)
