Hi all, I'm trying to create partitioned table with FlinkSQL.

CREATE TABLE t_test (
    `id` BIGINT,
    `ts` TIMESTAMP(3)
) PARTITIONED BY (ts);

I want to PARTITIONED BY DATE_FORMAT(

ts

, 'yyyyMMdd'). Is there any other way than defining physical columns?