AFAIK this is temporary folder for purging deleted vectors.

I've demonstrated a recovery process for someone and in the vertica.log we've found some unknown statements.

ALTER PROJECTION xxx.TEST_b0 RECOVER v_xxx_node0001 FROM 0 TO 1; DATA and DELETE
ALTER PROJECTION xxx.TEST_b0 SPLIT v_xxx_node0001 FROM 2; DATA and DELETE

Pretty intersing, no?

With a great help from the Russian Oracle community ( http://www.sql.ru/forum/1164986/zapros-gruppiruushhiy-nesortirovannye-pary-uzlov-v-kolco ) this is a solution for a cluster with up to 10 nodes. with G as ( select d.dependency_id as id, min(n.name) as node1, max(n.name) as node2 from v_internal....

Vertica K=1 cluster could be presented as a circle when each node has its own data, has a copy on a succeeding node and holds a copy from a preceding node. I would like to write a query that will display this circle. It is not always 1 -> 2 -> 3. For example in our 9 node cluster after removals, add...

I like your soltion. Much easier to code.
Could you explain why these workarounds solve the error?

Hi, Can somebody explain why this throws an error select x, sum(y) from ( select 1 as x, (select 2 from dual) as y from dual ) a group by x; ERROR 4818: Subqueries in the SELECT or ORDER BY are not supported if the subquery is not part of the GROUP BY and this one not? select x, sum(y) from ( select...