corgy-w opened a new pull request, #11825:
URL: https://github.com/apache/seatunnel/pull/11825
### Purpose of this pull request
Add support for Oracle `INTERVAL` data types (`INTERVAL YEAR TO MONTH`,
`INTERVAL DAY TO SECOND`) in the JDBC Oracle connector, and add E2E test
coverage for both `BFILE` and `INTERVAL` columns.
This is a re-work of the previously closed PR #9389, rebased on the latest
`dev`:
- The `BFILE` type converter support was already merged into `dev` (via
#9383), so only the `INTERVAL` mapping is added here.
- Type names returned by the Oracle JDBC driver may include precision
qualifiers (e.g. `INTERVAL DAY(2) TO SECOND(6)`), so the type name is
normalized before matching.
### Does this PR introduce _any_ user-facing change?
Yes. Oracle `INTERVAL` columns are now read as `STRING` instead of failing
with `convertToSeaTunnelTypeError`. The Oracle source connector data type
mapping docs (en/zh) are updated accordingly.
### How was this patch tested?
- Extended `JdbcOracleIT` E2E test: `BFILE_COL` and `INTERVAL_COL` added to
source/sink tables, test data and the source-to-sink job config
(`jdbc_oracle_source_to_sink.conf`). `BFILE` columns are inserted as `NULL` (a
BFILE locator cannot be set via `setObject`), `INTERVAL` values are written via
`java.time.Duration`.
- Verified locally: `spotless:apply` clean, `./mvnw -DskipTests install -pl
seatunnel-connectors-v2/connector-jdbc,seatunnel-e2e/seatunnel-connector-v2-e2e/connector-jdbc-e2e/connector-jdbc-e2e-part-1
-am` builds successfully (the E2E test itself requires Docker, will run in CI).
### Check list
* [ ] If any new Jar binary package adding in your PR, please add License
Notice according
[New License
Guide](https://github.com/apache/seatunnel/blob/dev/docs/en/developer/new-license.md)
* [x] If necessary, please update the documentation to describe the new
feature. https://github.com/apache/seatunnel/tree/dev/docs
* [ ] If necessary, please update `incompatible-changes.md` to describe the
incompatibility caused by this PR.
* [ ] If you are contributing the connector code, please check that the
following files are updated:
1. Update
[plugin-mapping.properties](https://github.com/apache/seatunnel/blob/dev/plugin-mapping.properties)
and add new connector information in it
2. Update the pom file of
[seatunnel-dist](https://github.com/apache/seatunnel/blob/dev/seatunnel-dist/pom.xml)
3. Add ci label in
[label-scope-conf](https://github.com/apache/seatunnel/blob/dev/.github/workflows/labeler/label-scope-conf.yml)
4. Add e2e testcase in
[seatunnel-e2e](https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/)
5. Update connector
[plugin_config](https://github.com/apache/seatunnel/blob/dev/config/plugin_config)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
