I am using HDP 2.6 and not able to find the path for Piggybank. Could you please let me know whether this HDP have the piggybank , if yes then where i can find it.
Script should not be moved to HDFS. Run it from the command line on the edge node. If the edge node has been set up properly pig will be in the classpath and you can run it from anywhere (with absolute path to piggybank location) and most convenient to run it from script location.
See this for running pig: http://pig.apache.org/docs/r0.16.0/start.html#run