Supported Data Types ​

Indexima Data Types ​

Indexima supports the following SQL data types:

Data Type

Value

Integral Postfix

Range

TINYINT

1-byte signed integer

Y (i.e. 100Y)

from -128 to 127

SMALLINT

2-byte signed integer

S (i.e. 20S)

from -32,768 to 32,767

INT

4-byte signed integer

from -2,147,483,648 to 2,147,483,647

BIGINT

8-byte signed integer

L (i.e. 500L)

from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

FLOAT

4-byte single precision floating point number

DOUBLE

8-byte double-precision floating-point number

STRING

C-style escaping string

String literals can be expressed with either single quotes (') or double quotes (").

TIMESTAMP

UNIX timestamp

format yyyy-mm-dd hh:mm:ss

DATE

particular year/month/day, in the form YYYY-­MM-­DD

from 0000-­01-­01 to 9999-­12-­31

BOOLEAN

TRUE/FALSE

TIMESTAMP Data Type ​

Indexima enriches the TIMESTAMP data type by providing better time granularity in its definition.

By default the granularity of a TIMESTAMP column is DAY but TIMESTAMP can take the following values:

  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND
sql
CREATE TABLE TEST (col1 TIMESTAMP, col2 TIMESTAMP(SECOND), col3 TIMESTAMP(DAY), col4 TIMESTAMP(HOUR));

For a given timestamp of 2018-02-19 23:12:23

text
col1 = 2018-02-19 00:00:00
col2 = 2018-02-19 23:12:23
col3 = 2018-02-19 00:00:00
col4 = 2018-02-19 23:00:00