Support Questions
Find answers, ask questions, and share your expertise

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

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.

Don't have an account?