Support data locality for Hive queries

[vegetableysm]

What is the problem:

Current hive modules can work on multi node pr-1624 but queries are distributed randomly across nodes.

The behaviour that you expect to work:

Use data locality to speed up hive queries.

Additional context

Add any other context about the problem here.