PIG Error while loading file -bash syntax error near unexpected token

Question

I understand this is a syntax error but can not identify where the actual error is.

student = LOAD '/mnt/home/edureka_545667/Desktop/PIG/student.txt' USING PigStorage(',') as (Name:chararray, Id:int);

Comments

Can you share the contents of your file?

---

This is the content of the file

Answer 1

Since your data is delimited with tabs use the command as such shown below.

student = LOAD '/mnt/home/edureka_545667/Desktop/PIG/student.txt' USING PigStorage('\t') as (Name:chararray, Id:int);