Data Types

DataCater supports the usage of the following data types. Depending on the data source and data sink, we may need to convert data types of a data store to one of the following types and vice versa. Please have a look at the documentation of a connector, e.g., MySQL source connector, to learn about the mapping of data types.

Boolean

Possible values:
true or false

Date

Format:
yyyy-MM-dd

Double

Possible values:
4.94065645841246544e-324d to 1.79769313486231570e+308d

64-bit IEEE 754 double-precision floating-point values.

Float

Possible values:
1.40129846432481707e-45 to 3.40282346638528860e+38

32-bit IEEE 754 double-precision floating-point values.

Int

Possible values:
-2^31 to 2^31-1, inclusive

32-bit integers.

List

A list (or array) of any of the other data types, i.e., boolean, date, double, float, int, long, string, time, or timestamp.
Lists of lists are not supported.

Long

Possible values:
-2^63 to 2^63-1, inclusive

64-bit integers.

String

A sequence of unicode characters.

Time

Format:
HH:mm:ss

Timestamp

Format:
yyyy-MM-dd HH:mm:ss
Jump to