Vertica Function Support

TDV supports the following types of functions for Vertica:

All aggregate, date/time, formatting, and string functions are supported in pass-through mode.

In Vertica 6.1, TDV supports:

• EXCEPT operators

• INTERSECT operators

• WITH clause, with or without column aliasing

In Vertica 5.0 or 6.1, TDV supports:

• Queries with a WHERE filter on date, time, and timestamp columns

• Subqueries in EXISTS clauses

• Subqueries in IN clauses

TDV also supports the LIMIT clause in Vertica, but maps it to TDV syntax. For example:

SELECT * FROM tableA LIMIT 3 OFFSET 2

This is implemented with the syntax:

SELECT * FROM tableA OFFSET 2 ROWS FETCH 3 ROWS ONLY