Hadoop Cloudera Connection Profiles | Teradata Studio/Studio Express - Hadoop Cloudera Connection Profiles - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

When creating Hadoop Cloudera connection profiles, you can select different connection options based on your current system connection setup and your data transfer needs. Select Kerberos Security Authentication if your Hadoop Cloudera system is configured within a Kerberos realm.

Connection Option Description
TDCH Transfers data between the Cloudera System and Vantage. Teradata Connector for Hadoop (TDCH) enables you to move data between Vantage and Hadoop systems.

Manual metadata update for an Impala instance is required. Please refer to the REFRESH/INVALIDATE METADATA statements in the Cloudera Impala documentation.

TDCH is not available for Teradata Studio Express.

SQL-H Transfers data from the Cloudera System to an Aster Database.

Manual metadata update for an Impala instance is required. Please refer to the REFRESH/INVALIDATE METADATA statements in the Cloudera Impala documentation.

SQL-H is not available for Teradata Studio Express.

Smart Loader

Imports data from text delimited files into a Hadoop System.

Hive Accesses the Hadoop Cloudera System using SQL from the SQL Editor. This option uses the Hive JDBC driver to access your Hadoop System.
Impala Accesses the Hadoop Cloudera System using SQL from the SQL Editor. This option uses the Hive Impala JDBC Driver to access your Hadoop System.