When connecting to Vertica databases using ODBC, Connect uses different load methods based on the Vertica version, as shown in the following overview table:
Vertica Version | Load Method |
---|---|
7 or later | Multi-stream Vertica COPY LOCAL via ODBC on both Windows and Linux |
6 or later |
Linux: Multi-stream Vertica COPY LOCAL via ODBC Windows: Multi-stream SQL INSERT via ODBC |
Earlier than 6 | Single-stream SQL INSERT via ODBC |