Error when connecting TIBCO Spotfire Analyst with Cloudera Hive ODBC Driver version 2.5.17 .

Error when connecting TIBCO Spotfire Analyst with Cloudera Hive ODBC Driver version 2.5.17 .

Product: TIBCO Spotfire Connector for Cloudera Hive

Version: All Supported Versions

OS: All Supported Operating Systems

--------------------

While connecting TIBCO Spotfire Analyst to Hive system, Spotfire Analyst is not able to display the data and throws an exception. The following error message is generated:

= = =

An exception was thrown by the data connection. Exception text: System.InvalidCastException: Specified cast is not valid. at Spotfire.Dxp.Data.Access.CancellationHelper.Execute(CancellationToken token, Action action) at Spotfire.Dxp.Data.Access.CancellationHelper.Execute[T](CancellationToken token, Func`1 function) at Spotfire.Dxp.Data.Adapters.ClouderaHive.ClouderaHiveAdapterConnection.GetSchemaCore(CancellationToken cancellationToken, ReadOnlyCollection`1 selectedTables, AdapterDataSchema& adapterSchema) at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.GetSchema(CancellationToken cancellationToken, ReadOnlyCollection`1 tableSelection, AdapterDataSchema& adapterSchema) at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryGetSchema(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, CancellationToken cancellationToken, ReadOnlyCollection`1 tableSelection, AdapterDataSchema& adapterDataSchema) at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass19.b__16(CancellationToken token) at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

= = =

Cause: Cloudera Hive ODBC Driver version 2.5.17 is not compatible with Spotfire Client 7.5 and prior versions.

Resolution: For Spotfire 7.5 and previous versions use Cloudera Hive ODBC Driver version 2.5.16.

Note that for Spotfire 7.6 and later, Cloudera Hive ODBC driver version 2.5.17 will work.