Supported Data Types

This document contains the datatypes supported by e6data

• ARRAY

• BOOLEAN

• DATE

• DECIMAL

• DOUBLE

• FLOAT

• INT32

• INT64

• JSON (as a string)

• STRING

• STRUCT

ARRAY

An array of the given component type.

Examples:

• ARRAY[1, 2, 3]

• select array[1,2,3,4]

BOOLEAN

Represents boolean values TRUE and FALSE

DATE

Represents values having values of fields year, month, and day.

DECIMAL

Represents the numbers with precision and a scale factor of x.

DOUBLE

Represents x-byte single/variable-precision floating point numbers.

FLOAT

Represents x-byte single/variable-precision floating point numbers.

INT32

Represents a 32-bit signed two’s complement integer with a minimum value of $-2^{31}$ and a maximum value of $2^{31}-1$.

INT64

Represents a 64-bit signed two’s complement integer with a minimum value of $-2^{63}$ and a maximum value of $2^{63} - 1$.

JSON

JSON querying is supported when the JSON data is saved in the form of a string.

STRING

Represents character string values.

STRUCT

Represents values with the structure described by a sequence of fields.

Example:

• struct({value:prod,dpid:51})

• select tablename.columnname.structfield1.structfield2 from tablename