Wang Yanlin created CALCITE-3561: ------------------------------------ Summary: Support using unnest in Interpreter Key: CALCITE-3561 URL: https://issues.apache.org/jira/browse/CALCITE-3561 Project: Calcite Issue Type: Improvement Reporter: Wang Yanlin
Using unnest in Interpreter will cause exception, {code:java} // InterpreterTest @Test public void testInterpretUnnest() throws Exception { final String sql = "select * from unnest(multiset[1, 2])"; sql(sql).returnsRows("[1]", "[2]"); } {code} got {code:java} java.lang.AssertionError: interpreter: no implementation for class org.apache.calcite.rel.core.Uncollect at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visit(Interpreter.java:463) at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(Nodes.java:44) at org.apache.calcite.rel.SingleRel.childrenAccept(SingleRel.java:72) at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visit(Interpreter.java:450) at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(Nodes.java:44) at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visitRoot(Interpreter.java:408) at org.apache.calcite.interpreter.Interpreter.<init>(Interpreter.java:89) at org.apache.calcite.test.InterpreterTest$Sql.returnsRows(InterpreterTest.java:121) at org.apache.calcite.test.InterpreterTest$Sql.returnsRows(InterpreterTest.java:105) at org.apache.calcite.test.InterpreterTest.testInterpretUnnest(InterpreterTest.java:446) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {code} Add support to use unnest in Interpreter. -- This message was sent by Atlassian Jira (v8.3.4#803005)