Target Tool Options
Use the target tool to configure a Vertica table to receive data from your streaming data application.
Syntax
vkconfig target {--create | --read | --update | --delete} [--target-table table --table_schema schema] [other_options...]
Option | Description |
---|---|
--create
|
Creates a new target. Cannot be used with |
--read |
Outputs the targets defined in the scheduler. This output is in JSON format. Cannot be used with By default this option outputs all of the targets defined in the configuration schema. You can limit the output to specific targets by using the You can use LIKE wildcards in these options. See LIKE-predicate for more information about using wildcards. |
--update
|
Updates an existing target. Cannot be used with |
--delete
|
Deletes a target. Cannot be used with |
--target-table table |
The name of a Vertica table receive data from the scheduler. This option is required for --create , --update , and --delete . |
--target-schema schema |
The existing Vertica schema containing the target table. This option is required for |
--dump |
When you use this option along with the |
--new-target-schema schema_name |
Changes the Vertica schema associated with this schema to a new, already created schema. Requires: |
--new-target-table schema_name |
Changes the Vertica target table associated with this schema to a new, already created table. Requires: |
--validation-type {ERROR|WARN|SKIP}
|
Controls validation performed on a created or updated target:
Renamed from |
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.
See Common vkconfig Script Options for options that are available in all of the vkconfig tools.
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
This example lists all of the targets in the scheduler defined in the weblogs.conf configuration file.
$ vkconfig target --read --conf weblog.conf {"target_schema":"public", "target_table":"web_hits"}