Data Types
The page contains a list of SQL data types available in GridGain such as string, numeric, and date/time types.
Every SQL type is mapped to a programming language or driver specific type that is supported by GridGain natively.
Boolean Types
BOOLEAN
Possible values: TRUE and FALSE.
Numeric Types
TINYINT
Possible values: [-128, 127].
SMALLINT
Possible values: [-32768, 32767].
INT
Possible values: [-2147483648, 2147483647].
Alias: INTEGER
BIGINT
Possible values: [-9223372036854775808, 9223372036854775807].
DECIMAL
Possible values: Exact number of selectable precision.
Default precision: 32767
Maximum precision: 32767
Default scale: 0
Maximum scale: 16383
FLOAT
Possible values: A single precision (32-bit) IEEE 754 floating-point number.
Alias: REAL
Special values: NaN, -Infinity, +Infinity
DOUBLE
Possible values: A double precision (64-bit) IEEE 754 floating-point number.
Alias: DOUBLE PRECISION
Special values: NaN, -Infinity, +Infinity
String Types
VARCHAR
Possible values: A Unicode string.
Alias: CHARACTER VARYING
Default length: 65536
Maximum length: 65536
VARBINARY
Possible values: binary data (“byte array”).
Aliases: BINARY, BINARY VARYING
Default length: 65536
Maximum length: 65536
CHAR
Fixed length Unicode string padded with spaces.
Default length: 1
Maximum length: 65536
Date and Time Types
TIME
Possible values: The time data type. The format is hh:mm[:ss].
Default precision: 0
Maximum precision: 3
DATE
Possible values: The date data type.
The format is yyyy-MM-dd.
TIMESTAMP
Possible values: The timestamp data type. The format is yyyy-MM-dd hh:mm:ss[.mmm].
Default precision: 6
Maximum precision: 9
Other Types
UUID
Possible values: Universally unique identifier. This is a 128 bit value.
Example UUID: 7d24b70e-25d5-45ed-a5fa-39d8e1d966b9
© 2024 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.