On Thu, Apr 12, 2012 at 7:17 AM, Gianmarco De Francisci Morales < [email protected]> 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 <[email protected]> > 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 > > >
