@repealp Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@felix_ Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.  ... View more

Hi @s198, You do not need to have hadoop file system or datanode role on the remote server. You just need to set up some hdfs gateway on the remote server and pull it using distcp. If you are using HDP or CDP, you can add the remote server as a gateway and perform distcp in the remote server. Another option is to share one of the directories in the remote server, mount it in hadoop cluster node, and perform distcp to that mounted directory. ... View more

Hi @drgenious  First, please test your script outside of Oozie. If it is working outside of Oozie, then it should work from Oozie as well. As for  error "No module named impala.dbapi" it could be that there is some version dependency issue with impyla and its related libraries refer ---> https://github.com/cloudera/impyla/issues/227   ... View more

Hi @MrBeasr  Please check the status of job via Oozie Database: # select count(*) from WF_JOBS where id like '%0043858-220322202819429-oozie-oozi-W%';   If require you may set the status of the job in Database itself: # update wf_jobs set status='FAILED' where id like '%0043858-220322202819429-oozie-oozi-W%';  ... View more

Hi @mohammad_shamim  You need to check DB logs and see if you are able to find any error. Else reach-out to your DB team, they should be best point of contact to help you with DB related problem  ... View more

HI @kerbero can you provide us the full error trace. It could be due to some dependency issue when using spark2.x ... View more

Hi @JoshiRamesh  In your query the Question Mark (?) symbol is this a value for deliveryconstructuid. Can you put it in double quotes and check if it works for you Example SELECT * FROM my_table WHERE array_contains(my_array_col, "value1")  This query will return all rows from “my_table” where “my_array_col” contains “value1” ... View more