for a test query with the following plan:
LogicalProject(name=[$1], friends=[$4])
LogicalCorrelate(correlation=[$cor0], joinType=[inner], requiredColumns=[{0}])
LogicalTableScan(table=[[characters]])
Collect(field=[EXPR$0])
LogicalProject(name=[$2])
LogicalJoin(condition=[=($0, $1)], joinType=[inner])
LogicalProject(characterId2=[$1])
LogicalFilter(condition=[=($0, $cor0.characterId)])
LogicalTableScan(table=[[friendships]])
LogicalProject(characterId=[$0], name=[$1])
LogicalTableScan(table=[[characters]])
I get :
java.lang.nsupportedOperationException
at
o.a.c.i.JaninoRexCompiler.lambda$compile$0(JaninoRexCompiler.java:94)[calcite-core-1.21.0.jar:1.21.0]
at
o.a.c.a.e.RexToLixTranslator.translate0(RexToLixTranslator.java:714)[^]
at ^.translate(^:199)[^]
at ^.translate0(^:684)[^]
at ^.translate(^:199)[^]
at ^.translate(^:194)[^]
...
when trying to use the Interpreter.
Is this a current limitation?
the query is :
select name,
ARRAY(select c2.name from friendships f, characters c2
where f.characterId1 = c.characterId and
f.characterId2 = c2.characterId) as friends
from characters c
let me know
thank you
—Z