just to test, if there is any connectivity issue, I changed the output table name and gave a table name which is not present in the DB. The moment I do this the job fails with the error. This means there is no connection issue . Also the join query which is generated in tELTHiveMap looks correct. I ran the query through command line and it runs absolutely fine. Can you please let me know what could be reason the job goes into running state. I have to personally click on "Kill" button to come out of it.