title: How should I connect clickhouse to Kafka?
body: <pre><code>CREATE TABLE readings_queue
  (
  
      `readid` Int32,
  
      `time` DateTime,
  
      `temperature` Decimal(5,2)
  )
  ENGINE = Kafka
  SETTINGS kafka_broker_list = 'serverIP:9092',
   kafka_topic_list = 'newtest',
   kafka_format = 'CSV',
   kafka_group_name = 'clickhouse_consumer_group',
   kafka_num_consumers = 3
  </code></pre>
  <p>Above is the code that I build up connection of Kafka and Clickhouse. But after I execute the code, only the table is created, no data is retrieved.</p>
  <pre><code>~/kafka/bin/kafka-console-consumer.sh --bootstrap-server localhost:9092 --topic newtest --from-beginning
  1,&quot;2020-05-16 23:55:44&quot;,14.2
  2,&quot;2020-05-16 23:55:45&quot;,20.1
  3,&quot;2020-05-16 23:55:51&quot;,12.9
  </code></pre>
  <p>Is there something wrong with my query in clickhouse?</p>
  <p>When I checked the log, I found below warning.</p>
  <pre><code>2021.05.10 10:19:50.534441 [ 1534 ] {} &lt;Warning&gt; (readings_queue): Can't get assignment. It can be caused by some issue with consumer group (not enough partitions?). Will keep trying.
  </code></pre>