supposed you want a per-hour granularity, you could have a key like this <userID>_<YYMMDDHH>
where HH: hour of the day (0-23) DD: day of the month MM: month of the year YY: year this could be one way. On 7/14/11 11:23 PM, Andre Reiter wrote: >> ----- Original Message ----- >> From: Ted Dunning <tdunn...@maprtech.com> >> Sent: Thu Jul 14 2011 23:17:20 GMT+0200 (CET) >> To: >> CC: >> Subject: Re: data structure > >> You can play tricks with the arrangement of the key. >> >> For instance, you can put date at the end of the key. That would let >> you >> pull data for a particular user for a particular date range. The date >> should not be a time stamp, but should be a low-res version of time >> (day-level resolution might be ok) so that you can minimize number of >> rows. >> > > hi Ted > > i do not see any way to put the date into the row key, there are many > requests/impressions for a particular user (row key) > so no chance to put a date into the key > > andre > > > > -- Claudio Martella Free Software & Open Technologies Analyst TIS innovation park Via Siemens 19 | Siemensstr. 19 39100 Bolzano | 39100 Bozen Tel. +39 0471 068 123 Fax +39 0471 068 129 claudio.marte...@tis.bz.it http://www.tis.bz.it Short information regarding use of personal data. According to Section 13 of Italian Legislative Decree no. 196 of 30 June 2003, we inform you that we process your personal data in order to fulfil contractual and fiscal obligations and also to send you information regarding our services and events. Your personal data are processed with and without electronic means and by respecting data subjects' rights, fundamental freedoms and dignity, particularly with regard to confidentiality, personal identity and the right to personal data protection. At any time and without formalities you can write an e-mail to priv...@tis.bz.it in order to object the processing of your personal data for the purpose of sending advertising materials and also to exercise the right to access personal data and other rights referred to in Section 7 of Decree 196/2003. The data controller is TIS Techno Innovation Alto Adige, Siemens Street n. 19, Bolzano. You can find the complete information on the web site www.tis.bz.it.
