Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3252B4977 for ; Wed, 15 Jun 2011 19:01:34 +0000 (UTC) Received: (qmail 33170 invoked by uid 500); 15 Jun 2011 19:01:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 33117 invoked by uid 500); 15 Jun 2011 19:01:28 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 33022 invoked by uid 99); 15 Jun 2011 19:01:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Jun 2011 19:01:28 +0000 X-ASF-Spam-Status: No, hits=2.9 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,RFC_ABUSE_POST,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [121.101.151.239] (HELO nm1.bullet.mail.in.yahoo.com) (121.101.151.239) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 15 Jun 2011 19:01:19 +0000 Received: from [121.101.151.237] by nm1.bullet.mail.in.yahoo.com with NNFMP; 15 Jun 2011 19:00:57 -0000 Received: from [121.101.151.232] by tm2.bullet.mail.in.yahoo.com with NNFMP; 15 Jun 2011 19:00:57 -0000 Received: from [127.0.0.1] by omp1001.mail.in.yahoo.com with NNFMP; 15 Jun 2011 19:00:57 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 712966.72473.bm@omp1001.mail.in.yahoo.com Received: (qmail 17874 invoked by uid 60001); 15 Jun 2011 19:00:57 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s1024; t=1308164457; bh=RkUuKRDrFyh5rbvjUSsvcf86ZSe2tOfpQfEJgp7sErY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=YeVvPZrAEp5ppLMKyush2WfU0y3wKx22ad8Bhvwq/TS+vXy/IhzL66tHdZKAfo/tt0+pvI03ptRNhWA44nRlPuz8DfCY8mx6WFO/eg/r01jt6A/D1jRcjetUvxrXhCWbw6cTDs7D7DOLYvLeUWYrc3+vldaNigh98qY5xh3PgpQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=ROPmMGpGu45QrsszNDmp+UFAPnzXAGF3/g3nwx4WnKTO0zLRKRd84bmlMrtbVCLkdLi+iDtJz67mgrlzbKO05ZGbuFBrgf2q77PrMxK56LrKZz23gJ9Kl/99mnFvesJR1yQ0G9s+OKP9RyN9FmKkdEpPA00l5E1eDOi98PwfdNs=; Message-ID: <192510.15756.qm@web95203.mail.in2.yahoo.com> X-YMail-OSG: i13rJhkVM1nLlkz2wc6ntpysLBII3OzQzMXegGCpcJGUxLm Taxu8uqlUzP0VTVzeAi6z0jPi8OnF8LpLUoFxmdf9xu3Tcpuw_YzR_4o8f_c qx2VXsxgUV0UGPiN0PAFJrn5STaFHFkZP.UMt4lJ_2PpLfhEuhHS.Eku5uck F0UA2v_fXyQjQsGCZp2tp6PAAmNcanIoDrPnqizRbwWW_TkgfAEH3LcdwL7M HzKlP5rDczzNAxJUD_LitEeVX88js_HlIOZ.oiqjpIovbXadx8QDI1fH9BB0 2wLU6_q_EFGpu.QX0ojvqwlOEUQvzxkjFIyiXiXE0mHzIEbIaZmeLwfe2cny RJzQ5ZPkUJ8YEs5eKroA9gHJA.unE Received: from [199.3.180.4] by web95203.mail.in2.yahoo.com via HTTP; Thu, 16 Jun 2011 00:30:56 IST X-Mailer: YahooMailWebService/0.8.111.304355 References: Date: Thu, 16 Jun 2011 00:30:56 +0530 (IST) From: chovatia jaydeep Reply-To: chovatia jaydeep Subject: Re: When does it make sense to use TimeUUID? To: "user@cassandra.apache.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1168894906-1308164456=:15756" X-Virus-Checked: Checked by ClamAV on apache.org --0-1168894906-1308164456=:15756 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Sameer,=0A=0AOne example is, store all the tweets for a given user in a = Column =0AFamily, where row key is user name/user id and column name is of = =0ATimeUUID type that=A0 represents tweet arrival time. User would generall= y =0Alike to see the tweets sorted based on its arrival time. So TimeUUID = =0Awill help here.=0A=0AThank you,=0AJaydeep=0A=0A=0A______________________= __________=0AFrom: Sameer Farooqui =0ATo: user@cas= sandra.apache.org=0ASent: Tuesday, 14 June 2011 5:16 PM=0ASubject: When doe= s it make sense to use TimeUUID?=0A=0A=0AI would like to store some timesta= mped user info in a Column Family with the usernames as the row key and dif= ferent timestamps as column names. Each user might have a thousand timestam= ped data.=0A=0AI understand that the ver 1 UUIDs that Cassandra combines th= e MAC address of the computer generating the UUID with the number of 100-na= nosecond intervals since the beginning of the Gregorian calendar.=0A=0ASo, = if user1 had data stored for an event at Jan 30, 2011/2:15pm and user2 had = an event at the exact same time, the data could potentially be stored in di= fferent column names? So, I would have to know the MAC of the generating co= mputer in order to do a column slice, right?=A0=0A=0AWhen does it make sens= e to use TimeUUID vs just a time string like 20110130141500 and comparator = type UTF8?=0A=0A- Sameer --0-1168894906-1308164456=:15756 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Sameer,

One example is, store all the twee= ts for a given user in a Column =0AFamily, where row key is user name/user = id and column name is of =0ATimeUUID type that  represents tweet arriv= al time. User would generally =0Alike to see the tweets sorted based on its= arrival time. So TimeUUID =0Awill help here.

Thank you,
Jaydeep


From:= Sameer Farooqui <cassandralabs@gmail.com>
To: user@cassandra.apache.org
Sent: Tuesday, 14 June 2011 5:16 PM
<= b>Subject: When does it make = sense to use TimeUUID?

I would like= to store some timestamped user info in a Column Family with the usernames = as the row key and different timestamps as column names. Each user might ha= ve a thousand timestamped data.

I understand that the ve= r 1 UUIDs that Cassandra combines the MAC address of the computer generating the UUID with the number of 100-nanosec= ond intervals since the beginning of the Gregorian calendar.
=0A
<= br>
So, if user1 had data stored for an event at Jan 30, 2011/2:1= 5pm and user2 had an event at the exact same time, the data could potential= ly be stored in different column names? So, I would have to know the MAC of= the generating computer in order to do a column slice, right? 
= =0A

When does it make sense to use TimeUUID vs just a ti= me string like 20110130141500 and comparator type UTF8?

- Sameer
=0A


--0-1168894906-1308164456=:15756--