Compound Keys Using Temporal Tables

[Yuval Itzchakov <yu...@gmail.com>]

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.

Re: Compound Keys Using Temporal Tables

[Fabian Hueske <fh...@gmail.com>]

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 <
yuvalos@gmail.com>:

> 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.
>