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

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

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;