Hot answers tagged vertica
3
You have two options really:
You can create a delimited file with your data, like the following:
row1col1data,row1col2data,row1col3data,row1col4data
row2col1data,row2col2data,row2col3data,row2col4data
row3col1data,row3col2data,row3col3data,row3col4data
You can then load that into Vertica using the COPY command and vsql. If you have database superuser ...
2
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 ...
1
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible
