https://community.qlik.com/t5/Talend-Studio/Table-comparison-between-Impala-Vs-SQL-server/m-p/2353406#M119600 i would suggest sqoop to move the sql data to the cluster and then doing the comparison on the cluster. &nbsp;that should allow you to scale the job and radically reduce your process time. Mon, 03 Aug 2015 06:11:59 GMT Anonymous 2015-08-03T06:11:59Z https://community.qlik.com/t5/Talend-Studio/Table-comparison-between-Impala-Vs-SQL-server/m-p/2353405#M119599 Hello, <BR />I need to compare tables in Impala vs table in SQL server. I am currently using tmap component to compare the tables.As we have &nbsp;200million records to compare it is taking around 2 days to complete. <BR />My flow is as below :- <BR />tsqlinput and tjdbcinput connected to tmap and results in excel. <BR />Is there any other approach in talend to compare impala tables vs sql server to complete the comparison faster. <BR />Regards, <BR />Raakesh R Sat, 16 Nov 2024 11:07:02 GMT https://community.qlik.com/t5/Talend-Studio/Table-comparison-between-Impala-Vs-SQL-server/m-p/2353405#M119599 _AnonymousUser 2024-11-16T11:07:02Z https://community.qlik.com/t5/Talend-Studio/Table-comparison-between-Impala-Vs-SQL-server/m-p/2353406#M119600 i would suggest sqoop to move the sql data to the cluster and then doing the comparison on the cluster. &nbsp;that should allow you to scale the job and radically reduce your process time. Mon, 03 Aug 2015 06:11:59 GMT https://community.qlik.com/t5/Talend-Studio/Table-comparison-between-Impala-Vs-SQL-server/m-p/2353406#M119600 Anonymous 2015-08-03T06:11:59Z