Propel offers a wide range of data types to efficiently store and process various kinds of data. Here’s a comprehensive list of ClickHouse data types:

​
Integer types

Signed and unsigned integers of different sizes:

  • Unsigned: UInt8, UInt16, UInt32, UInt64, UInt128, UInt256.
  • Signed: Int8, Int16, Int32, Int64, Int128, Int256.

​
Floating-point numbers

  • Float32: Single precision floating-point number.
  • Float64: Double precision floating-point number.
  • Decimal(P, S): Fixed-point number with precision P and scale S.

​
Boolean

  • Bool: Represents true or false values.

​
Strings

  • String: Variable-length string.
  • FixedString(N): Fixed-length string of N bytes.

​
Dates and times

  • 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

  • JSON: Stores and processes JSON documents.

​
UUID

  • UUID: Universally Unique Identifier.

​
Low Cardinality Types

  • Enum8 and Enum16: For a small set of string values.
  • LowCardinality(T): Optimized storage for columns with up to 10,000 unique values.

​
Arrays

  • Array(T): An array of elements of type T.

​
Maps

  • Map(key_type, value_type): Key-value pairs.

​
Aggregation function types

  • SimpleAggregateFunction(name, type): Stores intermediate state of simple aggregation functions.
  • AggregateFunction(name, types...): Stores intermediate state of complex aggregation functions.

​
Nested data structures

  • Nested(Name1 Type1, Name2 Type2, ...): Table-like structure within a column

​
Tuples

  • Tuple(T1, T2, ...): A collection of elements, each with its own type.

​
Nullable

  • Nullable(T): Allows NULL values for type T.

​
IP addresses

  • IPv4: Efficiently stores IPv4 addresses.
  • IPv6: Efficiently stores IPv6 addresses.

​
Geo types

  • Point: Represents a point on a plane.
  • Ring: Represents a simple polygon.
  • Polygon: Represents a polygon with holes.
  • MultiPolygon: Represents a collection of polygons.

​
Special data types

  • Expression: Stores an expression to be evaluated.
  • Set: Represents a set of elements.
  • Nothing: Type with no values.
  • Interval: Represents a time interval.

Was this page helpful?

SyntaxTable Engines