KSQL

KSQL is not ANSI SQL compliant, for now there are no defined standards on streaming SQL languages

Consumers can set auto.offset.reset property to earliest to start consuming from beginning. For KSQL, SET 'auto.offset.reset'='earliest';

References

Flashcards

is KSQL ANSI SQL compliant?:: No

What Java library is KSQL based on?:: Kafka Streams

What is the default port that the KSQL server listens on?:: 8088

Where are KSQL-related data and metadata stored?:: Kafka Topics. metadata is stored in and built from the KSQL command topic. Each KSQL server has its own in-memory version of the metastore.