Support Questions

Find answers, ask questions, and share your expertise

Getting error in hiverserver2.log

avatar

I am using hdp 2.5

Getting follwoing error while connecting from microsoft mstr server to hive

server.TThreadPoolServer (TThreadPoolServer.java:run(297)) - Error occurred during processing of message. java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Invalid status 71

Thanks in advance for the help....!!!!!!!!

1 ACCEPTED SOLUTION

avatar
6 REPLIES 6

avatar
@Ashnee Sharma

What version of Hive ODBC driver you are using?

Are you using the In-built Hortonworks Hive Hadoop driver or DSN driver installed.

Default In-built Hortonworks Hive Hadoop driver in Microsoft will not work. You have to use Other ODBC sources -> Hive DSN driver.

avatar

@nsshelke

Please provide me link from where I can download the odbc driver.

avatar
@Ashnee Sharma

What is the version of OS you are using?

avatar

@Ashnee Sharma

You can find the links for ODBC drivers at,

https://hortonworks.com/downloads/

avatar

@nshelke

I am using redhat 7.3 version. I have to copy this driver on server side on client side?

avatar

@Ashnee Sharma

You have to install this driver on Client side and use is to connect to Hive with all the details.

Also Check this link as well,

https://community.hortonworks.com/questions/15667/windows-hive-connection-issue-through-odbc-using-h...