question Re: Getting error in hiverserver2.log in Support Questions

Getting error in hiverserver2.log

ashneesharma88 — Tue, 26 Sep 2017 17:38:04 GMT

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....!!!!!!!!

Re: Getting error in hiverserver2.log

nshelke — Tue, 26 Sep 2017 23:02:01 GMT

@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.

Re: Getting error in hiverserver2.log

ashneesharma88 — Wed, 27 Sep 2017 21:45:53 GMT

@nsshelke

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

Re: Getting error in hiverserver2.log

nshelke — Wed, 27 Sep 2017 22:04:34 GMT

@Ashnee Sharma

What is the version of OS you are using?

Re: Getting error in hiverserver2.log

nshelke — Wed, 27 Sep 2017 23:21:37 GMT

@Ashnee Sharma

You can find the links for ODBC drivers at,

https://hortonworks.com/downloads/

Re: Getting error in hiverserver2.log

ashneesharma88 — Tue, 03 Oct 2017 22:05:53 GMT

@nshelke

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

Re: Getting error in hiverserver2.log

nshelke — Tue, 03 Oct 2017 22:12:14 GMT

@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.html