Column Types - Kinetica Docs

Number

Data Type	Description
`BOOLEAN`	Effective specific type: boolean
`TINYINT`	Effective specific type: int8
`BYTE`	Alias for `TINYINT`
`SMALLINT`	Effective specific type: int16
`INTEGER`	Effective specific type: int
`INT`	Alias for `INTEGER`
`BIGINT`	Effective specific type: long
`DECIMAL`	Alias for `BIGINT`
`LONG`	Alias for `BIGINT`
`UNSIGNED BIGINT`	Effective specific type: ulong
`UNSIGNED LONG`	Alias for `UNSIGNED BIGINT`
`REAL`	Effective specific type: float
`FLOAT`	Alias for `REAL`
`DOUBLE`	Effective specific type: double
`DECIMAL(P,S)`	Effective specific type: decimal(p,s) Maximum precision `P` is 27 Maximum scale `S` is 18 Precision determines decimal storage size: 1 - 18: 8 19 - 27: 12
`NUMERIC`	Alias for `DECIMAL(P,S)`

String

Data Type	Description
`VARCHAR`	Effective specific type: string; character limit based on configured system property
`VARCHAR(N)`	Effective specific type: the smallest charN type that is at least size `N`, or string if `N` is greater than 256
`CHAR`	Alias for `VARCHAR` / `VARCHAR(N)`
`STRING`	Alias for `VARCHAR` / `VARCHAR(N)`
`TEXT`	Alias for `VARCHAR` / `VARCHAR(N)`
`IPV4`	Shorthand for `VARCHAR(IPV4)`, which applies the IPV4 column property
`UUID`	Effective specific type uuid
`JSON`	Effective specific type json

Date/Time

Data Type	Description
`DATE`	Effective specific type: date
`DATETIME`	Effective specific type: datetime
`TIME`	Effective specific type: time
`TIMESTAMP`	Effective specific type: timestamp
`TYPE_DATE`	Alias for `DATE`
`TYPE_TIME`	Alias for `TIME`
`TYPE_TIMESTAMP`	Alias for `TIMESTAMP`

Binary

Data Type	Description
`BLOB`	Effective specific type: bytes
`BINARY`	Alias for `BLOB`
`BYTES`	Alias for `BLOB`
`VARBINARY`	Alias for `BLOB`

Geospatial

Data Type	Description
`GEOMETRY`	Effective specific type: wkt (string base type)
`ST_GEOMETRY`	Alias for `GEOMETRY`
`WKT`	Alias for `GEOMETRY`
`BLOB(WKT)`	Effective specific type: wkt (bytes base type)
`BINARY(WKT)`	Alias for `BLOB(WKT)`
`BYTES(WKT)`	Alias for `BLOB(WKT)`
`VARBINARY(WKT)`	Alias for `BLOB(WKT)`

Composite

Data Type	Description
`BOOLEAN[N]`	Effective specific type: array(boolean) (string base type)
`INTEGER[N]`	Effective specific type: array(int) (string base type)
`BIGINT[N]`	Effective specific type: array(long) (string base type)
`UNSIGNED BIGINT[N]`	Effective specific type: array(ulong) (string base type)
`VECTOR(N)`	Effective specific type: vector(n) (bytes base type); generally used in vector search
`REAL[N]`	Effective specific type: array(float) (string base type)
`DOUBLE[N]`	Effective specific type: array(double) (string base type)
`VARCHAR[N]`	Effective specific type: array(string) (string base type)

Column Concepts Column Properties

⌘I