How to run any Transformation Logic on HDFS data which is at Remote PC
I would suggest setting up a Spark Cluster in the same local network where you have the data and running spark transformations in the cluster remotely (SSH or Remote Desktop). The advantages of the setup are:

Network Latency will be minimised as the data is transferred in the
same network locally.
Running the transformations with distributed and in-memory processing engines like Apache Spark is fast.

Note: Please ignore if the response is in line with your second approach
I have huge size data (in TBs or PBs) in my HDFS which is located at remote PC. Now instead of taking Data to the Transformation Logic (which is not correct and efficient), I want to run my python Transformation Logic itself on the location where my Data is stored.
Seeking some useful ideas about the technologies which can be used to fulfill this requirement.
Things which I tried till now:
1) Approach 1

Took SSH Connection of Remote PC (where HDFS data is available), Copied my python Transformation Logic there and executed after fetching the data from HDFS.

2) Approach 2

Loaded HDFS data to Apache Spark RDDs which is on Remote PC where HDFS data is available and executed Spark Job from another PC.

Please suggest other technologies which can be used for Logic Execution remotely.