Re: Compound Keys Using Temporal Tables

Posted by Fabian Hueske-2 on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/Compound-Keys-Using-Temporal-Tables-tp29977p30007.html

Hi,

No, this is not possible at the moment. You can only pass a single expression as primary key.

A work around might be to put the two fields in a nested field (haven't tried if this works) or combine them in a single attribute, for example by casting them to VARCHAR and concating them.

Best, Fabian

Am Fr., 13. Sept. 2019 um 17:49 Uhr schrieb Yuval Itzchakov <[hidden email]>:

Hi,

Given table X with an event time, A, B and C columns, is there a way to pass a compound key, i.e. A and B as the primaryKey argument of Table.createTemporalFunction? My attempts so far yield a runtime exception where the String doesn't match a given regex.