what is best practice to handle the concurrency issue in batch processing?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2023 09:54 AM
Normally, our ELT framework takes in batches one by one and loads the data into target tables. But if more than one batches come in at the same time, the framework will break due to the concurrency issue that multiple sources are trying to write the same tables at the same time.
what is the best way or standard procedure to solve this concurrency issue? Thanks!
Labels:
- Labels:
-
Batch Processing
-
Multiple Sources
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2023 02:25 PM
you can partition you table to avoid the changes of getting this exception.