Hi Timo, The problem with this is I would still have to determine the keys manually, which is not really feasible in my case. Is there any internal API that might be of use to extract this information?
On Wed, Feb 3, 2021 at 5:19 PM Timo Walther <twal...@apache.org> wrote: > Hi Yuval, > > we changed this behavior a bit to be more SQL compliant. Currently, > sinks must be explicitly defined with a PRIMARY KEY constraint. We had > discussions about implicit sinks, but nothing on the roadmap yet. The > `CREATE TEMPORARY TABLE LIKE` clause should make it easy to extend the > original table with just a primary key. > > Regards, > Timo > > > On 03.02.21 14:09, Yuval Itzchakov wrote: > > Hi, > > I'm reworking an existing UpsertStreamTableSink into the new > > DynamicTableSink API. In the previous API, one would get the unique keys > > for upsert queries via the `setKeyFields` method, which would calculate > > them based on the grouping keys during the translation phase. > > > > Searching around, I saw that JDBC > > ( > https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/jdbc.html#key-handling > > < > https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/jdbc.html#key-handling>) > > > relies on explicit key passing via the PRIMARY KEY constraint. However, > > this would require additional manual insertion which I am trying to > avoid. > > > > What would be the proper way to receive the unique keys for upsert > > queries with the new DynamicTableSink API? > > > > -- > > Best Regards, > > Yuval Itzchakov. > > -- Best Regards, Yuval Itzchakov.
