DEFAULT
constraint; for more information, see CREATE TABLE.BIGINT
-9,223,372,036,854,775,807
; maximum value: 9,223,372,036,854,775,807
.BIGINT ENCODING FIXED(8)
-127
; maximum value: 127
BIGINT ENCODING FIXED(16)
SMALLINT
.BIGINT ENCODING FIXED(32)
INTEGER
.BOOLEAN
'true'
, '1'
, 't'
. FALSE: 'false'
, '0'
, 'f'
. Text values are not case-sensitive.DATE ENCODING DAYS(16)
-32,768
- 32,767
Range in years: +/-90
around epoch, April 14, 1880 - September 9, 2059.
Minumum value: -2,831,155,200
; maximum value: 2,831,068,800
.
Supported formats when using COPY FROM
: mm/dd/yyyy
, dd-mmm-yy
, yyyy-mm-dd
, dd/mmm/yyyy
.DATE ENCODING DAYS(32)
+/-5,883,517
around epoch. Maximum date January 1, 5885487 (approximately). Minimum value: -2,147,483,648
; maximum value: 2,147,483,647
. Supported formats when using COPY FROM
: mm/dd/yyyy
, dd-mmm-yy
, yyyy-mm-dd
, dd/mmm/yyyy
.DATE ENCODING FIXED(16)
DATE ENCODING DAYS(16)
. Deprecated.DATE ENCODING FIXED(32)
DATE ENCODING DAYS(16)
. Deprecated.DECIMAL
DECIMAL(precision,scale)
4
: 2 bytes5
to 9
: 4 bytes10
to 18
(maximum): 8 bytesDOUBLE
-1.79 x e^308
; maximum value: 1.79 x e^308
EPOCH
-30610224000
(1/1/1000 00:00:00
) through 185542587100800
(1/1/5885487 23:59:59
).FLOAT
-3.4 x e^38
; maximum value: 3.4 x e^38
.INTEGER
-2,147,483,647
; maximum value: 2,147,483,647
.INTEGER ENCODING FIXED(8)
-127
; maximum value: 127
.INTEGER ENCODING FIXED(16)
SMALLINT
.LINESTRING
LINESTRING(0 0,1 1,1 2)
MULTIPOLYGON
MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0),(1 1,2 1,2 2,1 2,1 1)), ((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1)))
DATE
columns, but you can create only 4-byte DATE
columns (default) and 2-byte DATE
columns (see DATE ENCODING DAYS(16)
).LINESTRING
, MULTIPOLYGON
, POINT
, and POLYGON
geospatial datatypes.p0
, p1
, ls0
, and poly0
are simple (planar) geometries.p4
is point geometry with Web Mercator longitude/latitude coordinates.p2
, p3
, ls1
, ls2
, poly1
, and mpoly0
are geometries using WGS84 SRID=4326 longitude/latitude coordinates.arrayexamples
DDL sample.TEXT
fields, where you can achieve large savings of storage space and improved processing speed, and on TIMESTAMP
fields where the timestamps range between 1901-12-13 20:45:53
and 2038-01-19 03:14:07
. If a TEXT ENCODING
field does not match the defined cardinality, HEAVY.AI substitutes a NULL
value and logs the change.DATE
types, you can use the terms FIXED
and DAYS
interchangeably. Both are synonymous for the DATE
type in HEAVY.AI.INTEGER
options overlap. For example, INTEGER ENCODINGFIXED(8)
and SMALLINT ENCODINGFIXED(8)
are essentially identical.TEXT ENCODING DICT
field, and the column that you are referencing in that table must also exist. The following small DDL shows the basic structure:REFERENCES
instruction. For example, if you have an existing table called us_geography
, you can share the dictionary by following the pattern in the DDL fragment below.