Skip to main content
Question

Is there a way to tell Kafka scheduler to use tablename(_raw_) option?

  • August 13, 2020
  • 1 reply
  • 5 views

mosheg
Forum|alt.badge.img+2
  • Participating Frequently

Is there a way to tell Kafka scheduler to use tablename(raw) option ?
One of our colleagues need that to load in hybrid table

1 reply

mosheg
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • August 13, 2020

Serge Bonte answered:
You will need to add –a comma delimited list of target columns
--target-columns raw
When creating or updating your microbatch via vkconfig
e.g.
/opt/vertica/packages/kafka/bin/vkconfig microbatch --conf inspections.props --create --microbatch mb_1 --target-schema public --target-table vinspections_json --load-spec spec_1 --add-source inspections_json --add-source-cluster kafka_cluster_1 --target-columns raw
Thank you very much Serge :blush: