<?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 Connecting Talend to Hive in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Connecting-Talend-to-Hive/m-p/2301792#M73859</link>
    <description>Hello all, 
&lt;BR /&gt;I am currently working on a project in which 
&lt;FONT color="black"&gt;I&lt;/FONT&gt; need to connect Talend open Studio for Big Data (v 6.3.1) to an Azure’s HDInsight (3.5) Hadoop Cluster. So far, we are trying a simple example which consists in&amp;nbsp;creating 
&lt;FONT color="black"&gt;an &lt;/FONT&gt;Hive Table. For that, we are using the following 
&lt;FONT color="black"&gt;diagram:&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;The hive connection was configured as followed:&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;… and please find below the specifications of the tHiveCreateTable_1 node: 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;By running this process: 
&lt;BR /&gt; 
&lt;BR /&gt;The specified container and deployment Blob is created (see image below) - which make me believe that everything is ok with the Windows Storage Configuration 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;However the tHiveCreateTable_1 node has an error (see image below)&amp;nbsp; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;I strongly believe that it´s something related with the Hostname and Port; 
&lt;BR /&gt;I tried to use the host name of the cluster and the hostname of the Hive server that we can find in Ambari (see image below) 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;But none of them worked as expected. 
&lt;BR /&gt; 
&lt;BR /&gt;&amp;nbsp; 
&lt;BR /&gt;Can you please advise on this? 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt;Note: It seems reasonably important to say that the Azure version supported by Talend is 3.4, however, we are using 3.5. 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt;Many thanks for your support.</description>
    <pubDate>Sat, 16 Nov 2024 09:59:38 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T09:59:38Z</dc:date>
    <item>
      <title>Connecting Talend to Hive</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Connecting-Talend-to-Hive/m-p/2301792#M73859</link>
      <description>Hello all, 
&lt;BR /&gt;I am currently working on a project in which 
&lt;FONT color="black"&gt;I&lt;/FONT&gt; need to connect Talend open Studio for Big Data (v 6.3.1) to an Azure’s HDInsight (3.5) Hadoop Cluster. So far, we are trying a simple example which consists in&amp;nbsp;creating 
&lt;FONT color="black"&gt;an &lt;/FONT&gt;Hive Table. For that, we are using the following 
&lt;FONT color="black"&gt;diagram:&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;The hive connection was configured as followed:&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;… and please find below the specifications of the tHiveCreateTable_1 node: 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;By running this process: 
&lt;BR /&gt; 
&lt;BR /&gt;The specified container and deployment Blob is created (see image below) - which make me believe that everything is ok with the Windows Storage Configuration 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;However the tHiveCreateTable_1 node has an error (see image below)&amp;nbsp; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;I strongly believe that it´s something related with the Hostname and Port; 
&lt;BR /&gt;I tried to use the host name of the cluster and the hostname of the Hive server that we can find in Ambari (see image below) 
&lt;BR /&gt; 
&lt;BR /&gt; 
&lt;BR /&gt;But none of them worked as expected. 
&lt;BR /&gt; 
&lt;BR /&gt;&amp;nbsp; 
&lt;BR /&gt;Can you please advise on this? 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt;Note: It seems reasonably important to say that the Azure version supported by Talend is 3.4, however, we are using 3.5. 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="#1f497d"&gt;&amp;nbsp;&lt;/FONT&gt; 
&lt;BR /&gt;Many thanks for your support.</description>
      <pubDate>Sat, 16 Nov 2024 09:59:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Connecting-Talend-to-Hive/m-p/2301792#M73859</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T09:59:38Z</dc:date>
    </item>
    <item>
      <title>Re: Connecting Talend to Hive</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Connecting-Talend-to-Hive/m-p/2301793#M73860</link>
      <description>Hi,&lt;BR /&gt;&lt;FONT size="2"&gt;&lt;FONT face="Calibri, sans-serif"&gt;We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT size="2"&gt;&lt;FONT face="Calibri, sans-serif"&gt;Best regards&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT size="2"&gt;&lt;FONT face="Calibri, sans-serif"&gt;Sabrina&lt;/FONT&gt;&lt;/FONT&gt;</description>
      <pubDate>Thu, 16 Mar 2017 07:40:22 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Connecting-Talend-to-Hive/m-p/2301793#M73860</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-03-16T07:40:22Z</dc:date>
    </item>
  </channel>
</rss>

