I read a bit about this topic out of interest, but never actually had a chance to try myself, so take my reply with a HUGE pinch of salt.
1. when I execute this in a single node, the threads are executed in different CPUs
The OS decides where the threads go, but this is the best approximation of the typical behaviour
2. when I execute this in a Hadoop cluster with several nodes, each thread is executed in a different node,
As I understand it, the only ways you could have multiple threads in Hadoop is if either:
1- proc ds2 sends several queries to the database (option sastrace = ',,,d' doesn't seem to monitor this connection), somehow telling it to only process a non-overlapping subset of the data in each query.
2- You have in-database licensed and installed
... View more