Not able to connect to Hive 2 on the Linux from My windows desktop

One Star

Not able to connect to Hive 2 on the Linux from My windows desktop

i have a functioning Hadoop Cluster on the Linux environment and i have created Hive tables.
i tried to read data from the Hive table using tHIVERow (Talend version 5.4) from by Windows Desktop.
i used the below values for tHIVERow and i got the below error.
Distribution - Hortonworks
Hive Version - Hortonworks Data Platform v2.0.0(bigWheel)
Connection Mode - Standalone
Hive Server - Hive 2
Host - "btenv116.server.net"
port - "10000"
Database - "poc"
username and pwd are ""
setResourceManager - "btenv116.server.net:8050"
SetNameNode URI - "hdfs://btenv115.server.net:8020"
Tablename - ohlc_poc
Query - "SELECT
poc.ohlc_orc.ccy_pair_cd
FROM poc.ohlc_orc"
i get the below error.

Starting job Hive_Create at 10:41 13/11/2013.

connecting to socket on port 3387
connected
: org.apache.hadoop.util.Shell - Failed to locate the winutils binary in the hadoop binary path
java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries.
at org.apache.hadoop.util.Shell.getQualifiedBinPath(Shell.java:278)
at org.apache.hadoop.util.Shell.getWinUtilsPath(Shell.java:300)
at org.apache.hadoop.util.Shell.<clinit>(Shell.java:293)
at org.apache.hadoop.hive.conf.HiveConf$ConfVars.findHadoopBinary(HiveConf.java:917)
at org.apache.hadoop.hive.conf.HiveConf$ConfVars.<clinit>(HiveConf.java:238)
at org.apache.hive.jdbc.HiveConnection.isHttpTransportMode(HiveConnection.java:221)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:138)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:123)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at big_data_coe.hive_create_0_1.Hive_Create.tHiveRow_1Process(Hive_Create.java:423)
at big_data_coe.hive_create_0_1.Hive_Create.runJobInTOS(Hive_Create.java:798)
at big_data_coe.hive_create_0_1.Hive_Create.main(Hive_Create.java:663)
Exception in component tHiveRow_1
java.sql.SQLException: Could not establish connection to jdbc:hive2://btenv116.server.net:10000/ret_poc: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:246)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:132)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at big_data_coe.hive_create_0_1.Hive_Create.tHiveRow_1Process(Hive_Create.java:423)
at big_data_coe.hive_create_0_1.Hive_Create.runJobInTOS(Hive_Create.java:798)
at big_data_coe.hive_create_0_1.Hive_Create.main(Hive_Create.java:663)
Caused by: org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null)
at org.apache.thrift.TApplicationException.read(TApplicationException.java:108)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
disconnected
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:144)
at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:131)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:237)
... 7 more
Job Hive_Create ended at 10:41 13/11/2013.
Moderator

Re: Not able to connect to Hive 2 on the Linux from My windows desktop

Hi,
Did you check the component reference TalendHelpCenter:tHiveRow.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download