I have to load 100000 files into one table of Vertica database these files are splitted on three nodes node1 , node2 , node3. What is the best way to do it?
I am trying to make a script with the help of echo and for loop. Please help me with this.

I will describe it as follows I have a set of table or a single table in the production environment in Vertica Database. Now I want a backup of one or more tables in the Disaster Recovery site in Vertica Database. So I need a copy of one or more tables on a increamental basis into the Vertica databa...

Hello, I am intending to backup the tables from one instance of database to another at DR site. Is there any way I can do this with respect to one or more tables. The reply posted by you can only help me take backups in a flat file. Thats gr8. but I need it to be directed to a Vertica database at DR...

Hello

I am using Vertica 5.0

Hello Everyone, I am trying to backup one or more tables at a time, but it seems Vertica dosen't support the feature of backing up the Tables individually, instead it does full and increamental back up on the whole database. This is taking a lot of time and also increasing the footprint of database ...

When I try to execute this SQL query I get the following error Error - SQL submitted to ODBC data source <DSN_EDW_Vertica> resulted in error <ERROR: FileColumnReader: Error opening file /verticadb/PRDEDWDBS01/v_prdedwdbs01_node0001_data/891/45035996294428891/45035996294428891_0.fdb for read: Too man...

Excellent and made easy by knicely

One more difference I would like to mention

WOS is Row store
ROS is Columnar Store

WOS is mostly used for Trickle loading
ROS is mostly used for Bulk Loading

sometimes Vertica is also refered as a Hybrid Database as it has a Row store and a Column store.