Oracle Sink plugin fails to insert String fields into Number Column
Description
Release Notes
In the Oracle batch source, the Oracle NUMBER data type defined without precision and scale by default was mapped to CDAP string data type. If these fields were used by an Oracle Sink to insert into a NUMBER data type field in the Oracle table, the pipeline failed due to incompatibility between string and NUMBER type. Now, the Oracle Sink inserts these string types into NUMBER fields in the Oracle table.
Activity
Show:
Unresolved
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee
Rahul Sharma
Rahul SharmaReporter
Rahul Sharma
Rahul SharmaLabels
Components
Fix versions
Priority
MajorMore fields
Original estimate
More fields
Original estimateCreated January 24, 2023 at 6:20 AM
Updated April 11, 2023 at 4:39 AM
Precision less numbers are converted into string types in the Oracle Source plugin. In the Oracle Sink plugin these string types created from Number types fails to get inserted in the column which is Number type.