Is there a way to return the number of messages sent to Kafka using KafkaExport?
You should be able to use KAFKACAT to list the messages sent to Kafka from Vertica.
./kafkacat -C -t <Topic> -b <Broker>
The number of messages produced to Kafka should match the number of rows returned by the query used in KafkaExport MINUS any error reported by KafkaExport.
Then,, Is it impossible return the number of message sent to Kafka topic immediately after KafkaExport query executing?
You could determine the number of rows from your select statement (select count(*)....) immediately before or after calling KafkaExport