https://community.qlik.com/t5/Talend-Studio/Transfer-data-between-Hive-and-SQL-Server/m-p/2246969#M32304 If you use this architecture the data are transferred over the VM1. What else would you expect? <BR />You could also use scoop to transfer the data directly from the hive table to the database - without the talend job or you can build the Talend job and transfer it to the VM2. <BR />I suggest the scoop approach. Thu, 30 Apr 2015 16:47:41 GMT Anonymous 2015-04-30T16:47:41Z https://community.qlik.com/t5/Talend-Studio/Transfer-data-between-Hive-and-SQL-Server/m-p/2246968#M32303 Hi, <BR />If I have this architecture : <BR />- VM1 : VM for Talend server (jobs execution) <BR />- VM2 : VM for hadoop cluster (with Hive database) <BR />- VM3 : VM for SQL Server database. <BR />If i want to make a Talend job that transfer data from Hive to SQL Server. The job is executed by the VM1. <BR />Imagine my job is simply : <BR />tHiveInput -------&gt; tMSSqlOutput <BR />The transfered data are directly transfered between VM2 (Hive) and VM3 (SQL Server) ? <BR />or <BR />The transfered data are transfered between VM2 (Hive) and VM1 (Talend). Then, transfered between VM1 (Talend) and VM3 (SQLServer) ? <BR />Thanks in advance. <BR />Tangi Sat, 16 Nov 2024 11:14:13 GMT https://community.qlik.com/t5/Talend-Studio/Transfer-data-between-Hive-and-SQL-Server/m-p/2246968#M32303 Anonymous 2024-11-16T11:14:13Z https://community.qlik.com/t5/Talend-Studio/Transfer-data-between-Hive-and-SQL-Server/m-p/2246969#M32304 If you use this architecture the data are transferred over the VM1. What else would you expect? <BR />You could also use scoop to transfer the data directly from the hive table to the database - without the talend job or you can build the Talend job and transfer it to the VM2. <BR />I suggest the scoop approach. Thu, 30 Apr 2015 16:47:41 GMT https://community.qlik.com/t5/Talend-Studio/Transfer-data-between-Hive-and-SQL-Server/m-p/2246969#M32304 Anonymous 2015-04-30T16:47:41Z