question Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070. in Archives of Support Questions (Read Only)

Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

srinivasandwara — Thu, 08 Sep 2016 03:32:31 GMT

Hi,

I get the following error when I try to run the Lab 3 - Pig tutorial

2016-09-07 20:06:51,165 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1070: Could not resolve sum using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

Hi, the details of the error are:

2016-09-07 20:06:51,165 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1070: Could not resolve sum using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

Re: Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

gkeys — Thu, 08 Sep 2016 07:09:38 GMT

@D Srini

You have provided the error but not the code itself. Based on the error, it looks like your code did not use SUM in caps.

SUM is a built in function of pig. It is a java static method called SUM in the package org.apache.pig.builtin which is packaged in the pig jars. Bottom line is that this function is case sensitive.

I think instead of writing

e =foreach d generate groupas driverid, SUM(c.occurance)as t_occ;

you wrote

e =foreach d generate groupas driverid, sum(c.occurance)as t_occ;

See https://pig.apache.org/docs/r0.16.0/func.html#built-in-functions to learn more about pig functions, both builtin functions (where you do not need to register them in your code because pig dynamically finds the function in the pig jars) and user-defined functions (where you create the jar and register it in the pig code).

If this was indeed the problem, let me know by accepting the answer.

Re: Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

srinivasandwara — Fri, 09 Sep 2016 01:04:16 GMT

That was it. Thanks.

Re: Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

gkeys — Fri, 09 Sep 2016 01:10:41 GMT

Glad I could help 🙂

Re: Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

harshavar666 — Wed, 15 Nov 2023 04:42:03 GMT

I am getting the same error when I use this

correlation_coefficient = FOREACH (GROUP correlation_data ALL) GENERATE PiggyBank.COR(correlation_data.age, correlation_data.avg_glucose_level) AS correlation;

Error:
2023-11-15 10:02:09,087 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1070: Could not resolve PiggyBank.COR using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

could you please help me out

Re: Error 1070 when running Lab 3 - Pig Tutorial Script,While running Lab 3 I - Pig Risk Analysis - I get an error 1070.

VidyaSargur — Wed, 15 Nov 2023 08:15:10 GMT

@harshavar666, Welcome to the Cloudera Community. As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.