Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Teradata to Hadoop using query grid - how to improve the fetching speed?

Highlighted

Teradata to Hadoop using query grid - how to improve the fetching speed?

New Contributor

I am fetching data from Hive tables from Teradata SQL assistant using TD query grid. Its taking around 30 to 40 sec. extra compared to direct querying in HIVE. Is there anyways to improve the fetching speed from Hadoop to TD.

Sample SQL :

SELECT TOP 20 * FROM poc.POS_TABLE@hadoop_POS WHEREYR='2016';

The above sql is taking 1 second in HIVE but around 30-40 sec from Teradata.