JDBC Multitable Consumer error

@realmatcha 

You can see the above result if you preview your pipeline.

Just preview and see the result. :)

@realmatcha 

If you are having problem in after importing my pipeline then you just use the processors has been used in my pipeline in your env.

Please follow below steps and i hope it will help. Let me know in case of any issues.

step1 : 

Origin as Dev Raw data source and inputs are 

{
  "call-comme_id": "abc"
  
}
{
  "call_comme_id": "xyz"
  
}
{
  "call-comme-id": "ABC"
  
}

Step2 : Use the filed mapper processor to rename the fields.

Your pipeline should look like below .

@realmatcha 

we need quote for the fields but you need to filter out the fields for which you are trying to rename if the field name exists in your record else no need to anything.

I will provide you the work around for your case . You just try that and i hope it will help.

here`s each one of the processor details

i have replaced it but still error

Remove the quotes for source and target both.

@realmatcha 

You can add filter like below based on the field and it will resolve your issues.

I've tried but it's still an error, you can see what each processor contains

but it gives syntax error. can you please provide and example how to do proper "Field Rename"

com.streamsets.pipeline.stage.lib.hive.exceptions.HiveStageCheckedException: HIVE_30 - Invalid column name call-outcomme_id