Apache Doris support standard SQL syntax, using MySQL Network Connection Protocol, highly compatible with MySQL syntax protocol. Therefore, in terms of data type support, Apache Doris aligns as closely as possible with MySQL-related data types

The list of data types supported by Doris is as follows:

Numeric data type

Type NameStorage (bytes)Description
BOOLEAN1Boolean data type that stores only two values: 0 represents false, 1 represents true.
TINYINT1Integer value, signed range is from -128 to 127.
SMALLINT2Integer value, signed range is from -32768 to 32767.
INT4Integer value, signed range is from -2147483648 to 2147483647.
BIGINT8Integer value, signed range is from -9223372036854775808 to 9223372036854775807.
LARGEINT16Integer value, range is [-2^127 + 1 to 2^127 - 1].
FLOAT4Single precision floating point number, range is [-3.4 10^38 to 3.4 10^38].
DOUBLE8Double precision floating point number, range is [-1.79 10^308 to 1.79 10^308].
DECIMAL4/8/16An exact fixed-point number defined by precision (total number of digits) and scale (number of digits to the right of the decimal point). Format: DECIMAL(M[,D]), where M is precision and D is scale. The range for M is [1, 38], and for D is [0, precision]. Storage requirements: - 4 bytes for 0 < precision <= 9, - 8 bytes for 9 < precision <= 18, - 16 bytes for 18 < precision <= 38.

Datetime data type

Type nameStoreage (bytes)Description
DATE16DATE holds values for a calendar year, month and day, the supported range is [‘0000-01-01’, ‘9999-12-31’]. Default print format: ‘yyyy-MM-dd’.
DATETIME16A DATE and TIME combination Format: DATETIME ([P]). The optional parameter P represents time precision, with a value range of [0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0. The supported range is [‘0000-01-01 00:00:00 [.000000]’, ‘9999-12-31 23:59:59 [.999999]’]. Default print format: ‘yyy-MM-dd HH: mm: ss. SSSSSS ‘.

String data type

Type nameStoreage (bytes)Description
CHARMA FIXED length string, the parameter M specifies the column length in characters. The range of M is from 1 to 255.
VARCHARVariable LengthA VARIABLE length string , the parameter M specifies the maximum string length in characters. The range of M is from 1 to 65533. The variable-length string is stored in UTF-8 encoding. English characters occupy 1 byte, and Chinese characters occupy 3 bytes.
STRINGVariable LengthA VARIABLE length string, default supports 1048576 bytes (1 MB), and a limit of maximum precision of 2147483643 bytes (2 GB). Size can be configured string_type_length_soft_limit_bytes adjusted through BE. String type can only be used in value column, not in key column and partition bucket column.

Semi-structured data type

Type nameStoreage (bytes)Description
ARRAYVariable LengthArrays composed of elements of type T cannot be used as key columns. Currently supported for use in tables with Duplicate and Unique models.
MAPVariable LengthMaps consisting of elements of type K and V, cannot be used as Key columns. These maps are currently supported in tables using the Duplicate and Unique models.
STRUCTVariable LengthA structure composed of multiple Fields can also be understood as a collection of multiple columns. It cannot be used as a Key. Currently, STRUCT can only be used in tables of Duplicate models. The name and number of Fields in a Struct are fixed and are always Nullable.
JSONVariable LengthBinary JSON type, stored in binary JSON format, access internal JSON fields through JSON function. Supported up to 1048576 bytes (1MB) by default, and can be adjusted to a maximum of 2147483643 bytes (2GB). This limit can be modified through the BE configuration parameter ‘jsonb_type_length_soft_limit_bytes’.
VARIANTVariable LengthThe VARIANT data type is dynamically adaptable, specifically designed for semi-structured data like JSON. It can store any JSON object and automatically splits JSON fields into subcolumns for improved storage efficiency and query performance. The length limits and configuration methods are the same as for the STRING type. However, the VARIANT type can only be used in value columns and cannot be used in key columns or partition / bucket columns.

Aggregation data type

Type nameStoreage (bytes)Description
HLLVariable LengthHLL stands for HyperLogLog, is a fuzzy deduplication. It performs better than Count Distinct when dealing with large datasets. The error rate of HLL is typically around 1%, and sometimes it can reach 2%. HLL cannot be used as a key column, and the aggregation type is HLL_UNION when creating a table. Users do not need to specify the length or default value as it is internally controlled based on the aggregation level of the data. HLL columns can only be queried or used through the companion functions such as hll_union_agg, hll_raw_agg, hll_cardinality, and hll_hash.
BITMAPVariable LengthBITMAP type can be used in Aggregate tables, Unique tables or Duplicate tables. - When used in a Unique table or a Duplicate table, BITMAP must be employed as non-key columns. - When used in an Aggregate table, BITMAP must also serve as non-key columns, and the aggregation type must be set to BITMAP_UNION during table creation. Users do not need to specify the length or default value as it is internally controlled based on the aggregation level of the data. BITMAP columns can only be queried or used through the companion functions such as bitmap_union_count, bitmap_union, bitmap_hash, and bitmap_hash64.
QUANTILE_STATEVariable LengthA type used to calculate approximate quantile values. When loading, it performs pre-aggregation for the same keys with different values. When the number of values does not exceed 2048, it records all data in detail. When the number of values is greater than 2048, it employs the TDigest algorithm to aggregate (cluster) the data and store the centroid points after clustering. QUANTILE_STATE cannot be used as a key column and should be paired with the aggregation type QUANTILE_UNION when creating a table. Users do not need to specify the length or default value as it is internally controlled based on the aggregation level of the data. QUANTILE_STATE columns can only be queried or used through the companion functions such as QUANTILE_PERCENT, QUANTILE_UNION, and TO_QUANTILE_STATE.
AGG_STATEVariable LengthAggregate function can only be used with state/merge/union function combiners. AGG_STATE cannot be used as a key column. When creating a table, the signature of the aggregate function needs to be declared alongside. Users do not need to specify the length or default value. The actual data storage size depends on the function’s implementation.

IP types

Type NameStorage (bytes)Description
IPv44It is used in conjunction with the ipv4* family of functions.
IPv616It is used in conjunction with the ipv6* family of functions.

You can also view all the data types supported by Doris with the SHOW DATA TYPES; statement.