Error: Clustered ColumnStore indices can not be queried

[Kyle Kinney]

I have a view with a Clustered ColumStore index, does Spotfire not handle this or is there a work around

 

Error message: The execution of the 'AFECostCompare' information link did not succeed.The data source reported a failure.

ImportException at Spotfire.Dxp.Data:Failed to execute data source query for data source "". (HRESULT: 80131500)

Stack Trace: at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2() at Spotfire.Dxp.Data.InformationModel.InformationLinkElement.LoadColumnValues(IServiceProvider serviceProvider, Guid columnId, IList`1 dependencyParameters, IList`1 additionalParameters) at Spotfire.Dxp.Data.InformationModel.Prompts.PromptModelBase.LoadColumnValues(PromptDeviceBase promptDevice) at Spotfire.Dxp.Data.InformationModel.Prompts.SingleSelectFilterPromptDevice.Refresh() at Spotfire.Dxp.Forms.Data.InformationDesigner.Prompts.PromptWizard.TryRefresh(PromptDeviceBase next)

InformationModelException at Spotfire.Dxp.Data:Failed to execute query: Cursors are not supported on a table which has a clustered columnstore index. (HRESULT: 80131500)

Stack Trace: at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BinaryReader.FillBuffer(Int32 numBytes) at System.IO.BinaryReader.ReadUInt16() at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader) at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType) at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit() at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2() at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

InformationModelServiceException at Spotfire.Dxp.Services:Failed to execute query: Cursors are not supported on a table which has a clustered columnstore index. (HRESULT: 80131509)

Stack Trace: at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod) at Spotfire.Dxp.Services.Data.InformationModel.QueryManagerService.GetDataBlock(String jobId, Int32 timeout) at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()