Limitations and Functionality - Parallel Transporter
Teradata® Parallel Transporter Reference - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- IntelliFlex
- Lake
- Enterprise
- VMware
- Product
- Parallel Transporter
- Release Number
- 20.00
- Published
- October 2023
- ft:locale
- en-US
- ft:lastEdition
- 2023-12-06
- dita:mapPath
- mjn1691132485167.ditamap
- dita:ditavalPath
- obe1474387269547.ditaval
- dita:id
- ogv1478610452101
- lifecycle
- latest
- Product Category
- Teradata Tools and Utilities
- NOSPOOL mode applies only to simple SELECT statements. The following are not supported:
- Access to nondata tables, such as SELECT DATE or SELECT USER
- USING modifier; instead, define restraint parameters by using a FastExport IMPORT command with supporting FIELD and FILLER commands
- Contains a SORT (ORDER BY), HAVING, or WITH clauses
- Joins
- Aggregations (Explain shows SUM step)
- TABLE functions
- Ordered-analytic (OLAP) functions
- Multiple SELECT statements or multistatement requests
- Statements with zero or more than one, retrieve or sampling step
- NOSPOOL mode only retrieves data from a single table, but the SELECT statement can be selective about which columns are exported and can constrain the job to a subset of rows.
- Scalar expressions/functions are allowed.
- The Sample and partition eliminating constraints are supported.
- The Activity Count returned for a regular spooled job indicates the number of affected blocks; however, for non-spooled jobs, the number of blocks is unknown, so the response message contains ActivityType (instead of Activity Count) to indicate the NOSPOOL process.