
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.
Leaving a column out of 'select - Vertica Forum
Aug 28, 2018 · In 2022, is there a way to leave a column out of select? The use case is defining tables and views that may have hundreds or thousands of columns, and the names of which …
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?
Identify Queries failed with syntax errors and it's ... - Vertica Forum
Jun 19, 2019 · Where could I see the queries and it's respective error which failed with syntax error. error_messages and dc_errors doesn't have the queries.
Why MERGE does not consider null values "properly" - Vertica …
Mar 26, 2004 · Hi All, I am trying to make a MERGE which involves columns with NULL values. Here a simple example:
dropping a column from a table - Vertica Forum
Jan 1, 2013 · I am trying to drop a column from existing table. But I am not able to drop a column because super projection is using that column.
[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).
ERROR 3587: Insufficient resources to execute plan on pool
Mar 26, 2004 · While executing MERGE (that include 660 COLUMNS) I am getting the above error.
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
[Vertica][VJDBC](5065) ERROR: Too many ROS containers exist for …
Jun 22, 2020 · In addition, with Vertica you can avoid DELETEs, UPDATEs and MERGE, to reduce delete vectors and improve performance. I learned this from Maurizio to manage data …