Hello all,
All big data application developer such situation once. I also faced the same problem and I found the solution for it. and I have written on "How to Integrate Sqoop in a Data Ingestion Layer with Hive, Oozie in a Big Data Application?" you can find it on Datafloq[dot]com.
Share to your friends who work on big data. Hope it will be helpful to you all!