Search found 9 matches

by vigneshn
Sat Mar 07, 2015 3:08 pm
Forum: Vertica Data Load
Topic: Data in WOS
Replies: 6
Views: 22403

Data in WOS

In WOS, do we have records of the table for all table's projections. If I have Super projection for a table and user defined projections [ie with only few columns] then inserting a record into table will have records for super projection and user defined projection in main memory or the data will be...
by vigneshn
Sat Mar 07, 2015 3:02 pm
Forum: Vertica Data Load
Topic: What Happens when using Direct Option in Copy , Insert, Update Command
Replies: 1
Views: 13425

What Happens when using Direct Option in Copy , Insert, Update Command

In Document it says Direct options allows data to be moved directly to WOS [ Secondary storage]. But How does it happen during processing. Sorry if I am wrong, According to the computer knowledge I have gained, the data cannot directly move to harddisk without passing main memory. If that is the cas...

Go to advanced search