Hyper has a rich set of native data types available to users.
The table below shows all the built-in general-purpose data types. Most of the alternative names listed in the "Aliases" column are the names supported by Hyper for compatibility reasons with Postgres.
|signed eight-byte integer|
|Boolean value with ternary logic (true/false/unknown)|
|binary data ("byte array")|
|fixed-length character string|
|variable-length character string with limit|
|calendar date (year, month, day)|
|double precision floating-point number (8 bytes)|
|signed four-byte integer|
|time span; not supported in Tableau|
|exact numeric of selectable precision|
|signed two-byte integer|
|variable-length character string|
|time of day (no time zone)|
|date and time (no time zone)|
|date and time, including time zone|
|a geography object|
Links to detailed documentation:
📄️ Boolean Type
Hyper provides the standard SQL type boolean. The boolean type can
📄️ String Types
Hyper supports three genera-purpose string types:
📄️ Numeric Types
Numeric types consist of two-, four-, and eight-byte integers, as well
📄️ Date/Time Types
Hyper supports the set of SQL date and time types shown in the table below.
📄️ Binary Data Type
The bytes data type allows storage of binary strings.