I am trying to query time series data with DSE 3.1 search and so far haven't been successful with a good data model. I found in DSE docs which says that “Cassandra time series type rows” are not supported in DSE search. Does that mean wide rows aren’t supported ? I assume the time series rows are typically wide rows with variable number of columns per row like (Row Key : 1 day’s data as columns); which means that one row of this data would be a Solr document and the variable no of columns would be dynamic fields in Solr doc. Now the question is there a way to select only certain fields based on the values in those fields ?
Also, are there good design recommendations for query time series data in DSE Search/Solr ?