title: Tables require a primary key when create a table with kafka topic
body: <p>I have a mysql table as this:
  <a href="https://i.stack.imgur.com/25hUT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/25hUT.png" alt="enter image description here" /></a>
  I use kafka connector to add this table to kafka topic:</p>
  <pre><code>ksql&gt; CREATE SOURCE CONNECTOR SOURCE_MYSQL_01 WITH (
      'connector.class' = 'io.debezium.connector.mysql.MySqlConnector',
      'database.hostname' = 'mysql',
      'database.port' = '3306',
      'database.user' = 'debezium',
      'database.password' = 'dbz',
      'database.server.id' = '42',
      'database.server.name' = 'asgard',
      'table.whitelist' = 'demo.customers',
      'database.history.kafka.bootstrap.servers' = 'kafka:29092',
      'database.history.kafka.topic' = 'dbhistory.demo' ,
      'include.schema.changes' = 'false',
      'transforms'= 'unwrap,extractkey',
      'transforms.unwrap.type'= 'io.debezium.transforms.ExtractNewRecordState',
      'transforms.extractkey.type'= 'org.apache.kafka.connect.transforms.ExtractField$Key',
      'transforms.extractkey.field'= 'id',
      'key.converter'= 'org.apache.kafka.connect.storage.StringConverter',
      'value.converter'= 'io.confluent.connect.avro.AvroConverter',
      'value.converter.schema.registry.url'= 'http://schema-registry:8081'
      );
  </code></pre>
  <p>and then I want to use this to create a table based on it:</p>
  <pre><code>CREATE TABLE  CUSTOMERS WITH (KAFKA_TOPIC='asgard.demo.CUSTOMERS', VALUE_FORMAT='AVRO');
  </code></pre>
  <p>then I get this error:</p>
  <pre><code>Tables require a PRIMARY KEY. Please define the PRIMARY KEY.
  Use a partial schema to define the primary key and still load the value columns from the Schema Registry, for example:
          CREATE TABLE CUSTOMERS (ID INT PRIMARY KEY) WITH (...);
  </code></pre>
  <p>when I change this as suggested:</p>
  <pre><code>CREATE TABLE CUSTOMERS (id int primary key) WITH (KAFKA_TOPIC='asgard.demo.CUSTOMERS', VALUE_FORMAT='AVRO');
  </code></pre>
  <p>I get this error:</p>
  <pre><code>Duplicate column names: `ID`
  </code></pre>
  <p>did some search but still stuck here. what's wrong with this and how can I resolve it? Thanks</p>