Hi Team,
I am trying to connect to Spark Thrift Server from Tableau and getting the below error. Tableau is installed in a Windows machine I have ran a kinit before try connecting to SparkThrift server.
An error occurred while communicating with Spark SQL.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
[Simba][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: The specified target is unknown or unreachable.
Unable to connect to the Spark SQL server 'thrift-server.company.com'. Check that the server is running and that you have access privileges to the requested database
At the same time I can see the below message in the thrift-server log.
20/05/01 11:14:04 ERROR TThreadPoolServer: Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TSaslTransportException: No data or no sasl data in the stream
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:739)
at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:736)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:360)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1668)
at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory.getTransport(HadoopThriftAuthBridge.java:736)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:269)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.thrift.transport.TSaslTransportException: No data or no sasl data in the stream
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:328)
at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
... 10 more
Any Help Would be much appreciated.
Thanks,
Ratheesh
Created 07-21-2020 10:21 PM
Hi I am facing the same issue have you been able to resolve the issue ? Please contact me at sami.ullah.javaid@huawei.com @Ratheesh
Created 07-21-2020 11:08 PM
In My case it was an issue with kerberos client, I have updated it to a 64 bit version and everything started working.
Created 07-22-2020 03:00 AM
Thank you so very much let me try this solution and will let you know