Data type overview

StarRocks supports the following data types: Numeric, String, Date, Semi-structured, and Others. You can define columns of these types when you create a table, load data into these columns, and query the data.

Numeric

• TINYINT
• SMALLINT
• INT
• BIGINT
• LARGEINT
• DECIMAL
• DOUBLE
• FLOAT
• BOOLEAN
• PERCENTILE

String

• CHAR
• STRING
• VARCHAR

Date

• DATE
• DATETIME

Semi-structured

• ARRAY
• JSON

Others

• BITMAP
• HLL