You're right, but only 1 node is currently available unfortunately. Looking at the logs : 2014-02-27 09:04:43.066 Init Session:0x7fdff801b1d0 [Refresh] <INFO> Starting refresh task 2014-02-27 09:04:43.069 Refresh:0x7fdfecb403a0 [Refresh] <INFO> Refreshing Projection proj1 (method=scratch) 2014-02-27...

I can't really drop the table, I just drop the projection and create it again and start a refresh. The table has production data that has grown too large already. This is the table information from EXPORT_OBJECTS : CREATE TABLE schema1.table1 ( id IDENTITY , col1 int NOT NULL, col2 int NOT NULL, col...

Sure I tried to drop it and redo everything, but I get same result...reached up to failure_count = 4. I'm on community edition unfortunately.

Any ideas what could be causing refresh failures ??

I can't get a new projection refreshed successfully. I'm creating a multi-column project on a table like this : CREATE PROJECTION proj1(A_id ENCODING RLE, f_number ENCODING RLE, val, Data_id) As SELECT A_id,f_number,val,Data_id from table1 ORDER BY f_number; the table already has 2 projections besid...

Hi, I need to create a derived column like in SQL Server http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx A computed column is not physically stored on disk, but rather computed each time it is queried. What I really want from this functionality is that I can change the expression by...

+1 on that question. An ORM for Vertica would be very useful.

SQLAlchemy supports PostgreSQL,so...does a PostgreSQL connection to Vertica work ?
(I couldn't find guarantees that Vertica and PostgreSQL have similar interfaces)