@Sushil Saxena
I'll make it easy for you, just copy this workflow from my github page it has everything you need to run on sandbox, on your own environment, copy hive-site.xml from your cluster to lib folder. To answer your question, you choose the packages depending on what you're using, if you're using hcatalog you need pig,hcatalog and hive, if you use sqoop, add sqoop, etc.
... View more
