Skip to main content

Remotely mapping Vertica table to a kafka topic

  • May 4, 2016
  • 1 reply
  • 6 views
KarthikMurugan

I'd like to create a table dynamically and map it to a Kafka topic from my application. The documentation has this command,

 

/opt/vertica/packages/kafka/bin/vkconfig topic --add --target tableName --topic topicName --parser KafkaJSONParser --num-partitions 1 --config-schema kafkaschema

Is there an alternate way to run this command, as my application is hosted remotely and I'd like to do the mapping dynamically. I presume there should be a way to do this via SQL in Vertica.

    1 reply

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • May 8, 2016

    Hi

    There is no external API available ,  however , you can run the Kafka package in your remote server instead  of running it on the DB server .

    This will simplify you dynamic method ,you will be able to call the CLI from your code

     

    I hope you will find it useful

     

    Thanks

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement