Vertica

Vertica driver is built-into Querona and is ready to use.

IDENTITY columns

Querona honors a T-SQL IDENTITY ( seed , increment ) column declaration on Vertica with full fidelity — any seed and increment are accepted — by emulating it with a named sequence:

• Querona creates a sequence named qua_identity_<table>_<column> in the table’s schema, configured with the declared seed and increment, and assigns it as the column’s default value.

• DROP TABLE also drops the backing sequence.

• If a sequence with that name already exists, the CREATE TABLE fails with an error.

• Explicit identity inserts are not supported on Vertica: SET IDENTITY_INSERT is not available for Vertica-backed identity tables.

CREATE TABLE dbo.Product (
    Id    int          IDENTITY(1000, 10) PRIMARY KEY,
    Code  nvarchar(20) NOT NULL
);

See also

• CREATE TABLE

• Create a connection

• Vertica documentation

Bitwise operators

Querona pushes the bitwise operators down to Vertica over integer columns and writes the exclusive OR as #, because ^ is exponentiation in Vertica.

Note

Vertica reserves the smallest bigint value, -9223372036854775808, for NULL. A bitwise operation whose result is exactly that value returns NULL on Vertica, where SQL Server returns -9223372036854775808: for example CAST(-9223372036854775807 AS bigint) & -2.