We wanted to query our back end using spark from Spotfire 7.5. However we faced a number of issues. Please help us understand what we are doing wrong here.

[Neelakshi Kulkarni]

PFB the grid containing details:

 

 

 

 

Connector

 

 

Error/Issues

 

 

 

 

Hive JDBC

 

We believed that we could have set the property, hive.execution.engine=spark, as we could specify it in the connection URL. However since we could not connect, we were unable to determine it.

 

 

The data source type 'Hive2' is not supported.

Cannot connect to data source 'Hive on Spark Sample Connection', due to invalid configuration or that the data source is not running.

 

Database reported:

Error initializing data source with name 'test-connection': Cannot instantiate JDBC driver with class name com.cloudera.hive.jdbc4.HS2Driver

 

 

 

 

 

Apache Spark ODBC

 

 

Using Hive

Could not connect due to an unknown error.

External error:

ERROR [HY000] [simba][Hardy] (81) Attempting to connect to an incorrect server type: ORG.A.PACHE.HADOOP.UTIL.RUNJAR /OPT/CLOUDERA/PARCELS/CDH-5.10.0-1.CDH5.10.0.P0.41/LIB/HIVE/LIB/HIVE-SERVICE-1.1.0-CDH5.10.0.JAR ORG.APACHE.HIVE.SERVICE.SERVER.HIVESERVER2 --HIVECONF HIVE.AUX.JARS.PATH. Please check your configuration.

 

Using Yarn

Could not connect due to an unknown error.

External error:

ERROR [HY000] [simba][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server

[Sean Riley]

Hive JDBC

Your data source template references a driver of type com.cloudera.hive.jdbc4.HS2Driver but Spotfire cannot find the .jar drivers in tomcatlib. Ensure you have the jar files there and that the data source template validates Ok in the TSS Configuration Tool UI.

 

Apache Spark ODBC

The issue is: "invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server which means your connection is not SSL but your server requires SSL. Do you have 'Username and password (SSL)' set as the authentication

 

Ref:https://docs.tibco.com/pub/sfire-analyst/7.9.0/doc/html/en-US/TIB_sfire-...

[sagar dutta]

Can anyone explain how to pass the command of setting the hive engine to spark when we are establishing the connection to hive.

 

unable to parse set hive.execution.engine=sparkwhen trying to write it in the custom sql console.