title: Why doesn't a KSQL stream not return/show data from messages on topic in broker?
body: <p>I've got a simple Kafka broker running with a topic <code>raw_events</code>.</p>
  
  <p>With <code>kafka-console-producer --topic raw_events --broker-list kafka:29092 &lt; event.json</code> I'm adding events to that topic that successfully show up with <code>kafka-console-consumer --bootstrap-server kafka:29092 --topic raw_events</code>. So, I know the events land in the broker (in the right topic) and can be consumed from the broker**) as well.</p>
  
  <p>In this case, the <code>event.json</code> file contains a very simple JSON:</p>
  
  <p><code>{'event_type': 'issue',
      'project': 'sample',
      'user': {'name': 'John Doe', 'username': 'jdoe'}
  }
  </code></p>
  
  <p>In KSQL, the topic is there:</p>
  
  <pre><code>ksql&gt; show topics;
  
   Kafka Topic           | Registered | Partitions | Partition Replicas | Consumers | ConsumerGroups
  --------------------------------------------------------------------------------------------------
   raw_events            | true       | 1          | 1                  | 3         | 3
  </code></pre>
  
  <p>containing some events from earlier attempts:</p>
  
  <pre><code>ksql&gt; print 'raw_events';
  Format:STRING
  11/2/18 3:36:21 PM UTC , NULL , {'event_type': 'issue', 'project': 'sample', 'user': {'name': 'John Doe', 'username': 'jdoe'}}
  11/2/18 3:43:05 PM UTC , NULL , {'event_type': 'issue', 'project': 'sample', 'user': {'name': 'John Doe', 'username': 'jdoe'}}
  11/2/18 3:45:19 PM UTC , NULL , {'event_type': 'issue', 'project': 'sample', 'user': {'name': 'John Doe', 'username': 'jdoe'}}
  11/2/18 3:45:43 PM UTC , NULL , {'event_type': 'issue', 'project': 'sample', 'user': {'name': 'John Doe', 'username': 'jdoe'}}
  11/2/18 3:47:30 PM UTC , NULL , {'event_type': 'issue', 'project': 'sample', 'user': {'name': 'John Doe', 'username': 'jdoe'}}
  </code></pre>
  
  <p>(I'm following <a href="https://docs.confluent.io/current/ksql/docs/developer-guide/create-a-stream.html" rel="nofollow noreferrer">https://docs.confluent.io/current/ksql/docs/developer-guide/create-a-stream.html</a> but with my own data.)</p>
  
  <p>Now, I create a stream in KSQL which succeeds:</p>
  
  <pre><code>create stream new_events (event_type varchar, project varchar) with (kafka_topic='raw_events', value_format='JSON');
  </code></pre>
  
  <p>The stream is created:</p>
  
  <pre><code>ksql&gt; show streams;
  
   Stream Name     | Kafka Topic | Format
  ----------------------------------------
   NEW_EVENTS      | raw_events  | JSON
  ----------------------------------------
  </code></pre>
  
  <p>Nevertheless (and this is my question / problem -- it could be a PEBKAC or a KSQL error) a <code>SELECT</code> on that stream just halts and does not show any events... not even when I continue to add events to the topic:</p>
  
  <pre><code>ksql&gt; select * from new_events;
  [... nothing here ...]
  </code></pre>
  
  <p>Selecting a specific column like <code>project</code> does not return entries either.</p>
  
  <hr>
  
  <p>**) BTW, it is unclear to me why the produce CLI command has an argument <code>--broker-list</code> and the consume CLI command has <code>--bootstrap-server</code> for seemingly the same thing.</p>