You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using kafka JDBC Source connector to fetch the JSON data from table (using a complex SQL query that generates the JSON data using JSON functions of Postgres DB) and using the JsonConverter to publish to kafka topic.
Since the result would have nested JSON, the data when published to kafka topic is having extra " and \ added by converter. Basically the JSON field is treated as String when converted into JSON.
Is there any support to handle nested JSON in connector?
The text was updated successfully, but these errors were encountered:
vinay-bh007
changed the title
JDBC SOURCE connector adding extra "s to json columns
JDBC SOURCE connector adding extra " and \s to json columns
Apr 18, 2024
I am using kafka JDBC Source connector to fetch the JSON data from table (using a complex SQL query that generates the JSON data using JSON functions of Postgres DB) and using the JsonConverter to publish to kafka topic.
Since the result would have nested JSON, the data when published to kafka topic is having extra " and \ added by converter. Basically the JSON field is treated as String when converted into JSON.
Is there any support to handle nested JSON in connector?
Expected output:
Output produced by connector:
Below is the connector properties:
Below is the connector properties:
The text was updated successfully, but these errors were encountered: