Return-Path: 
 <user-return-3352-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: (qmail 44266 invoked from network); 18 Mar 2010 23:13:26 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 18 Mar 2010 23:13:26 -0000
Received: (qmail 9591 invoked by uid 500); 18 Mar 2010 23:13:25 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 9530 invoked by uid 500); 18 Mar 2010 23:13:25 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 9522 invoked by uid 99); 18 Mar 2010 23:13:25 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Mar 2010 23:13:25 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of john@socketlabs.com designates
 67.192.241.151 as permitted sender)
Received: from [67.192.241.151] (HELO smtp151.dfw.emailsrvr.com)
 (67.192.241.151)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Mar 2010 23:13:15 +0000
Received: from relay15.relay.dfw.mlsrvr.com (localhost [127.0.0.1])
	by relay15.relay.dfw.mlsrvr.com (SMTP Server) with ESMTP id 0BAF130B070C
	for <user@cassandra.apache.org>; Thu, 18 Mar 2010 19:12:54 -0400 (EDT)
Received: from smtp192.mex07a.mlsrvr.com (smtp192.mex07a.mlsrvr.com
 [67.192.133.192])
	by relay15.relay.dfw.mlsrvr.com (SMTP Server) with ESMTPS id 06B0B30B0327
	for <user@cassandra.apache.org>; Thu, 18 Mar 2010 19:12:54 -0400 (EDT)
Received: from 34093-MBX-C03.mex07a.mlsrvr.com ([192.168.1.67]) by
 207038-HUB10.mex07a.mlsrvr.com ([192.168.1.203]) with mapi; Thu, 18 Mar 2010
 18:12:53 -0500
From: John Alessi <john@socketlabs.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Thu, 18 Mar 2010 18:12:52 -0500
Subject: Issue with TimeUUID
Thread-Topic: Issue with TimeUUID
Thread-Index: AcrG8IlHEdQuEQa9STuXEtO36GiODA==
Message-ID: <24276CBD-086F-445A-9DD5-E8B131CE7FE3@socketlabs.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Checked: Checked by ClamAV on apache.org

I am having an issue where Cassandra doesn't seem to be able to distinguish=
 between 2 different UUIDs if based on the same exact time, and sorting by =
TimeUUID.

*****************************
Some of my config:
*****************************
<Keyspaces>
		<Keyspace Name=3D"OD">
	      <KeysCachedFraction>0.01</KeysCachedFraction>
	      <ColumnFamily CompareWith=3D"TimeUUIDType" Name=3D"Events"/>
		</Keyspace>
</Keyspaces>
...
<Partitioner>org.apache.cassandra.dht.OrderPreservingPartitioner</Partition=
er>


*****************************
Ruby sample:
*****************************
require 'rubygems'
require 'cassandra'

logs =3D [{:DateTime=3D>'1257195334', :Text=3D>"something happened"},
      	{:DateTime=3D>'1257195334', :Text=3D>"something happened again at th=
e same time"},
      	{:DateTime=3D>'1257195334', :Text=3D>"something happened one second =
later"}]

client =3D Cassandra.new("OD")
logs.each do |log_line|=20
  event_id =3D UUID.new(Time.at(log_line['DateTime'].to_i))
  puts event_id.to_guid
  if client.get(:Events, "processed", event_id) !=3D nil
     puts "duplicate: " + event_id.to_guid + " " + log_line['DateTime'].to_=
s
  end
  client.insert(:Events, "processed", event_id=3D>"#{log_line['Text']}")
end


*****************************
Outputs:
*****************************
1257195334
1077e700-c7f2-11de-86d5-f5bcc793a028
1257195334
1077e700-c7f2-11de-982e-6fad363d5f29
duplicate: 1077e700-c7f2-11de-982e-6fad363d5f29 1257195334
1257195335
11107d80-c7f2-11de-9b6f-4c8aee849eef


Cassandra doesn't seem to be able to distinguish between 2 different UUIDs =
if based on the same exact time, and sorting by TimeUUID.

What am I missing???

--
John Alessi
SocketLabs, Inc.
484-418-1282