Create new table as select * from hugetable
Some users of mine use the SQL below to create SAS tables inside Vertica :
create table sasview.Agregats_GR as
from hugetable a
How can I limit the overuse of the RAM and DISK with this sort of statement ?
For your information, the hugetable contains 500 millions of records.
i was told that with Oracle, you can force the commit after n records.
Do we have a similar option with Vertica or other tips to solve this issue ?
Thanks for your help