dataproc-templates icon indicating copy to clipboard operation
dataproc-templates copied to clipboard

Published 20 hours ago • verified publisher icon GoogleCloudPlatform

Prevent Oracle Parallel Query Via NO_PARALLEL Hint

Open nj1973 opened this issue 1 year ago • 0 comments

As we control parallelism via numPartitions we do not want Oracle to then run Spark queries in parallel. It would be really easy to overload a source system if this happens.

We should be able to embed an Oracle hint to prevent this.

/*+ NO_PARALLEL */

This applies to both Python and Java templates.

nj1973 avatar May 26 '23 08:05 nj1973