Data Mover supports copying tables between Teradata to Teradata databases using the T2T utility, and Teradata to Hadoop using the T2H utility. Data Mover supports both QueryGrid 1.0 and QueryGrid 2.0.
For T2H restrictions, see the following QueryGrid user manuals:.
- For QueryGrid 1.x: Teradata QueryGrid: Teradata Database-to-Hadoop User Guide, B035-1185
- For QueryGrid 2.x: Teradata QueryGrid Installation and User Guide, B035-5991
Restrictions
- The following data types are not supported by T2T:
- BLOB, CLOB, PERIOD, JSON, UDT Based Transfer Protocol (for example, XML), and Geospatial.
- By default, Data Mover allows five concurrent T2T tasks running on one system. This applies to both the source and target systems. This value can be modified using the configuration.xml file; however, allowing too many T2T tasks to run at the same time causes source and system resource issues.
- The QueryGrid Teradata-to-Teradata connection allows a maximum of 2048 table columns to transfer, row size must be less than 64 k.
- Transaction semantics are not supported between systems using T2T.
- The target system name must match the foreign server remotehost properties when using QueryGrid 1.0, if not, a validation error occurs.
- The foreign server local_ips must be designated as the source system ips or source system host name when using QueryGrid 1.0.
Known Issues
- A T2T job cannot be stopped while in the middle of performing a task. Tasks run until they are completed and cleanup does not end these tasks. If more than 20 T2T tasks are running concurrently on the same system, including T2T queries not initiated by Data Mover, system resources are affected.
- Data Mover does not report T2T job progress when using QueryGrid 1.0.