http://www.datastax.com/support-forums/topic/number-of-unique-users-between-a-time-period Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 07:25:13 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/number-of-unique-users-between-a-time-period#post-8435 Tue, 15 Jan 2013 22:13:55 +0000 CassandraNewbie 8435@http://www.datastax.com/support-forums/ <p>I do am interested in using the DataStax Enterprise (we are actually evaluating that right now) However I would like to know if it is doable by Cassandra Community Edition and how would that structure be. </p> http://www.datastax.com/support-forums/topic/number-of-unique-users-between-a-time-period#post-8434 Tue, 15 Jan 2013 21:37:16 +0000 rockbrain 8434@http://www.datastax.com/support-forums/ <p>Are you interested in using Datastax Enterprise with Solr, it makes this type of query efficient and easy to use. </p> http://www.datastax.com/support-forums/topic/number-of-unique-users-between-a-time-period#post-8432 Tue, 15 Jan 2013 19:35:38 +0000 CassandraNewbie 8432@http://www.datastax.com/support-forums/ <p>We are wondering how to modelize our Column Family (CFs) to store the number of unique visitors in a time period in order to be able to request it fast. </p> <p>We thought of sharding them by day (row = 20120118, column = visitor_id, value = '') and perform a getcount. This would work to get unique visitors per day, per week or per month but it wouldn't work if I want to get unique visitors between 2 specific dates because 2 rows can share the same visitors (same columns). I can have 1500 unique visitors today, 1000 unique visitors yesterday but only 2000 new visitors when aggregating these days. </p> <p>I could get all the columns for this 2 rows and perform an intersect with my client language but performance won't be good with big data, or we might run into OOM issues. </p> <p>What will be the recommended best way to achieve this? We are open to changing our CF and the rest of the schema to make it happen.</p> <p>Thanks. </p>