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.