Overview
Doris supports the following numeric data types:
BOOLEANβ
There are two possible values: 0 represents false, and 1 represents true.
For more info, please refer BOOLEANγ
Integerβ
All are signed integers. The differences among the INT types are the number of bytes occupied and the range of values they can represent:
TINYINT: 1 byte, [-128, 127]
SMALLINT: 2 bytes, [-32768, 32767]
INT: 4 bytes, [-2147483648, 2147483647]
BIGINT: 8 bytes, [-9223372036854775808, 9223372036854775807]
LARGEINT: 16 bytes, [-2^127, 2^127 - 1]
Floating-point typesβ
Including imprecise floating-point types FLOAT and DOUBLE, corresponding to the float
and double
in common programming languages
Fixed-point typeβ
The precise fixed-point type DECIMAL, used in financial and other cases that require strict accuracy.