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)

============================================================