Unable to connect to Hive from Tableau

[#1]

Hi All,

In my environment ( no SSL, no Kerberos ) but AD integrated with HS2 when connection is made to Hive using Tableau ( user ID and password is given in Tableau ) , below error is observed -

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: Invalid status -128
at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271)
at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
... 4 more
2018-11-15 16:03:17,498 INFO [org.apache.hadoop.hive.ql.txn.AcidOpenTxnsCounterService-0]: txn.AcidOpenTxnsCounterService (AcidOpenTxnsCounterService.java:run(65)) - OpenTxnsCounter ran for 0seconds. isAliveCounter=-2147473195
2018-11-15 16:03:22,773 ERROR [HiveServer2-Handler-Pool: Thread-84]: server.TThreadPoolServer (TThreadPoolServer.java:run(297)) - Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Invalid status -128
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:269)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: Invalid status -128
at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271)
at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
... 4 more
~
~

Without AD integration in another cluster, everything works fine with the same tableau server - No password is provided in this case for user.

Can anyone help me on this.

[#2]

@Sriram

Maybe before we start diving deep into the diagnostics did you follow these steps How to Connect To Hive Using ODBC in Tableau

Please let me know and share your ODBC setup remember to mask important info but hot the ports info

[#3]

@Sriram

No updates from you

[#4]

@Geoffrey, sorry missed to read comment.

Without AD, I gave 10000 port and just username

When AD is integrated with HS2 I used 10000 port and username and password.

I did not use SSL in both cases.

Also, beeline connectivity works fine when HS2 is integrated with AD.

[#5]

I will send screenshot in another few hours.

[#6]

@Geoffrey Shelton Okot .. I followed the procedure as it is there in the documentation.

Few things to consider:

a) SSL is not enabled on AD side or Cluster Side.

b) When HS2 is integrated with AD, connection via beeline is working as expected ( checks are made against AD for use login )

but issue is observed from ODBC connection.

Any clue on this?

I lost the test environment and will replicate again.

[#7]

@Sriram

Unfortunately you don't have the test environment, without an identical environment its difficult to speculate, I will happily help you once you have a test environment to reproduce the earlier error,I am sure it's just a configuration issue 🙂

HTH

[#8]

@Geoffrey Shelton Okot

Could you please let me know your opinion on below points:

a) Is SSL required on both cluster side and AD side for connecting to HS2 via Tableau?

I am facing issue as reported in below weblink:

https://community.hortonworks.com/questions/26531/cannot-connect-tableau-to-hiveserver2.html?childTo...

Could you please check and let me know.

[#9]

@Geoffrey Shelton Okot

Here is the screenshot which refers to the issue I am facing:

a) HS2 is integrated with AD ( no SSL no Kerberos )

connection to HS2 via beeline is successful as shown in putty screen

connection to HS2 via ODBC Data Source is failed as shown in the screenshot.

Here is the info from HS2 log:

at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:269)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: Error validating the login
at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:316)
at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
... 4 more
2018-11-26 08:20:34,333 ERROR [HiveServer2-Handler-Pool: Thread-40]: server.TThreadPoolServer (TThreadPoolServer.java:run(297)) - Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Invalid status -128
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:269)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: Invalid status -128
at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)
at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184)
at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271)
at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
... 4 more

[#10]

@Geoffrey Shelton Okot @spolavarapu @Felix Albani

Can anyone help me on this.

Attaching the screenshot of the issue..

Points to consider:

a) HS2 is not integrated on OS level and HS2 level.

b) User used for odbc connection is created in all servers of the cluster using useradd command and password is correct.

c) No SSL is configured either on AD side or Cluster Side.

tableauissue.jpg

[#11]

@Sriram

What do you mean by "HS2 is not integrated on OS level and HS2 level"