You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@pig.apache.org by Mohit Anchlia <mo...@gmail.com> on 2012/04/12 01:20:50 UTC
ERROR 1025: Found more than one match:
Am I doing something wrong or is this just the limitation? Basically I
want to group 2 sets into one and locate them in the same row.
grunt> NM_CT_ST_FILTER = FILTER A by (FIELD_ID == 'NAM2' OR FIELD_ID ==
'CITY' OR FIELD_ID == 'ST' OR FIELD_ID == 'ZIP');
grunt> AG_OC_MT_FILTER = FILTER A by (FIELD_ID == 'AGE' OR FIELD_ID ==
'OCCUP' OR FIELD_ID == 'MARITAL') AND FORM_ID == 'FPERSWKS' AND
FORM_COPY_NUM == '1';
grunt> NM_CT_ST = JOIN NM_CT_ST_FILTER BY (FILE_NAME,CREATED_DATE), D BY
(FILE_NAME,CREATED_DATE);
grunt> AG_OC_MT = JOIN AG_OC_MT_FILTER BY
(FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT), D BY
(FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT);
grunt> FINAL = COGROUP NM_CT_ST BY (FILE_NAME,CREATED_DATE), AG_OC_MT BY
(FILE_NAME,CREATED_DATE);
2012-04-11 16:11:34,205 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 1025: Found more than one match: NM_CT_ST_FILTER::FILE_NAME,
D::FILE_NAME
Details at logfile: /home/hadoop/pigtest/pig_1334185845048.log
Re: ERROR 1025: Found more than one match:
Posted by Mohit Anchlia <mo...@gmail.com>.
On Thu, Apr 12, 2012 at 7:17 AM, Gianmarco De Francisci Morales <
gdfm@apache.org> wrote:
> Hi,
>
> you should be able to do what you want to do.
> It looks like a naming mismatch, but somehow the names are odd.
> Can you DESCRIBE the relations that you want to cogroup?
>
Thanks! I did describe and used name printed in the output and it worked.
>
> Cheers,
> --
> Gianmarco
>
>
>
> On Thu, Apr 12, 2012 at 01:20, Mohit Anchlia <mo...@gmail.com>
> wrote:
>
> > Am I doing something wrong or is this just the limitation? Basically I
> > want to group 2 sets into one and locate them in the same row.
> >
> >
> > grunt> NM_CT_ST_FILTER = FILTER A by (FIELD_ID == 'NAM2' OR FIELD_ID ==
> > 'CITY' OR FIELD_ID == 'ST' OR FIELD_ID == 'ZIP');
> >
> > grunt> AG_OC_MT_FILTER = FILTER A by (FIELD_ID == 'AGE' OR FIELD_ID ==
> > 'OCCUP' OR FIELD_ID == 'MARITAL') AND FORM_ID == 'FPERSWKS' AND
> > FORM_COPY_NUM == '1';
> >
> > grunt> NM_CT_ST = JOIN NM_CT_ST_FILTER BY (FILE_NAME,CREATED_DATE), D BY
> > (FILE_NAME,CREATED_DATE);
> >
> > grunt> AG_OC_MT = JOIN AG_OC_MT_FILTER BY
> > (FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT), D BY
> > (FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT);
> >
> > grunt> FINAL = COGROUP NM_CT_ST BY (FILE_NAME,CREATED_DATE), AG_OC_MT BY
> > (FILE_NAME,CREATED_DATE);
> >
> > 2012-04-11 16:11:34,205 [main] ERROR org.apache.pig.tools.grunt.Grunt -
> > ERROR 1025: Found more than one match: NM_CT_ST_FILTER::FILE_NAME,
> > D::FILE_NAME
> >
> > Details at logfile: /home/hadoop/pigtest/pig_1334185845048.log
> >
>
Re: ERROR 1025: Found more than one match:
Posted by Gianmarco De Francisci Morales <gd...@apache.org>.
Hi,
you should be able to do what you want to do.
It looks like a naming mismatch, but somehow the names are odd.
Can you DESCRIBE the relations that you want to cogroup?
Cheers,
--
Gianmarco
On Thu, Apr 12, 2012 at 01:20, Mohit Anchlia <mo...@gmail.com> wrote:
> Am I doing something wrong or is this just the limitation? Basically I
> want to group 2 sets into one and locate them in the same row.
>
>
> grunt> NM_CT_ST_FILTER = FILTER A by (FIELD_ID == 'NAM2' OR FIELD_ID ==
> 'CITY' OR FIELD_ID == 'ST' OR FIELD_ID == 'ZIP');
>
> grunt> AG_OC_MT_FILTER = FILTER A by (FIELD_ID == 'AGE' OR FIELD_ID ==
> 'OCCUP' OR FIELD_ID == 'MARITAL') AND FORM_ID == 'FPERSWKS' AND
> FORM_COPY_NUM == '1';
>
> grunt> NM_CT_ST = JOIN NM_CT_ST_FILTER BY (FILE_NAME,CREATED_DATE), D BY
> (FILE_NAME,CREATED_DATE);
>
> grunt> AG_OC_MT = JOIN AG_OC_MT_FILTER BY
> (FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT), D BY
> (FILE_NAME,CREATED_DATE,FORM_ID,FORM_ID_ROOT);
>
> grunt> FINAL = COGROUP NM_CT_ST BY (FILE_NAME,CREATED_DATE), AG_OC_MT BY
> (FILE_NAME,CREATED_DATE);
>
> 2012-04-11 16:11:34,205 [main] ERROR org.apache.pig.tools.grunt.Grunt -
> ERROR 1025: Found more than one match: NM_CT_ST_FILTER::FILE_NAME,
> D::FILE_NAME
>
> Details at logfile: /home/hadoop/pigtest/pig_1334185845048.log
>