KNOWLEDGE BASE

Connecting to HDP 2.6.1 through SparkThriftServer


Published: 10 Apr 2018
Last Modified Date: 20 Apr 2018

Issue

When trying to connect Tableau Desktop to Hortonworks Data Platform (HDP) 2.6.1 through SparkThriftServer, the following error may occur:
 
GetProtocol returned NULL ProtocolRef in %1, allowReconnect=%2 
 
Or the schemas on the database server are visible on the data source page, but instead of showing the actual tables in the schema, a table with the same name as the schema is shown. When that table placed on the canvas, the following errors may occur: 
 
[Simba][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'. 
The table "[<schema name>].[<schema name>]" does not exist. 

OR
[Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.spark.sql.AnalysisException: Table or view not found: `<schema name>`.`<schema name>`; line <line number> pos <position number>; 'GlobalLimit 0 +- 'LocalLimit 0 +- 'Project [*] +- 'UnresolvedRelation `<schema name>`.`<schema name>` 
The table "[<schema name>].[<schema name>]" does not exist. ​

Environment

  • Tableau Desktop 10.0.0
  • Windows
  • Spark SQL

Resolution

Ensure that the following steps have been carried out:
  1. Download and install the Spark SQL driver from our Driver Download page.
  2. Check that no other Spark SQL drivers are installed, e.g. the Hortonworks ODBC Driver for SparkSQL. If so, uninstall those other drivers.
  3. Use the native Spark SQL connector instead of the Other Databases (ODBC) connector.
  4. Upgrade to Tableau Desktop 10.0.17.
  5. Check that the SparkThriftServer user has permissions to access the tables, e.g. check whether the user can view the tables in Beeline.
Did this article resolve the issue?