mosheg
Administrator
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
-
Re: Why Vertica not showing all data in the table after bulk load from SSIS?
* 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)1 -
Re: What will be the next free and up-to-date operating system supported by Vertica?
With no commitment, Vertica will add Rocky and Alma as supported operating systems soon. (View Post)1 -
Re: How to install vertica 11.0 on ubuntu 20.04
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)1 -
Re: Optimizing Vertica Schemas for a Low Latency Application
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)2 -
Re: Optimizing Vertica Schemas for a Low Latency Application
1) Flattened tables will run faster joins and will save the need to code joins, but not unions. 2) If the tables you need to run the union on, have partitions and have the same schema structure, you … (View Post)2
