hi, all
here's my pig script:
grunt> A = load '/tmp/test_file' using PigStorage(',') as (uid:long, payload:bytearray, ts:long, type:int);
grunt> B = foreach A generate COUNT(A);
2012-02-08 17:55:44,647 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: Pig script failed to parse:
<line 4, column 29> Invalid scalar projection: A : A column needs to be projected from a relation for it to be used as a scalar
Details at logfile: /tmp/pig_1328694479593.log

what does  ERROR 1200 mean?

How can I find all the meanings of error codes in Pig?

thanks.

Hi,

You will need to GROUP before you do a COUNT here.

grunt> A = load '/tmp/test_file' using PigStorage(',') as (uid:long,
payload:bytearray, ts:long, type:int);
grunt> B = GROUP A BY (uid),  //Or B = GROUP A ALL;
grunt> C = foreach B generate group, COUNT(A);

Thanks,
Prashant

On Wed, Feb 8, 2012 at 6:13 PM, Haitao Yao <[EMAIL PROTECTED]> wrote:

> hi, all
>        here's my pig script:
> grunt> A = load '/tmp/test_file' using PigStorage(',') as (uid:long,
> payload:bytearray, ts:long, type:int);
> grunt> B = foreach A generate COUNT(A);
> 2012-02-08 17:55:44,647 [main] ERROR org.apache.pig.tools.grunt.Grunt -
> ERROR 1200: Pig script failed to parse:
> <line 4, column 29> Invalid scalar projection: A : A column needs to be
> projected from a relation for it to be used as a scalar
> Details at logfile: /tmp/pig_1328694479593.log
>
> what does  ERROR 1200 mean?
>
> How can I find all the meanings of error codes in Pig?
>
> thanks.