Retrieves information about the brokers in a Kafka cluster. This function is intended mainly for internal use—it used by the streaming job scheduler to get the list of brokers in the Kafka cluster. You can call the function to determine which brokers Vertica knows about.


KafkaCheckBrokers(USING PARAMETERS brokers='hostname:port[,hostname2:port...]' 
                                   [, kafka_conf='option=value[;option2=value2...]']
                                   [, timeout=timeout_sec])
Parameter Description
brokers The host name and port number of a broker in the Kafka cluster used to retrieve the list of brokers. You can supply more than one broker as a comma-separated list. If the list includes brokers from more than one Kafka cluster, the cluster containing the last host in the list is queried.

A semicolon-delimited list of option=value pairs to pass directly to the rdkafka library. This is the library Vertica uses to communicate with Kafka. You can use this parameter to directly set configuration options that are not available through the Vertica integration with Kafka. See Directly Setting Kafka Library Options for details.


Integer number of seconds to wait for a response from the Kafka cluster.


=> SELECT KafkaCheckBrokers(USING PARAMETERS brokers='kafka01.example.com:9092') 
          OVER ();
 broker_id |        hostname     | port 
         2 | kafka03.example.com | 9092
         1 | kafka02.example.com | 9092
         3 | kafka04.example.com | 9092
         0 | kafka01.example.com | 9092
(4 rows)