Chengyu Yan
Chengyu Yan
> > @bulolo how about set price type to `decimal(30, 8)` refer this > > > > https://github.com/apache/seatunnel/blob/79bb70101a5056de7cd44197ce6a613bf5ad3a01/docs/en/connector-v2/source/FakeSource.md?plain=1#L165 > ``` > source { > MongoDB-CDC { > hosts = "mongo0:27017"...
Because Seatunnel constructs deserializer based on the schema of the collection, records that do not conform to the schema cannot be parsed naturally.
> > > > please add e2e testcase https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/connector-jdbc-e2e > > > > > > > > > need all success？ > > > > hello @TyrantLucifer ,when i test...
> > > > > > > > please add e2e testcase https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/connector-jdbc-e2e > > > > > > > > > > > > > > > > >...
 It can fix `ansi_x3.4-1968` error.
Please provide the schema of oracle table and hive table.
It's better to provide the definition of the "zhanbi" field in the Oracle table. It seems like there might be an issue with the type conversion of the Oracle connector.
https://github.com/apache/seatunnel/blob/cd4b30bbc3a1de9a0eb90be029fcc8feba87dde9/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/oracle/OracleTypeMapper.java#L85-L95 Because the scale of the field `ZHANBI` is 2, the field type will set to `Decimal(38, 18)`. ```shell ❯ parq ./T_836191201227964417_6d287c425d_0_1_0.parquet -s 18:45:25 # Schema required group field_id=-1...
This issue has been solved at #5872. If you consider upgrading, you can also use the latest version `2.3.5`, so you don't need to use sql transform.