[
https://issues.apache.org/jira/browse/FLINK-20077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-20077:
-----------------------------------
Labels: pull-request-available (was: )
> Cannot register a view with MATCH_RECOGNIZE clause
> --------------------------------------------------
>
> Key: FLINK-20077
> URL: https://issues.apache.org/jira/browse/FLINK-20077
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.11.0, 1.12.0
> Reporter: Dawid Wysakowicz
> Assignee: Dawid Wysakowicz
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.12.0
>
>
> {code}
> TableEnvironment env =
> TableEnvironment.create(EnvironmentSettings.newInstance()
> .useBlinkPlanner()
> .build());
> env.executeSql("" +
> "CREATE TEMPORARY TABLE data (\n" +
> " id INT,\n" +
> " ts AS PROCTIME()\n" +
> ") WITH (\n" +
> " 'connector' = 'datagen',\n" +
> " 'rows-per-second' = '3',\n" +
> " 'fields.id.kind' = 'sequence',\n" +
> " 'fields.id.start' = '1000000',\n" +
> " 'fields.id.end' = '2000000'\n" +
> ")");
> env.executeSql("" +
> "CREATE TEMPORARY VIEW events AS \n" +
> "SELECT 1 AS key, id, MOD(id, 10) AS measurement, ts
> \n" +
> "FROM data");
> env.executeSql("" +
> "CREATE TEMPORARY VIEW foo AS \n" +
> "SELECT * \n" +
> "FROM events MATCH_RECOGNIZE (\n" +
> " PARTITION BY key \n" +
> " ORDER BY ts ASC \n" +
> " MEASURES \n" +
> " this_step.id as startId,\n" +
> " next_step.id as nextId,\n" +
> " this_step.ts AS ts1,\n" +
> " next_step.ts AS ts2,\n" +
> " next_step.measurement - this_step.measurement AS
> diff \n" +
> " AFTER MATCH SKIP TO NEXT ROW \n" +
> " PATTERN (this_step next_step)\n" +
> " DEFINE this_step AS TRUE,\n" +
> " next_step AS TRUE\n" +
> ")");
> env.executeSql("SELECT * FROM foo");
> {code}
> fails with:
> {code}
> java.lang.AssertionError
> at
> org.apache.calcite.sql.SqlMatchRecognize$SqlMatchRecognizeOperator.createCall(SqlMatchRecognize.java:274)
> at
> org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.result(SqlShuttle.java:117)
> at
> org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.result(SqlShuttle.java:101)
> at org.apache.calcite.sql.util.SqlShuttle.visit(SqlShuttle.java:67)
> at
> org.apache.flink.table.planner.utils.Expander$Expanded$1.visit(Expander.java:153)
> at
> org.apache.flink.table.planner.utils.Expander$Expanded$1.visit(Expander.java:130)
> at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:139)
> at
> org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.visitChild(SqlShuttle.java:134)
> at
> org.apache.calcite.sql.util.SqlShuttle$CallCopyingArgHandler.visitChild(SqlShuttle.java:101)
> at org.apache.calcite.sql.SqlOperator.acceptCall(SqlOperator.java:879)
> at
> org.apache.calcite.sql.SqlSelectOperator.acceptCall(SqlSelectOperator.java:133)
> at org.apache.calcite.sql.util.SqlShuttle.visit(SqlShuttle.java:66)
> at
> org.apache.flink.table.planner.utils.Expander$Expanded$1.visit(Expander.java:153)
> at
> org.apache.flink.table.planner.utils.Expander$Expanded$1.visit(Expander.java:130)
> at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:139)
> at
> org.apache.flink.table.planner.utils.Expander$Expanded.substitute(Expander.java:168)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convertViewQuery(SqlToOperationConverter.java:728)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convertCreateView(SqlToOperationConverter.java:699)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:226)
> at
> org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:78)
> at
> org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:658)
> at
> org.apache.flink.table.planner.runtime.stream.table.FunctionITCase.test(FunctionITCase.java:165)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> at
> org.junit.rules.ExpectedException$ExpectedExceptionStatement.evaluate(ExpectedException.java:239)
> at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:48)
> at
> org.junit.rules.ExpectedException$ExpectedExceptionStatement.evaluate(ExpectedException.java:239)
> at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:55)
> at org.junit.rules.RunRules.evaluate(RunRules.java:20)
> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:48)
> at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:48)
> at org.junit.rules.RunRules.evaluate(RunRules.java:20)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
> at
> com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
> at
> com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
> at
> com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
> at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
