I have create a oozie wf which has hive script below . but the wf excuted sucessfully and the issue is . csv file is missing .
i dont see it in `Desktop/sv.csv’
insert overwrite local directory ‘Desktop/sv.csv’ select * from orders limit 10;
I can able to load into /user/vani.sethuraman (hadoop ie HDFS) not able to load into local directory
Please help me how to SFTP into csv using oozie workflow into local directory.