2 Replies Latest reply on Feb 7, 2020 6:41 PM by Vikas Panwar

    kafkaconnect hadler renaming columns in target, fails with "Error in COLMAP clause"

    3913568

      source table name : TEST.TABLE1

      source column names, C1, C2, C3

      target topic name: TEST.TABLE1

      target column names: C1, C2, C3

      my prm file mapping:

      working prm file

      MAP TEST.TABLE1, TARGET TEST.TABLE1, COLMAP (USEDEFAULTS);

       

      The above works fine, but when I change the target column names, then replicat abbends with error 'Error in COLMAP clause'

       

      source table name : TEST.TABLE1

      source column names, C1, C2, C3

      target topic name: TEST.TABLE1

      target column names: Entry_ID, Submitter, Submit_Date

       

      non working prm file:

      MAP TEST.TABLE1, TARGET TEST.TABLE1, COLMAP (USEDEFAULTS, Entry_ID=C1,Submitter=C2,Submit_Date=C3);