Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig, mail # user - ERROR 1025: Found more than one match:


Copy link to this message
-
ERROR 1025: Found more than one match:
Mohit Anchlia 2012-04-11, 23:20
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