Data Types

List

Data Type

Sample

Int

123

BigInt

123

Blob

Float

12.234

Double

12.00

Varchar

‘abc’

Date

‘2022-03-07’

Time

‘18:00:00.000’

TimeStamp

‘2022-03-01 18:00:00.000’

Boolean

‘true’

Array

array[‘v1’,’v2’,’v3’]

Map

map[‘k1’,’v1’,’k2’,’v2’]

Specification

Int

Data Type

Size

Min Value

Max Value

Int

4 byte

-2^31

2^31-1

BigInt

Data Type

Size

Min Value

Max Value

BigInt

8 byte

-2^63

2^63-1

Blob

Data Type

Size

Blob

65535 byte

Float

Data Type

Size

Precision

Syntax

Float32

4 byte

23 bits

FLOAT

Double

Data Type

Size

Precision

Syntax

Float64

8 byte

53 bits

DOUBLE

Varchar

Data Type

Syntax

String

Varchar

Date

Data Type

Size

Resolution

Min Value

Max Value

Precision

Date

4 byte

day

1000-01-01

9999-12-31

yyyy-MM-dd

Time

Data Type

Size

Resolution

Min Value

Max Value

Precision

Time

4 byte

Time

00:00:00.000

59:59:59.999

HH:mm:ss.sss

TimeStamp

Data Type

Size

Resolution

Min Value

Max Value

Precision

Timestamp

4 byte

Timestamp

1000-01-01 00:00:00.000

9999-12-31 59:59:59.999

yyyy-MM-dd HH:mm:ss.sss

Boolean

Date Type

Value

Boolean

ture/false

Array

Data Type

Syntax

Array

Array [value1,value2,value3]

Map

Data Type

Syntax

Map

Map [key,value]