Product: TIBCO Spotfire®
Error when connecting TIBCO Spotfire Analyst with Cloudera Hive ODBC Driver version 2.5.17
While connecting TIBCO Spotfire Analyst to Hive system, Spotfire Analyst is not able to display the data and throws an exception.
Symptoms: 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.<GetSchema>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. For Spotfire 7.5 and previous versions, use Cloudera Hive ODBC Driver version 2.5.16.For Spotfire 7.6 and later, Cloudera Hive ODBC driver version 2.5.17 will work.