Re: [DISCUSS] Simplify SQL lookup join (temporal join with latest) syntax

2021-04-20 Thread Gyula Fóra
Thanks for the pointer Jingsong, I don't see how proctime() is ambiguous though as it always refers to the current wall clock time. I think thats much better than adding a magic pseudocolumn. Cheers Gyula On Tue, Apr 20, 2021 at 11:06 AM Jingsong Li wrote: > +1 for simplifying. > > We already

Re: [DISCUSS] Simplify SQL lookup join (temporal join with latest) syntax

2021-04-20 Thread Jingsong Li
+1 for simplifying. We already have a thread of this topic: http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/DISCUSS-Make-Temporal-Join-syntax-easier-to-use-td47296.html FYI. Best, Jingsong On Tue, Apr 20, 2021 at 4:55 PM Gyula Fóra wrote: > Hi All! > > Playing around with the

[DISCUSS] Simplify SQL lookup join (temporal join with latest) syntax

2021-04-20 Thread Gyula Fóra
Hi All! Playing around with the SQL syntax for temporal join with latest table I feel there is some room for optimizing the current syntax to provide a better user experience. The current system for specifying the lookup side is: lookuptable FOR SYSTEM_TIME AS OF probe.proctime_column It feels