INTEGER (BIGINT)
Vertica supports the numeric data type INTEGER, a signed eight-byte (64-bit) data type.
Syntax
[ INTEGER | INT | BIGINT ]
Semantics
The difference between integer and bigint is in the way that
vsql performs input and output. INTEGER is handled as a 32-bit data type and BIGINT is handled as a 64-bit data type.
vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.
Notes
The JDBC type INTEGER is 4-bytes, and is not supported by Vertica; use BIGINT instead.
- The range of values is -2^63+1 to 2^63-1.
- 2^63 = 9,223,372,036,854,775,808 (19 digits).
- The value -2^63 is reserved to represent NULL.
- Vertica does not support the SQL/JDBC types NUMERIC, SMALLINT, or TINYINT.
- Vertica does not check for overflow (positive or negative) except in the aggregate function SUM(). If you encounter overflow when using SUM, use SUM_FLOAT() which converts to floating point.
- NULL appears first (smallest) in ascending order.
- Vertica does not have an explicit four-byte (32-bit integer) type. Vertica's encoding and compression automatically eliminate extra space.