Target Tool Options
Use the target tool to configure a Vertica table to receive data from your streaming data application. It accepts the following arguments in addition to the Common vkconfig Script Options.
| Option | Description |
|---|---|
--target-schema schema.table_name |
The existing Vertica target schema associated with this target. |
--new-target-schema schema_name |
Changes the Vertica schema associated with this schema to a new, already created schema. Requires: |
--target-table table_name |
The name of a Vertica table corresponding to the target. |
--new-target-table schema_name |
Changes the Vertica target table associated with this schema to a new, already created table. Requires: |
Important: Avoid having columns with primary key restrictions in your target table. The scheduler stops loading data if it encounters a row that has a value which violates this restriction. If you must have a primary key restricted column, try to filter out any redundant values for that column in the streamed data before is it loaded by the scheduler.
Examples
This example shows how you can create a target for the scheduler defined in the myscheduler.conf configuration file from public.streamtarget table:
$ /opt/vertica/packages/kafka/bin/vkconfig target --create --target-table streamtarget --conf myscheduler.conf
