title: create table- specified columns and properties
body: <p>In KSQL I need to create a table based on a Kafka topic 'testtopic' that has messages like this:
  [
  {   &quot;name&quot;: &quot;bank meeting&quot;,
  &quot;type&quot;: &quot;request for loan&quot;,
  &quot;num_rep&quot;: 1
  }, {
  &quot;name&quot;: &quot;bank meeting&quot;,
  &quot;type&quot;: &quot;open bank account&quot;,
  &quot;num_rep&quot;: 1
  }, {
  &quot;name&quot;: &quot;bank meeting&quot;,
  &quot;type&quot;: &quot;order credit card&quot;,
  &quot;num_rep&quot;: 1
  }, {
  &quot;name&quot;: &quot;transaction&quot;,
  &quot;type&quot;: &quot;cash withdrawal&quot;,
  &quot;num_rep&quot;: 0
  }, {
  &quot;name&quot;: &quot;transaction&quot;,
  &quot;type&quot;: &quot;Receiving salary&quot;,
  &quot;num_rep&quot;: 1
  }
  ]
  what do I write in the brackets where I need to specify the topic's columns?
  As I see it, it's an array with JSON elements.</p>
  <p>CREATE table test (</p>
  <pre><code>????
      
  </code></pre>
  <p>) with ( kafka_topic='testtopic',value_format='???');</p>