SLES 12 - Teradata QueryGrid - Cloudera Distribution for Hadoop

Cloudera Distribution for Hadoop for Teradata® Administrator Guide

prodname
Cloudera Distribution for Hadoop
vrm_release
5.14
5.15
5.16.1
5.16.2
SLES 12
created_date
November 2019
category
Administration
featnum
B035-6093-038K

The currently certified versions for this release are listed in Teradata Hadoop Products Certification and Lifecycle Information. Go to https://access.teradata.com, log in, and search for KCS010311 or contact your Teradata Customer Service Representative.

Teradata QueryGrid: Teradata Database-to-Hadoop

Teradata QueryGrid™: Teradata-Hadoop connector provides a SQL interface for transferring data between Teradata Database and remote Hadoop hosts. It allows you to do the following:
  • Import Hadoop data into a temporary or permanent Teradata table
  • Export data from temporary or permanent Teradata tables into existing Hadoop tables
  • Create or drop tables in Hadoop from Teradata Database
  • Reference tables on the remote hosts in SELECT and INSERT statements
  • Select Hadoop data for use with a business tool
  • Select and join Hadoop data with data from independent data warehouses for analytical use
The Teradata QueryGrid: Teradata-Hadoop connector provides the following benefits:
  • The ability to export data to Hadoop servers
  • A simplified grammar, making the Teradata QueryGrid Teradata-to-Hadoop connector easier to use. After creating a foreign server once, you can use the server name instead of providing detailed connection information for each SQL query.
  • The automatic push down of qualification columns and grammar to run on a remote host
  • The ability to qualify both columns and partitions involved in the query to reduce the amount of data returned
  • The ability to create an authorization object to securely store credentials. Define foreign servers to use an authorization object to authenticate with a security system, such as LDAP or Kerberos, protecting Hadoop clusters.
  • Privileges to control who can read and write to the servers and tables on remote hosts

The syntax used for the connector is a Teradata extension to the ANSI SQL:2011 standard.