title: Kafka Connect - Cannot ALTER to add missing field SinkRecordField{schema=Schema{BYTES}, name='CreateUID', isPrimaryKey=true},
body: <p>I am using JDBC source connector to read data from a Teradata table and push to Kafka topic . But when I am trying to use JDBC sink connector to read Kafka topic and push to Oracle table it throws  the below ERROR. 
  I am sure the error is because of the parameters <code>pk.mode</code> and <code>pk.fields</code> which I am not sure what to use.</p>
  
  <p>My terradata has a primary key UserID+ DatabaseID . I have created the table in Oracle with the primay key as Userid+databaseID. </p>
  
  <pre><code>** ERROR Cannot ALTER to add missing field SinkRecordField{schema=Schema{BYTES}, 
  name='CreateUID', isPrimaryKey=true}, as it is not 
  optional and does not have a default value** 
  </code></pre>
  
  <p>Below is my sink connector- </p>
  
  <pre><code>{name=teradata_sink
  connector.class=io.confluent.connect.jdbc.JdbcSinkConnector
  tasks.max=1
  topics=TERADATA_ACCESSRIGHTS
  connection.url=
  connection.user=
  connection.password=
  auto.create=false
  table.name.format=TERADATA_ACCESSRIGHTS
  pk.mode=record_value
  pk.fields=USERID+DATABASEID
  auto.evolve=true
  insert.mode=upsert
  }
  </code></pre>
  
  <p>Please suggest how can I use the JDBC sink connector with the given primary keys.</p>