By convention, the pig script that you are using should be placed in the local file system and not in the hdfs path. By default, the system searches for the pig script in the local path.
So, try to execute the script file from the local and not from hdfs.
Also,If you still want to run the script from hdfs, you need to give the absolute path to script in hdfs