Multi table plugin does not support the Oracle Number type with precision=0
Description
When using the Multi table plugin to read data from the Oracle table having precision less column/field, it result into the following error when running the pipeline.
2022-11-09 10:33:07,257 - ERROR [SparkRunner-phase-1:i.c.p.MultiTableDBSource@103] - category_tags: Error getting table schemas from database.
java.sql.SQLException: io.cdap.cdap.api.data.schema.UnsupportedTypeException: Column 2 has unsupported SQL Type: 'NUMBER' with precision: '0'
Plugin version : 1.3.2
DDL:
CREATETABLE HR.RTEST (
ID VARCHAR2(100) NULL,
COST NUMBERNOTNULL,
NULLABLECOST NUMBERNULL,
CONSTRAINT SYS_C009208 CHECK ("COST" ISNOTNULL)
);
Release Notes
None
Activity
Show:
Rahul Sharma
created the IssueNovember 9, 2022 at 5:22 AM
Pinned fields
Click on the next to a field label to start pinning.
When using the Multi table plugin to read data from the Oracle table having precision less column/field, it result into the following error when running the pipeline.
2022-11-09 10:33:07,257 - ERROR [SparkRunner-phase-1:i.c.p.MultiTableDBSource@103] - category_tags: Error getting table schemas from database. java.sql.SQLException: io.cdap.cdap.api.data.schema.UnsupportedTypeException: Column 2 has unsupported SQL Type: 'NUMBER' with precision: '0'Plugin version : 1.3.2
DDL:
CREATE TABLE HR.RTEST (
ID VARCHAR2(100) NULL,
COST NUMBER NOT NULL,
NULLABLECOST NUMBER NULL,
CONSTRAINT SYS_C009208 CHECK ("COST" IS NOT NULL)
);