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)"