The Definitive Guide to Data Quality
SELECT * FROM USERS won't start a M/R job on the cluster side. So the data can be retrieved very quickly if you don't have a lot of data.
As soon as you define the columns you want to read in the query, a M/R job is started on the cluster side. This job could be longer. If it hangs forever, then you could find more information on the resource manager side browsing 192.168.25.86:8088.
Hello Jefferson Moreira,
Yes, there is abolutely no problem for a job to be executed remotely, from a machine which is not part of the cluster.
What error do you have when you execute from this machine?