CODEWITHSUNDEEP
hadoopapache-pighortonworks-sandbox
Bilal Ahmed
Bilal Ahmed

Reputation: 4066

pig FILTER ERROR 1000: Error during parsing. Encountered

This script working fine

data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
DUMP data1;

and the output is enter image description here

When i used FILTER then PIG through error

data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
filterRowData1=filter data1 by (int)movieID == 556;
DUMP filterRowData1;

Error screen-shot enter image description here Error Detail:

2018-10-20 23:20:24,653 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1000: Error during parsing. Encountered " "filterRowData1=filter "" at line 2, column 1.

I have also tried

data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
filterRowData1=filter data1 by movieID == 556; (i have tried: '556'; but no luck)
DUMP filterRowData1;

Upvotes: 0

Views: 615

Answers (1)

Santanu Maji
Santanu Maji

Reputation: 26

filterRowData1 = filter data1 by movieID == 556;

you should space between alias name and query.

Upvotes: 1

Related Questions