The database is the field where oracle partition_cloumn (id) is NUMBER; Size, scale 0, restapi submit-job error

[sandyustc]

The database is the field where oracle partition_cloumn (id) is NUMBER; Size, scale 0, restapi submit-job error

[hawk9821]

What is the id field type for table1 ? is number(18,0) ?

[sandyustc]

What is the id field type for table1 ? is number(18,0) ?
@hawk9821 thanks
The ID field of the table is of type number(0,0)

[hawk9821]

Problems with oracle data type conversion ， A conversion logic error caused the oracle number type to be converted to Decimal(38,18). The expectation should be Long

[sandyustc]

Problems with oracle data type conversion ， A conversion logic error caused the oracle number type to be converted to Decimal(38,18). The expectation should be Long
@hawk9821 thanks

Oracle table field ID number type size and precision set to 0, should not be converted to decimal(38,18), why is it converted to this, what special requirements, if this is limited, that the column name for split data ,it can not be processed("partition_column": "id")

[hawk9821]

The oracle number data type can store float data without specifying the precision, so seatunnel is treated as float and converted to Decimal(38,18). Change table field ID data type to number(x,0)

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.