Process to extract a value from BLOB to a column is slow
The process to extract a value from BLOB to a column is slow. The table count is 4.7 million and the process does not even run 1000 rows/hr.
Steps to Reproduce
Run the shell script.
The amount of data extracted is around 4.7 million records and the process is running on a single thread.
ResolutionPerform the following local-change:
- Navigate to prpcUtils.properties
- Set the 'expose.numOfThreads' property value to a higher value in case of updating large sets of data
0% found this useful