ClickHouse data types in Propel
UInt8
, UInt16
, UInt32
, UInt64
, UInt128
, UInt256
.Int8
, Int16
, Int32
, Int64
, Int128
, Int256
.Float32
: Single precision floating-point number.Float64
: Double precision floating-point number.Decimal(P, S)
: Fixed-point number with precision P and scale S.Bool
: Represents true or false values.String
: Variable-length string.FixedString(N)
: Fixed-length string of N bytes.Date
: Stores dates (year, month, day).Date32
: Extended date type with a wider range.DateTime
: Stores date and time.DateTime64(precision)
: High-precision date and time.JSON
: Stores and processes JSON documents.UUID
: Universally Unique Identifier.Enum8
and Enum16
: For a small set of string values.LowCardinality(T)
: Optimized storage for columns with up to 10,000 unique values.Array(T)
: An array of elements of type T.Map(key_type, value_type)
: Key-value pairs.SimpleAggregateFunction(name, type)
: Stores intermediate state of simple aggregation functions.AggregateFunction(name, types...)
: Stores intermediate state of complex aggregation functions.Nested(Name1 Type1, Name2 Type2, ...)
: Table-like structure within a columnTuple(T1, T2, ...)
: A collection of elements, each with its own type.Nullable(T)
: Allows NULL values for type T.IPv4
: Efficiently stores IPv4 addresses.IPv6
: Efficiently stores IPv6 addresses.Point
: Represents a point on a plane.Ring
: Represents a simple polygon.Polygon
: Represents a polygon with holes.MultiPolygon
: Represents a collection of polygons.Expression
: Stores an expression to be evaluated.Set
: Represents a set of elements.Nothing
: Type with no values.Interval
: Represents a time interval.