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