Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Access modes for teradata beyond Sqoop ingestion.

avatar
Rising Star

The Hortonworks Connector for Teradata enables ingestion with Sqoop as well as outbound data via Sqoop. Can someone please outline any other modes of interaction with Teradata that may be available. For instance, is it possible to execute Hive queries against Teradata without actually importing the data? Can queries be federated?

1 ACCEPTED SOLUTION

avatar
  1. Teradata Open Distribution for Hadoop (Running on Teradata Appliance for Hadoop) - Release Version: 2.1
  2. TeradataViewpoint - Release Version: 15.00.00.xx
  3. Teradata Studio – Smart Loader for Hadoop - Release Version: 15.00.0x
  4. Teradata Connector for Hadoop (TDCH) - Release Version:1.3.1
  5. Teradata QueryGrid: Teradata-Hadoop - Release Version: 14.10.x (Federated Queries)
  6. Teradata QueryGrid: Aster-Hadoop - Release Version:6.00.02 (Federated Queries)
  7. Teradata UnityEcosystem Manager - Release Version:15.00
  8. Teradata Unity Data Mover -Release Version::15.00
  9. Teradata Parallel Transporter (TPT) -Release Version:15.10

View solution in original post

3 REPLIES 3

avatar
  1. Teradata Open Distribution for Hadoop (Running on Teradata Appliance for Hadoop) - Release Version: 2.1
  2. TeradataViewpoint - Release Version: 15.00.00.xx
  3. Teradata Studio – Smart Loader for Hadoop - Release Version: 15.00.0x
  4. Teradata Connector for Hadoop (TDCH) - Release Version:1.3.1
  5. Teradata QueryGrid: Teradata-Hadoop - Release Version: 14.10.x (Federated Queries)
  6. Teradata QueryGrid: Aster-Hadoop - Release Version:6.00.02 (Federated Queries)
  7. Teradata UnityEcosystem Manager - Release Version:15.00
  8. Teradata Unity Data Mover -Release Version::15.00
  9. Teradata Parallel Transporter (TPT) -Release Version:15.10

avatar
Rising Star

Thanks Ancil. I'm still curious about what can be done from inside Hadoop. The federation of queries is particularly interesting becauese you don't always want to import the data into HDFS.

avatar
Explorer

Notes to add to Ancil's comments

Teradata Query Grid with Hortonworks capability is tied to releases - ie One-Way(14.10), Bi-Directional(15.00) and Push Down(15.00).

Teradata Unified Data Mover - an intelligent Data Mover between Unified Data Architecture(Teradata, Aster and Hadoop).

Teradata Studio for desktop - offers Data Source Explorer, Object Viewer, and transfer