DEFAULTconstraint; for more information, see CREATE TABLE.
DATEcolumns, but you can create only 4-byte
DATEcolumns (default) and 2-byte
DATE ENCODING DAYS(16)).
poly0are simple (planar) geometries.
p4is point geometry with Web Mercator longitude/latitude coordinates.
mpoly0are geometries using WGS84 SRID=4326 longitude/latitude coordinates.
TEXTfields, where you can achieve large savings of storage space and improved processing speed, and on
TIMESTAMPfields where the timestamps range between
2038-01-19 03:14:07. If a
TEXT ENCODINGfield does not match the defined cardinality, OmniSci substitutes a
NULLvalue and logs the change.
DATEtypes, you can use the terms
DAYSinterchangeably. Both are synonymous for the
DATEtype in OmniSci.
INTEGERoptions overlap. For example,
SMALLINT ENCODINGFIXED(8)are essentially identical.
TEXT ENCODING DICTfield, and the column that you are referencing in that table must also exist. The following small DDL shows the basic structure:
REFERENCESinstruction. 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.