The error is :

Hy Jim, Thank you for answering so fast. The actul code is the one here : SELECT DISTINCT DocFinanceiro.AutoId AS AutoId, DocFinanceiro.Classe AS ClasseDoc, EspecPrestador.Seq AS Sequencia, pAux.Codigo AS CodigoPrest, PessoaPrest.Nome AS NomePrestador, DocFinanceiro.CompFinanceira AS CompFinanceira,...

Hy everbody , i am having some trouble in transforming a query that has a set of subqueries in the ON clause. The initial code was created in SQL Server and i have changed to work on Vertica. This is the code : SELECT DISTINCT DocFinanceiro.AutoId AS AutoId, DocFinanceiro.Classe AS ClasseDoc, EspecP...

Hy everybody ! How can a make use of "on delete cascade" in Vertica. I am migrating from SQL Server to Vertica and so far so good but now i am stuck !! Any ideas ? Ex: alter table BLA add constraint BLA_FK foreign key(xxx) references tab2(xxxx) on delete cascade ; - i get ROLLBACK 4229: ON DELETE ac...

I don't have any docs on performance tuning. The profiling data would give you insight into exactly where the time is being spent. Once you identify that you can consider your options - projection design, data model changes, or adding additional nodes. yes this is the way to do it !! Thx , great ad...

Chekc the logs , of the specific host !
Place this on the forum , or maybe you will see the error inside the log !! that is the first place you look !

If the result set is large and your application is going to process the results in batches, then it might be interesting for you to know how long the "first fetch" takes versus the entire result set. I am no sure i understand what you mean by this. But regarding QUERY_PLAN_PROFILES ,EXECUTION_ENGIN...