Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Vertica Load Settings

Vertica Load Settings

On the
Runtime Settings
tab >
Vertica Load Settings
view, you can configure data load settings for Vertica targets.
The following table describes the fields in this view:
Field
Description
Default
Loader to be used
Indicates the Vertica command to be used to load data to the Vertica target. Options are:
  • Client side
    . Fast Clone uses the LCOPY command to load data from the data files that are located on the target database server.
  • Server side
    . Fast Clone uses the COPY command to load data from the data files that are located on the system where you run the target load utility.
Client side
Binary length prefix (native)
Controls whether the data in Fast Clone data files is loaded into Vertica targets in NATIVE VARCHAR or text format.
If you select this option, Fast Clone adds the NATIVE VARCHAR keyword to the COPY or LCOPY command in the output SQL load script. The database server converts CHAR or VARCHAR fields in the data files to Vertica datatypes when loading data.
By default, this option is not selected and Fast Clone loads data in text format with delimiters.
Not selected
Binary length prefix endianness
The endianness of the data in the data files. Options are
LITTLE ENDIAN
and
BIG ENDIAN
.
This field is available only when the
Binary length prefix
option is selected.
LITTLE ENDIAN
Enable DataStream
Indicates whether to use DataStreamer to load data. Select this option to stream data directly to a Vertica target with the LCOPY command on the client side or the COPY command on the server side.
Not selected
Max errors
If you use DataStreamer, the maximum number of errors that can occur when streaming data to a Vertica target. If the number of errors exceeds this maximum, DataStreamer ends with an error.
100000
The Vertica COPY and LCOPY commands have a 65 KB limit on the length of NATIVE and NATIVE VARCHAR data. If Vertica encounters a value larger than 65 KB, it rejects the row, even if the ENFORCELENGTH option for the COPY or LCOPY command is disabled.

0 COMMENTS

We’d like to hear from you!