SHOW TOPICS
Synopsis
| SHOW | LIST [ALL] TOPICS [EXTENDED];
|
Description
SHOW TOPICS lists the available topics in the Kafka cluster that ksqlDB is
configured to connect to (default setting for bootstrap.servers:
localhost:9092). SHOW TOPICS EXTENDED also displays consumer groups
and their active consumer counts.
SHOW TOPICS does not display hidden topics by default, such as:
* KSQL internal topics, like the KSQL command topic or changelog & repartition topics, or
topics that match any pattern in the ksql.hidden.topics configuration.
SHOW ALL TOPICS lists all topics, including hidden topics.
Example
| ksql> SHOW TOPICS;
Kafka Topic | Partitions | Replicas
---------------------------------------------------------------------------------------------------------------
default_ksql_processing_log | 1 | 1
pageviews | 1 | 1
users | 1 | 1
---------------------------------------------------------------------------------------------------------------
|
| ksql> SHOW ALL TOPICS;
Kafka Topic | Partitions | Replicas
--------------------------------------------------------------------------------------------------------------
_confluent-ksql-default__command_topic | 1 | 1
_confluent-ksql-default_query_CTAS_USERS_0-Aggregate-Aggregate-Materialize-changelog | 1 | 1
_confluent-ksql-default_query_CTAS_USERS_0-Aggregate-GroupBy-repartition | 1 | 1
default_ksql_processing_log | 1 | 1
pageviews | 1 | 1
users | 1 | 1
--------------------------------------------------------------------------------------------------------------
|
Last update:
2024-10-28