Re: Lateral join not finding correlate variable

2020-11-21 Thread Dylan Forciea
Forciea Cc: "user@flink.apache.org" Subject: Re: Lateral join not finding correlate variable Hi Dylan, I have reproduced your issue based on your code, Currently Flink does not support such nested correlate pattern query. I have created a issue to track this [1]. Thanks for your rep

Re: Lateral join not finding correlate variable

2020-11-19 Thread godfrey he
gt; """) > > streamTableEnv.createTemporaryView("view2", q2) > > > > val q3 = streamTableEnv.sqlQuery(""" > > SELECT > > w.attr1, > > p.attr3 > > FROM view1 w > > LEFT JOIN LA

Re: Lateral join not finding correlate variable

2020-11-18 Thread Dylan Forciea
7;)) AS T(id) Where SplitStringToRows is defined as: @FunctionHint(output = new DataTypeHint("ROW")) class SplitStringToRows extends TableFunction[Row] { def eval(str: String, separator: String = ";"): Unit = { if (str != null) { str.split(separator).foreach(

Re: Lateral join not finding correlate variable

2020-11-18 Thread godfrey he
al table bit in that first table made the original query > plan work correctly. > > > > I greatly appreciate your assistance! > > > > Regards, > > Dylan Forciea > > > > *From: *godfrey he > *Date: *Wednesday, November 18, 2020 at 7:33 AM > *To:

Re: Lateral join not finding correlate variable

2020-11-18 Thread Dylan Forciea
From: godfrey he Date: Wednesday, November 18, 2020 at 7:33 AM To: Dylan Forciea Cc: "user@flink.apache.org" Subject: Re: Lateral join not finding correlate variable Hi Dylan, Could you provide which Flink version you find out the problem with? I test the above query on master, and I get

Re: Lateral join not finding correlate variable

2020-11-18 Thread godfrey he
Hi Dylan, Could you provide which Flink version you find out the problem with? I test the above query on master, and I get the plan, no errors occur. Here is my test case: @Test def testLateralJoin(): Unit = { util.addTableSource[(String, String, String, String, String)]("table1", 'id, 'attr1,