Data parsing fails

Data conversion fails.

When the data from the Kafka field is not compatible with the data type of the target supported database table column, the data conversion fails and a message is logged in the Kafka Connect log.

Example error message when parsing a string value for a numeric column:
java.lang.IllegalArgumentException: Could not parse 'jack'; accepted formats are: a valid
          number (e.g. '1234.56'), a valid Java numeric format (e.g. '-123.45e6'), a valid date-time
          pattern (e.g. '2018-10-17T18:37:52.704Z'), or a valid boolean word

Remediation

Ensure that the Kafka fields are mapped to the correct database columns. The connector can not automatically convert varying types. If they do not match, consider changing your table schema to accommodate the Kafka field types.
Tip: When adding or changing columns in a database table, ensure that the schema is fully propagated before continuing. Use nodetool describering to show the schema version.