Size, Table, and Loading Limitations | Geospatial Data Types | Teradata Vantage - 17.10 - Limitations - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Geospatial data can have a maximum size of approximately 16MB, allowing for representations of approximately one million points.

It is a Vantage limit that you cannot create a table with more than six LOB columns. By default, ST_Geometry columns are LOBs, so they are subject to this limit. However, you can create ST_Geometry columns that are not LOBs by specifying a maxlength of less than or equal to 64,000 bytes with no INLINE LENGTH specification in the column type definition. That restricts the size of the ST_Geometry data to a size that can be stored within a row, rather than in a LOB subtable. For more information on defining ST_Geometry columns, see ST_GeometryType Method.

Additionally, Teradata load utilities that cannot directly load LOB types similarly cannot load ST_Geometry types unless you specify that ST_Geometry types use a non-default transform group. The transform group used for ST_Geometry data can be specified in the CREATE/MODIFY USER and CREATE/MODIFY PROFILE SQL statements. For more information on specifying transform groups, see Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.