
Vertica Forum
Mar 26, 2004 · Welcome to the Vertica Forum! This is a space for questions, answers and community contributions from Vertica users and experts. Join the community to learn more.
How to Split column into multiple rows - Vertica Forum
Jun 27, 2014 · I want to split data in a column into multiple rows. How can do that in Vertica?
Combine Multiple ROWS into single row - Vertica Forum
Mar 26, 2004 · Hi, I have table look like this Id | Name 1 | India 2 | Australia 3 | Africa
General Discussion — Vertica Forum
Mar 26, 2004 · Categories - Discussion channel for questions, answers, and conversations among Vertica users and employees.
Partitioning and Loading — Vertica Forum
May 23, 2023 · Vertica's TOP-K projections can be used to always select out the most recent record. So, instead of reading from the table, you read from the top-K projection, and that …
Where to Download .jar Files - Vertica Forum
Mar 26, 2004 · There is plenty of mention of said .jar file in the documentation, but no reference that I can find about where to download it. When I search the Vertica site for vertica-jdbc …
[Vertica] [VJDBC] (3587) ERROR: Insufficient resources to execute …
Mar 26, 2004 · I'm a new user on HP Vertica and I'm trying to load some data on it. My server is: 6 cores and 16GB memory (around 11GB free).
How to fix this type of issue - Vertica Forum
Mar 26, 2004 · The usual reason is that the client is unable to connect to the named node. Is there any firewall rule blocking connection to TCP port 5433? Is v_node0001 up? Newer driver …
How to quickly get row count estimates for all tables - Vertica Forum
Jul 8, 2023 · Hi, Vertica periodically run AnalyzeRowCount on all tables. At least, database parameter AnalyzeRowCountInterval, default 84600, suggest what database is doing.
SUM, AVERAGE, COUNT, STDEV across columns? - Vertica Forum
Nov 13, 2022 · is there a concise way in Vertica to select metrics across a set of columns or expressions within a row, analogous to the way that GREATEST and LEAST work?