New Contributor
Posts: 2
Registered: ‎05-04-2015

Read Teradata tables from Impala

[ Edited ]

Hi Team,


As part of our project requirement, we have to execute query on top heterogeneous database (Teradata and Hive).


We were planning to use Apache Drill to execute the queries but ruled out this option as Drill is open source and no Hadoop distribution provides support to Drill.


Is there is any option/way to connect to Teradata and Hive tables from Impala and execute sql queries on top of both the databases (like apache Drill)?


Thanks in Advance for your time and help !!!

Cloudera Employee
Posts: 295
Registered: ‎03-23-2015

Re: Read Teradata tables from Impala

Impala and Hive share the same metadata info, so whatever tables in Hive, you can access in Impala.

In terms of data in Teradata, you will have to import them into HDFS/Hive using Sqoop and then use Impala to query it.

You can't connect Impala to Teradata directly.