concept KSQL table in category kafka

appears as: KSQL table
Kafka Streams in Action: Real-time apps and microservices with the Kafka Streams API

This is an excerpt from Manning's book Kafka Streams in Action: Real-time apps and microservices with the Kafka Streams API.

9.3.6. Creating a KSQL table

So far, we’ve demonstrated creating a KSQL stream. Now, let’s see how to create a KSQL table, using the stock-transactions topic as the source, for familiarity (found in src/main/resources/ksql/create_table.txt).

Listing 9.13. Creating a KSQL table
CREATE TABLE stock_txn_table (symbol VARCHAR, sector VARCHAR, \
                              industry VARCHAR, shares BIGINT, \
                              sharePrice DOUBLE, \
                              customerId VARCHAR, transactionTimestamp \
                              STRING, purchase BOOLEAN) \
                              WITH (KEY='symbol', VALUE_FORMAT = 'JSON', \
                              KAFKA_TOPIC = 'stock-transactions');