Hadoop ERROR1070 Could not resolve count using imports java lang org apache pig builtin org apache pig impl builtin

Question

While executing PIG statement from GRUNT: 

grunt> cnt = foreach grpd generate group, count(words) as nos; 

Failed to generate logical plan. Nested exception: org.apache.pig.backend.executionengine.ExecException. Its giving me the above error. Can anyone tell how to resolve this?

Answer 1

Hi,

I can see the error arose because the count in pig statement should be upper case COUNT. You can change the statement with the below:

grunt> cnt = foreach grpd generate group, COUNT(words) as nos;

Hope it will remove your error.