Until StringTokenizerDelim will support long varchar, the following works for me. drop table tv cascade;create table tv (id int, f1 long varchar(65000));\set MYLINE1 `printf '%s;' {1000000.… (View Post)

* First, SELECT max(your_unique_row_id_key) FROM the data which was successfully loaded to Vertica Then, choose few rows with a higher unique row id value from your data input and try to load only th… (View Post)

With no commitment, Vertica will add Rocky and Alma as supported operating systems soon. (View Post)

Please follow the detailed instructions and OS settings requirements as shown here: https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/InstallationGuide/Other/InstallingManually.htm Here is a… (View Post)

Yes. Another temp table performance advantage is that it requires less locks. The approach in (6) is not mentioned in the documentation, I've learned it from Maurizio. (View Post)