Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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:
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB