Execute Pig Script from Grunt Shell

Question

If i want to execute pig script from grunt shell what all do I need to have ?I have copied the
.pig file and source file into the hdfs. what else do i need to copy. Can you please share
the execution command or statement along with step by step process how to execute the
pig script in grunt shell?

Answer 1

You can use exec or run command to execute the pig script using the grunt shell. In case of run command, all the commands present in script file will be available in the grunt history, which is not the case with exec command.

First you need to go ahead and load the data file in PigStorage. 

product = LOAD 'hdfs://localhost:9000/product_dir/products.csv' USING PigStorage(',') as (product_id:int, product_name:chararray, price:int);

dump product;

Next you can go ahead and execute the script file, which is stored in HDFS.

exec hdfs://localhost:9000/script_dir/pig_script.pig

or

run hdfs://localhost:9000/script_dir/pig_script.pig

Answer 2

From your current directory run 

pig -x local

Then grunt shell is invoked. Now, you can directly type your command here to execute it

Comments

Hi.. I tried this but i get not recognized error. Help me please

---

Make sure you have set the path to the pig.jar file. something like this:

export PIG_CLASSPATH=./pig.jar

---

Thanks. Now it works