stream_load_specs

This table describes user-created load specs.

Column Data Type Description
id INT The identification number assigned to the cluster.
load_spec VARCHAR The name of the load spec.
filters VARCHAR A comma-separated list of hosts associated with the cluster.
parser VARCHAR A VerticaUDParser to use with a specified target. If you are using a Vertica native parser, parser parameters serve as a COPY statement parameters.
parser_parameters VARCHAR A list of parameters to provide to the parser.

load_method

VARCHAR The COPY load method to use for all loads with this scheduler. See the COPY statement for more information.
message_max_bytes INT The maximum size, in bytes, of a message.
uds_kv_parameters VARCHAR A list of parameters provided to the copy statement.

Examples

This example shows the load specs that you can use with a Vertica instance.

SELECT * FROM stream_config.stream_load_specs;				
-[ RECORD 1 ]-----+------------
id                | 1
load_spec         | loadspec2
filters           |
parser            | KafkaParser
parser_parameters |
load_method       | direct
message_max_bytes | 1048576
uds_kv_parameters |
-[ RECORD 2 ]-----+------------
id                | 750001
load_spec         | streamspec1
filters           |
parser            | KafkaParser
parser_parameters |
load_method       | TRICKLE
message_max_bytes | 1048576
uds_kv_parameters |