Load Spec Utility Options

The Load Spec utility enables you to provide parameters for the COPY statement that loads streaming data.

Option Description
--load-spec spec_name A unique name for this copy load spec.
--filters "filter_name" A Vertica FILTER chain containing all UDFilters for the COPY statement. For more information on filters, refer to Parsing Custom Formats.
--message-max-bytes max_message_size

Specifies the maximum size, in bytes, of a message.

Default Value:

1048576

--parser parser name

Identifies a VerticaUDParser to use with a specified target. If you are using a Vertica native parser, parser parameters serve as a COPY statement parameters.

Default Value:

KafkaParser

--parser-parameters key=value, key=value A list of parameters to provide to the parser.
--new-load-spec A new, unique name for an existing load spec. Requires the --update parameter
--uds-kv-parameters key=value, key=value A comma separated list of key value pairs for the user-defined source.
--load-method AUTO|TRICKLE |DIRECT

The COPY load method to use for all loads with this scheduler. See the COPY statement for more information.

Default Value:

TRICKLE

Examples

These examples show how you can use the Load Spec utility options.

Create the load spec, Streamspec1:

/opt/vertica/packages/kafka/bin/vkconfig load-spec --create --load-spec Streamspec1

Update the load spec, Streamspec1, to the name Streamspec2, and also update the load method to Direct:

/opt/vertica/packages/kafka/bin/vkconfig load-spec --update --load-spec Streamspec1 --new-load-spec Streamspec2  --load-method direct

Update the load spec, Filterspec, to use the KafkaInsertLengths filter and a custom decryption filter:

 /opt/vertica/packages/kafka/bin/vkconfig load-spec --update --load-spec Filterspec --filters "KafkaInsertLengths() DecryptFilter(parameter=Key)"