• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
  • Tim Holloway
  • Carey Brown
  • salvin francis

Kafka Streams In Action: difference between using KTable and KSQL?

Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was reading the table of content for the book and I just found a entire chapter talking about KTable, I never heard about it before, but sounds to me pretty similar to the KQSL tool that confluent provide. It was hard to found resources about the KTable to understand the difference, could you please help me to understand if there is any difference, or if both technologies work together and where I can found more resources about KTable.
Also a question about KTable, is if it will possible to create one from an existing topic and just query it later ?.  What about if I am just interesting in the metadata not the body of the message?

Thanks and congratulations for your book.
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mauricio,

KSQL is a way to use SQL to run continuous queries over Kafka.  Since KSQL uses Kafka Streams under the covers, when you create a KSQL "Table" you are using a KTable.  

As more resources, Chapter 5 is devoted solely to the KTable and for more information on KSQL you can look at https://docs.confluent.io/current/ksql/docs/index.html.

Yes, you can create a KTable to read from a source topic.

pie. tiny ad:
Enterprise-grade Excel API for Java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!