Page 1 of 1
warining in JoinStage
Posted: Mon Nov 27, 2006 1:34 am
by boppanakrishna
hi all,
i am using a join stage and i am getting the warining as
"Join_124: When checking operator: Dropping component "MISCORR" because of a prior component with the same name."
--> MISSCORR is output column name ...
Re: warining in JoinStage
Posted: Mon Nov 27, 2006 2:31 am
by balajisr
boppanakrishna wrote:hi all,
i am using a join stage and i am getting the warining as
"Join_124: When checking operator: Dropping component "MISCORR" because of a prior component with the same name."
--> MISSCORR is output column name ...
This warning occurs when you have columns with the same name in both the left and right datasets. Rename the column "MISCORR" in the right dataset.
Re: warining in JoinStage
Posted: Mon Nov 27, 2006 2:50 am
by alphac
It seems both input and output links have column "MISCORR". If this column is not a join key, the stage only carry the left link's "MISCORR" field and will drop the right link's.
Suggest you to remove input link's unnecessary columns to avoid this kind of warning messages. You may earn performance gain if your data volume is significant.
Posted: Mon Nov 27, 2006 3:18 am
by Nageshsunkoji
Hi,
Possible solution for this is to change the column name of any one link i.e either in left or right . You can perform this operation by using copy stage or in any stage before your join link.
One more solution for this is Disable RCP at the job level. It will not throw any warning.
One more better solution is to search in this forum. You will get more posts for the same question.
Posted: Mon Nov 27, 2006 3:44 am
by boppanakrishna
Nageshsunkoji wrote:Hi,
Possible solution for this is to change the column name of any one link i.e either in left or right . You can perform this operation by using copy stage or in any stage before your join link.
One more solution for this is Disable RCP at the job level. It will not throw any warning.
One more better solution is to search in this forum. You will get more posts for the same question.
hi
Thnks for your suggestion, i have already changed the column names in the join stage ...but still it is not working ..
Posted: Mon Nov 27, 2006 4:02 am
by Nageshsunkoji
Hi,
Are you tried by switching off the RCP ? Try with this option.
One more solution is use modify stage to drop a column, which is not required for further processing.
Posted: Mon Nov 27, 2006 10:29 am
by thebird
Change the column name in one of the links to the Join Stage and also switch off RCP on both the links to the Join Stage. This should take care of your warning.
The Bird.
Posted: Fri Dec 01, 2006 4:53 am
by thumati.praveen
thebird wrote:Change the column name in one of the links to the Join Stage and also switch off RCP on both the links to the Join Stage. This should take care of your warning.
The Bird.
thanks for ur input
if switch off the RPC,in output data set i did not get the data in ralated columns in the join stage columns.