Hi all!
In a DMS with local Cassandra, a user used to run some queries from System Center like following:
After the migration to Cassandra Cluster (twice), there is one cluster with old data, not connected to Dataminer anymore and they are looking to recover some information using DevCenter.
When having local Cassandra and executing from DevCenter, keyspace was SLDMADB and the query was over data table:
Now, if we would like to query the old Cassandra cluster, which would be the keyspace similar to SLDMADB in schema like following?
Hi Michiel,
Additional question on index management within a query, as shown in the following example:
select t,cv,cvl,cvh from zm2_cc_trend_data_medium.trend_data_medium where d=26418 and e=1291 and p=13228 and i='29' and t>='2024-04-30 23:00:00' and t<='2024-05-31 23:00:00' LIMIT 1000 ALLOW FILTERING;
I obtained the following result:
Error,
CassandraConnection ExecuteQuery - exception while executing query: select t,cv,cvl,cvh from zm2_cc_trend_data_medium.trend_data_medium where d=26418 and e=1291 and p=13228 and i='29' and t>='2024-04-30 23:00:00' and t<='2024-05-31 23:00:00' LIMIT 1000 ALLOW FILTERING; - Object reference not set to an instance of an object.,
This index can be found within the element's table.
However, validating it with the query executor only shows a limited number of indexs within the table (less than what I'm looking for).
*Note: After 12 retrieves a error
Is it possible that I'm searching incorrectly or that this behavior is expected?
Pending, regards.
Hi Michiel, in effect, this was the reason for adding images.
The intensity of the exercise is to test the ability to read each index in the element, as starting at 12 results in an error message: Object reference not set to an instance of an object.,
I need to get all of the available readings for indexs 29 and 30, which can be obtained via app and graphed to show the trend, but this is not the way I want to do it before deciding whether to migrate to a cluster or not.
Regards
I noticed that you have a limit of 12 on your query. This means only 12 results will be returned. You can increase this, but keep in mind that you might cause a big impact if you set it too high and a lot of rows have to be returned. Note that you can automate the retrieval of trend data through an automation script that requests it to DM instead of through the DB which might be much safer.
Note: Probably you posted this follow-up as an answer to your question to add pictures, but note that I don’t get notifications on new comments on this answer.