<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Unable to process(copy) the data on hive with S3 External Table in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-process-copy-the-data-on-hive-with-S3-External-Table/m-p/2228578#M19808</link>
    <description>&lt;P&gt;Hi there.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Now we are working on EMR(Spark) - Talend BigData Platform PoC.&lt;/P&gt; 
&lt;P&gt;We would like to copy the data from one S3 external hive table to another S3 external hive table with BigData Platform.&lt;/P&gt; 
&lt;P&gt;(Both of the external table are on EMR)&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;After creating the external table on hive, we tried to copy the data through the Talend Studio.&lt;/P&gt; 
&lt;P&gt;Actually, the data would be processed with Spark, but failed.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;19/01/30 05:35:49 WARN ipc.Client: Failed to connect to server: ip-10-118-120-67.ap-northeast-1.compute.internal/10.118.120.67:8020: try once and fail.&lt;BR /&gt;java.net.NoRouteToHostException: No route to host&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Please see the attached log.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;It seems that the Talend could not connect to the nodes.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;We have only 2 nodes(master and slave) .&lt;/P&gt; 
&lt;P&gt;The IPs are&amp;nbsp;10.118.120.90 and&amp;nbsp;10.118.120.114, not&amp;nbsp;10.118.120.67.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Sorry, I moved this topic to the design and development topic.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;The host with&amp;nbsp;ip-10-118-120-67.ap-northeast-1.compute.internal is the previous node's ip.&lt;/P&gt; 
&lt;P&gt;We always stop the EMR cluster in the midnight and start the cluster in the morning because of its cost.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;We are not sure why Talend(job) is trying to connect to&amp;nbsp;10.118.120.67..&lt;/P&gt; 
&lt;P&gt;We surely changed the configuration like cluster, hdfs, db connection, remote server(we installed the job server on EMR master node..).&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Can anyone give us advise for this issue??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks.&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 06:43:37 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T06:43:37Z</dc:date>
    <item>
      <title>Unable to process(copy) the data on hive with S3 External Table</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-process-copy-the-data-on-hive-with-S3-External-Table/m-p/2228578#M19808</link>
      <description>&lt;P&gt;Hi there.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Now we are working on EMR(Spark) - Talend BigData Platform PoC.&lt;/P&gt; 
&lt;P&gt;We would like to copy the data from one S3 external hive table to another S3 external hive table with BigData Platform.&lt;/P&gt; 
&lt;P&gt;(Both of the external table are on EMR)&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;After creating the external table on hive, we tried to copy the data through the Talend Studio.&lt;/P&gt; 
&lt;P&gt;Actually, the data would be processed with Spark, but failed.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;19/01/30 05:35:49 WARN ipc.Client: Failed to connect to server: ip-10-118-120-67.ap-northeast-1.compute.internal/10.118.120.67:8020: try once and fail.&lt;BR /&gt;java.net.NoRouteToHostException: No route to host&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Please see the attached log.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;It seems that the Talend could not connect to the nodes.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;We have only 2 nodes(master and slave) .&lt;/P&gt; 
&lt;P&gt;The IPs are&amp;nbsp;10.118.120.90 and&amp;nbsp;10.118.120.114, not&amp;nbsp;10.118.120.67.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Sorry, I moved this topic to the design and development topic.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;The host with&amp;nbsp;ip-10-118-120-67.ap-northeast-1.compute.internal is the previous node's ip.&lt;/P&gt; 
&lt;P&gt;We always stop the EMR cluster in the midnight and start the cluster in the morning because of its cost.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;We are not sure why Talend(job) is trying to connect to&amp;nbsp;10.118.120.67..&lt;/P&gt; 
&lt;P&gt;We surely changed the configuration like cluster, hdfs, db connection, remote server(we installed the job server on EMR master node..).&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Can anyone give us advise for this issue??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks.&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 06:43:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unable-to-process-copy-the-data-on-hive-with-S3-External-Table/m-p/2228578#M19808</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T06:43:37Z</dc:date>
    </item>
  </channel>
</rss>

