16.20 - Limitations - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Geospatial Data Types

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
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 Teradata Database 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_Geometry Type.

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.