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 1B57D6764 for ; Fri, 15 Jul 2011 17:05:07 +0000 (UTC) Received: (qmail 3590 invoked by uid 500); 15 Jul 2011 17:05:05 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 3564 invoked by uid 500); 15 Jul 2011 17:05:04 -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 3556 invoked by uid 99); 15 Jul 2011 17:05:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Jul 2011 17:05:03 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [67.192.241.141] (HELO smtp141.dfw.emailsrvr.com) (67.192.241.141) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Jul 2011 17:04:56 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp24.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id D6F411800EA for ; Fri, 15 Jul 2011 13:04:35 -0400 (EDT) X-Virus-Scanned: OK Received: by smtp24.relay.dfw1a.emailsrvr.com (Authenticated sender: eevans-AT-racklabs.com) with ESMTPSA id B5B591800B6 for ; Fri, 15 Jul 2011 13:04:35 -0400 (EDT) Subject: Re: Range query ordering with CQL JDBC From: Eric Evans To: user@cassandra.apache.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Date: Fri, 15 Jul 2011 12:04:45 -0500 Message-ID: <1310749485.5719.84.camel@erebus.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.32.3 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote: > I am trying to range-query a column family on which the keys are > epochs (similar to the output of System.currentTimeMillis() in Java). > In CQL (Cassandra 0.8.1 with JDBC driver): > > SELECT * FROM columnFamily WHERE KEY > '1309205000000'; > > I can't get to have a result that make sense, it always returns wrong > timestamps. So I must make an error somewhere in the way I input the > querying value. I tried in clear (like above), in hexadecimal, etc. > > What is the correct way of doing this? Is it possible that my key is > too long? What partitioner are you using? What is the key type? -- Eric Evans eevans@rackspace.com