Merge multiple partitions into a single split by using IN CLAUSE if the ...

...partitions have same host list