Re: Writing ARRAY type through JDBC:PostgreSQL

2021-05-21 Thread Timo Walther
Hi Federico, if ARRAY doesn't work, this is definitely a bug. Either in the documentation or in the implementation. I will loop in Jingsong Li who can help. In any case, feel free to open a JIRA ticket already. Regards, Timo On 30.04.21 14:44, fgahan wrote: Hi Timo, I´m attaching the

Re: Writing ARRAY type through JDBC:PostgreSQL

2021-04-30 Thread fgahan
Hi Timo, I´m attaching the stacktrace. I did try the array syntax with a few different options (string, varchar, character varying..) and they all end up with the same error. thanks... Federico flink_stacktrace.log

Writing ARRAY type through JDBC:PostgreSQL

2021-04-30 Thread fgahan
Hi, I´trying to write to a postgres table but the job fails on a column of type varchar[]. I get the following error: Caused by: java.lang.IllegalStateException: Writing ARRAY type is not yet supported in JDBC:PostgreSQL. After getting data from a kafka topic, my code looks like this:

Re: Writing ARRAY type through JDBC:PostgreSQL

2021-04-30 Thread Timo Walther
Hi Federico, could you also share the full stack trace with us? According to the docs, the ARRAY type should be supported: https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/connectors/jdbc.html#data-type-mapping Can you also try to use `cities ARRAY` in your CREATE TABLE,