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.