Hi everyone, I am using flink 1.18 table api sql u...
# troubleshooting
v
Hi everyone, I am using flink 1.18 table api sql using
Copy code
<dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-connector-jdbc</artifactId>
            <version>3.1.2-1.18</version>
        </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.7.3</version>
        </dependency>
one of my column is array type getting below error
Writing ARRAY type is not yet supported in JDBC:PostgreSQL.
anyone has faced this problem ? How you solved this. Thank you very much in advance
a
hi, any updates on this? facing the same issue
k
Can you share query or the method signature?
v
Hi keyur, Thank you replying. It is very simple
Copy code
CREATE TABLE IF NOT EXISTS raw_event (
    word ARRAY<STRING>
    
)
WITH (
    'connector'= 'jdbc',
    'url' = '${url}',
    'table-name' = 'raw_event',
    'username' = '',
    'password' = ''
)

INSERT INTO raw_event VALUES (ARRAY['hello', 'world']);
If you need any other data from my side please do ask πŸ˜ƒ