This is the documentation for CDH 5.1.x. Documentation for other versions is available at Cloudera Documentation.

BIGINT Data Type

An 8-byte integer data type used in CREATE TABLE and ALTER TABLE statements.

Range: -9223372036854775808 .. 9223372036854775807. There is no UNSIGNED subtype.

Conversions: Impala automatically converts to a floating-point type (FLOAT or DOUBLE) automatically. Use CAST() to convert to TINYINT, SMALLINT, INT, STRING, or TIMESTAMP. Casting an integer value N to TIMESTAMP produces a value that is N seconds past the start of the epoch date (January 1, 1970).

Examples:

CREATE TABLE t1 (x BIGINT);
SELECT CAST(1000 AS BIGINT);

Page generated September 3, 2015.