Pigscript now works. not sure why it's working now. I tried doing the steps all over again and this time it got excecuted.
So thank you much..
@Prakash Punj Did you copy the file locally instead hdfs as I mentioned in my reply?