Supported Data Types

This document contains the datatypes supported by e6data

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

INT64

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

Last updated