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.
1 REPLY
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.