English 中文(简体)
Cassandra time series data
原标题:

We are looking at using Cassandra to store a stream of information coming from various sources.

One issue we are facing is the best way to query between two dates.

For example we will need to retrieve an object between datetime dt1 and datetime dt2.

We are currently considering the created unix timestamp as the key pointing to the actual object then using get_key_range to query to retrieve?

Obviously this wouldn t work if two items have the same timestamp.

Is this the best way to do datetime in noSQL stores in general?

最佳回答

Cassandra rows can be very large, so consider modeling it as columns in a row rather than rows in a CF; then you can use the column slice operations, which are faster than row slices. If there are no "natural" keys associated with this then you can use daily or hourly keys like "2010/02/08 13:00".

Otherwise, yes, using range queries (get_key_range is deprecated in 0.5; use get_range_slice) is your best option.

问题回答

暂无回答




相关问题
Cassandra time series data

We are looking at using Cassandra to store a stream of information coming from various sources. One issue we are facing is the best way to query between two dates. For example we will need to ...

dynamic array key additions

Here is my precode... $keys = array( a , b , c , d ); $number = 10; And here is my code... eval( $array[ .implode( ][ ,$keys). ] = $number; ); Using this, I get the following result... ...

Are there any stable and production quality nosql datastores?

Are there are production quality nosql stores that I can use on a production system. I have looked at cassandra, tokyodb, couchdb etc but none of them seem to be ready for deployments on production ...

key - > value store with binary attachments

An extra requirement is that the attachments can be stored as a stream, as there might be potentially very large binaries that has to be saved. Videos etc. I have looked at Voldemort and other key ...

热门标签