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 C4EAC9513 for ; Tue, 6 Dec 2011 20:54:38 +0000 (UTC) Received: (qmail 34301 invoked by uid 500); 6 Dec 2011 20:54:36 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 34268 invoked by uid 500); 6 Dec 2011 20:54:36 -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 34260 invoked by uid 99); 6 Dec 2011 20:54:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2011 20:54:36 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of woolfel@gmail.com designates 209.85.220.172 as permitted sender) Received: from [209.85.220.172] (HELO mail-vx0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2011 20:54:28 +0000 Received: by vcbfy13 with SMTP id fy13so5980736vcb.31 for ; Tue, 06 Dec 2011 12:54:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=N9lVDcZ8Rf42tTB9RSnCIGuz9lkQrYX7LPFO7W3ksC0=; b=YOhJk7f6P6AgO+9pSCnWbUx/McHUVl3HmNRDHINfpee+xuMwGgfoEc0TukXNp5eRcN j/1bxi2wzxV0Sj/USlJQS8eRmzRN4/YKqldmQtEgQcHV9OLBo5yE0BcAQN5YifVYxxVb 65Tes9QDp5Sly0dG1LpCHkDp91+5TljAkGUc8= MIME-Version: 1.0 Received: by 10.52.91.162 with SMTP id cf2mr9764314vdb.124.1323204847925; Tue, 06 Dec 2011 12:54:07 -0800 (PST) Received: by 10.220.185.129 with HTTP; Tue, 6 Dec 2011 12:54:07 -0800 (PST) Date: Tue, 6 Dec 2011 15:54:07 -0500 Message-ID: Subject: Is this a limitation of CQL? From: Peter Lin To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org I was doing some testing with CQL and noticed something. I'm guessing it's probably user error on my part, but just in case it isn't. If I execute a query like this, I get the following error "Caused by: InvalidRequestException(why:No indexed columns present in by-columns clause with "equals" operator)" select * from user_columnfamily where effectiveTime >= 1323203100182 The relevant parts of the exception thrown: me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:No indexed columns present in by-columns clause with "equals" operator) at me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:50) at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:127) at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:94) at me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.java:101) at me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:232) at me.prettyprint.cassandra.model.ExecutingKeyspace.doExecuteOperation(ExecutingKeyspace.java:97) at me.prettyprint.cassandra.model.CqlQuery.execute(CqlQuery.java:93) If I change the query and add another filter with equal operator, it works fine. select * from user_columnfamily where effectiveTime >= 1323203100182 and firstName = 'bob' I'm assuming this is "as designed" in 0.8.x release. thanks peter