Target Utility Options

Use the target utility to configure a Vertica table to receive data from your streaming data application.

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:--update option.

--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:--update option.

Important: Avoid having columns with NOT NULL restrictions in your target table. The scheduler stops loading data if it encounters a row that has a NULL value it needs to insert into a column with a NOT NULL restriction. If you must have a NOT NULL column, try to filter out all NULL 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 from public.streamtarget:

/opt/vertica/packages/kafka/bin/vkconfig target --create --target-schema public --target-table streamtarget