mattcasters opened a new pull request, #8801:
URL: https://github.com/apache/hop/pull/8801
Several copies of Table Input can read one table in parallel when each copy
adds a modulo predicate on `${Internal.Transform.CopyNr}`. The Table Input page
now has a **Parallel reading** section for that setup.
The integer `MOD(table_id, ${NR_COPIES})` predicate is the same on Oracle,
MySQL, MariaDB, and PostgreSQL. For other keys the page shows Oracle
`ORA_HASH`, MySQL/MariaDB `CRC32` and an MD5 byte, and PostgreSQL an MD5 byte
and `hashtext`.
`ORA_HASH` returns a bucket from `0` through `max_bucket` inclusive
(Oracle's own 100-bucket example passes `99`). The documented call uses
`${NR_COPIES} - 1`, so four copies use buckets `0`..`3` and every row is read
by one copy.
fixes #8785
------------------------
Thank you for your contribution! Follow this checklist to help us
incorporate your contribution quickly and easily:
- [ ] Run `mvn clean install apache-rat:check` to make sure basic checks
pass. A more thorough check will be performed on your pull request
automatically.
- [x] If you have a group of commits related to the same change, please
squash your commits into one and force push your branch using `git rebase -i`.
- [x] Mention the appropriate issue in your description (for example:
`addresses #123`), if applicable.
To make clear that you license your contribution under the [Apache License
Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0)
you have to acknowledge this by using the following check-box.
- [x] I hereby declare this contribution to be licensed under the [Apache
License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0)
- [ ] In any other case, please file an [Apache Individual Contributor
License Agreement](https://www.apache.org/licenses/icla.pdf).
--
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]
