Hi, I have created a flink table using jdbc mysql ...
# troubleshooting
a
Hi, I have created a flink table using jdbc mysql conector. Then I gave a select query on that table, it gives only the existing records, when a new row is added or updated in mysql it is not getting reflected in select results, I am new to flink and trying to understand how to get the realtime result in flink select query. Following is the create table command that I have used:
Copy code
CREATE TABLE users_mysql (
    account_id BIGINT,
    id BIGINT,
    name STRING
) WITH (
    'connector' = 'jdbc',
    'url' = 'jdbc:<mysql://mysql:3306/freshservice>',
    'table-name' = 'tdetails',
    'username' = 'root',
    'password' = 'root',
    'lookup.cache.max-rows' = '5000',
    'lookup.cache.ttl' = '10min'
);