How to insert the JSON Data Type column in the JDBC producer

13 views
Skip to first unread message

Abhishek Khandelwal

unread,
Apr 16, 2021, 6:20:33 PM4/16/21
to sdc-user
My requirement is to read from one Teradata table and load into another Teradata table.
Both the table has 1 column with JSON Data type having JSONs.
While reading from JDBC consumer, I am doing cast  to clob so as to read JSON column and I am able to read it but while inserting through JDBC producer, i am getting error "batch as empty" SQL error .

Need help to resolve and load into table
Reply all
Reply to author
Forward
0 new messages