About 8,660 results
Open links in new tab
  1. 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.

  2. 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?

  3. 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

  4. General Discussion — Vertica Forum

    Mar 26, 2004 · Categories - Discussion channel for questions, answers, and conversations among Vertica users and employees.

  5. 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 …

  6. 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 …

  7. [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).

  8. 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 …

  9. 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.

  10. 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?