Oozie wf to extract query output (hive) into csv format



Hi ,

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.