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 !!!