Hello, I am testing with flink .1.20.2 and mongodb...
# troubleshooting
f
Hello, I am testing with flink .1.20.2 and mongodb cdc connector with the next configuration:
Copy code
SET 'sql-client.execution.result-mode' = 'tableau';

CREATE TABLE mongo_users (
    db_name         STRING METADATA FROM 'database_name' VIRTUAL,
    collection_name STRING METADATA  FROM 'collection_name' VIRTUAL,
    operation_ts    TIMESTAMP_LTZ(3) METADATA FROM 'op_ts' VIRTUAL,
    row_kind       STRING METADATA FROM 'row_kind' VIRTUAL,
    _id             STRING,
    name         STRING,
    PRIMARY KEY(_id) NOT ENFORCED
) WITH (
    'connector' = 'mongodb-cdc',
    'hosts' = 'localhost:27017',
    'connection.options' = 'directConnection=true&tls=false',
    'username' = 'admin',
    'password' = 'admin',
    'database' = 'cdc-test',
    'collection' = 'users'
);
SELECT * FROM mongo_users;
But I am not sure if the row_kind is returned correctly, because when the document is deleted the row_kind says +U (the previous row_kind), it should not be -D? like the op column added in sql client?
Hello, anyone can help me with this doubt.