> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported Data Types

> This document contains the datatypes supported by e6data

* [ARRAY](#array)
* [BOOLEAN](#boolean)
* [DATE](#date)
* [DECIMAL](#decimal)
* [DOUBLE](#double)
* [FLOAT](#float)
* [INT32](#int32)
* [INT64](#int64)
* [JSON](#json) *(as a string)*
* [STRING](#string)
* [STRUCT](#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<sup>31</sup> and a maximum value of 2<sup>31</sup> - 1.

### INT64

Represents a 64-bit signed two’s complement integer with a minimum value of -2<sup>63</sup> and a maximum value of 2<sup>63</sup> - 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`


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.