How to load data into Vertica from C

Try to export the data into csv format, and recreate the table in Vertica using the DDL from Oracle. Check the types as they differ from Oracle to Vertica.

Example: assuming the following table structure on Oracle:

CREATE TABLE PEOPLE
(
    ID NUMBER (10),
    NAME VARCHAR2 (50),
    ADDRESS VARCHAR2 (250),
    PRIMARY KEY (ID)
)

Assuming a compatible table structure on Vertica:

CREATE TABLE PEOPLE
(
    ID BIGINT NOT NULL    /*ORACLE datatype: NUMBER(10, 0)  */,
    NAME VARCHAR(50)      /*ORACLE datatype: VARCHAR2(50)   */,
    ADDRESS VARCHAR(250)  /*ORACLE datatype: VARCHAR2(250)  */,
    PRIMARY KEY (ID)
);

Load the table content using the copy command in Vertica:

copy "table name" from 'full csv file path'
    delimiter ',' null as '' exceptions 'full error file path';

Done!

HP Vertica has their community edition for download at https://my.vertica.com/download-community-edition/. If you don't have one already, you will be prompted to create a MyVertica login. If you have problems creating a login, please email me at dsandahl@vertica.com. If you have further issues loading your data, you can tweet at @VerticaHelp and support will follow up with you.