Data type mapping table
When you create a dataset, DataLens converts the source data to its own type for streamlined data processing.
This helps DataLens unify the operations with data from different sources.
The table below shows how data types of different databases and DataLens internal data types map.
| DataLens | ClickHouse® | PostgreSQL |
|---|---|---|
| Boolean | boolean | boolean |
| Date | date | date |
| Date and time | datetime | timestamp |
| Fractional number | float float32 float64 decimal* |
real double precision numeric |
| Integer | integer int8 int16 int32 int64 uint8 uint16 uint32 uint64 |
smallint integer bigint |
| String | string enum8 enum16 |
char varchar text citext |
| Geopoint | Set by a formula in DataLens | Set by a formula in DataLens |
| Geopolygon | Set by a formula in DataLens | Set by a formula in DataLens |
| Array of integers | Array(integer) Array(int8) Array(int16) Array(int32) Array(int64) Array(uint8) Array(uint16) Array(uint32) Array(uint64) |
Array(smallint) Array(integer) Array(bigint) |
| Float array | Array(float32) Array(float64) |
Array(real) Array(double) Array(precision) Array(numeric) |
| Array of strings | Array(string) | Array(char) Array(varchar) Array(text) |
* There may be a loss of accuracy when converting data.
ClickHouse® is a registered trademark of ClickHouse, Inc.
Previous
Next