[CALCITE-3561] Implement Uncollect relational operator in Interpreter (for SQL queries that use UNNEST)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Wang Yanlin
• Reporter: Wang Yanlin
• Created: 04/Dec/19 05:57
• Updated: 28/May/21 10:09
• Resolved: 05/Dec/19 04:31

Description

Using unnest in Interpreter will cause exception,

// InterpreterTest
@Test public void testInterpretUnnest() throws Exception {
    final String sql = "select * from unnest(multiset[1, 2])";
    sql(sql).returnsRows("[1]", "[2]");
  }

got

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)

Add support to use unnest in Interpreter.

Issue Links

• links to: GitHub Pull Request #1626