在jdbc连接器中使用增量摄取时出现问题

Question

我正在尝试使用递增摄取来生成一条消息，该消息指向mysql中更新表的主题。它使用时间戳工作，但似乎不能使用递增列模式工作。当我在表中插入新行时，我看不到任何发布到主题的消息。

{
            "_comment": " --- JDBC-specific configuration below here  --- ",
            "_comment": "JDBC connection URL. This will vary by RDBMS. Consult your manufacturer's handbook for more information",
            "connection.url": "jdbc:mysql://localhost:3306/lte?user=root&password=tiger",

            "_comment": "Which table(s) to include",
            "table.whitelist": "candidate_score",

            "_comment": "Pull all rows based on an timestamp column. You can also do bulk or incrementing column-based extracts. For more information, see http://docs.confluent.io/current/connect/connect-jdbc/docs/source_config_options.html#mode",
            "mode": "incrementing",

            "_comment": "Which column has the timestamp value to use?  ",
            "incrementing.column.name": "attempt_id",

            "_comment": "If the column is not defined as NOT NULL, tell the connector to ignore this  ",
            "validate.non.null": "true",

            "_comment": "The Kafka topic will be made up of this prefix, plus the table name  ",
            "topic.prefix": "mysql-"
    }

attempt_id是一个自动递增的非空列，它也是主键。

Answer 1

实际上，是我的错。我听错了话题。