DDL/schema comparison tool

You could possibly use the Vertica export_catalog function to export the design from the source and target systems:

select export_catalog('/tmp/myschema.sql','DESIGN');

then use Linux DIFF or a programmer tool to find the diffs.

[dbadmin@intrhel73-116-9 tmp]$ diff mydesign mydesignall
0a1,2

CREATE SCHEMA v_idol;
CREATE SCHEMA v_txtindex;

1604a1607,1624

END;

>

CREATE FUNCTION v_txtindex.caseInsensitiveNoStemming(x Long Varchar)
RETURN long varchar AS
BEGIN
RETURN lower(x);
END;

>

CREATE FUNCTION v_txtindex.StemmerCaseInsensitive(v Long Varchar)
RETURN long varchar AS
BEGIN
RETURN v_txtindex.StemmerCaseSensitive(lower(v));
END;

>

CREATE FUNCTION v_txtindex.Stemmer(v Long Varchar)
RETURN long varchar AS
BEGIN
RETURN v_txtindex.StemmerCaseSensitive(lower(v));