why No new messages seen in ksql even messages exist?

Asked Apr 02 '20 at 06:17

Active May 13 '20 at 16:30

Viewed 216 times

I create table in ksql like this:

CREATE TABLE ORDERS_T (id BIGINT, product VARCHAR, quantity BIGINT, price BIGINT)
  WITH (KAFKA_TOPIC='orders', VALUE_FORMAT='JSON');

In kafka I ve "orders" topic

And when I select query tab in ksql even total messages exists , panel says No new messages like below

So how can I solve this? I want to see results like this example in confluent.io

AND if I do not use EMIT CHANGES it gives this error:

Table 'MYTABLE' is not materialized. Refer to https://cnfl.io/queries for info on query types. If you..

thanks in advance

edited May 13 '20 at 16:30

Matthias J. Sax

asked Apr 02 '20 at 06:17

CompEng

Are there any errors in the KSQL server log? Does the query work if you run it from the KSQL command line interface? – Robin Moffatt Apr 02 '20 at 06:59
See also https://www.confluent.io/blog/troubleshooting-ksql-part-1/ – Robin Moffatt Apr 02 '20 at 06:59
I did not check commandline and logs , how can Ifind logs? – CompEng Apr 02 '20 at 07:00
How are you running Confluent Platform? Are you using Docker? Or just bare metal? – Robin Moffatt Apr 02 '20 at 07:00
I run it on ubuntu and not docker – CompEng Apr 02 '20 at 07:02
did you install from tar/zip or from `.deb` ? – Robin Moffatt Apr 02 '20 at 07:07
i instal it from tar/zip – CompEng Apr 02 '20 at 07:16
@RobinMoffatt ı TRied it from ksql command line but it does not worj – CompEng Apr 02 '20 at 09:16
have a look at http://confluent.io/blog/troubleshooting-ksql-part-1. If you're still stuck head to http://cnfl.io/slack and #ksqldb channel - this back & forth isn't so suited to StackOverflow – Robin Moffatt Apr 02 '20 at 10:01
The most likely cause is deserialization errors. Look in the processing_log (Select * from processing_log), the server logs, or you can also look at the error count in the output of DESCRIBE EXTENDED ORDERS_T. We may be able to help more if you provide an example source message. – Andrew Coates Nov 27 '20 at 15:01

0 Answers0