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

Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
vci1556127188517.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1181
lifecycle
previous
Product Category
Teradata Vantageā„¢

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_GeometryType.

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.