From user-return-37395-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Mon Nov 4 10:30:11 2013 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 CA42D10636 for ; Mon, 4 Nov 2013 10:30:11 +0000 (UTC) Received: (qmail 46777 invoked by uid 500); 4 Nov 2013 10:30:07 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 46694 invoked by uid 500); 4 Nov 2013 10:30:03 -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 46685 invoked by uid 99); 4 Nov 2013 10:30:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Nov 2013 10:30:01 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [64.18.0.22] (HELO exprod5og111.obsmtp.com) (64.18.0.22) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Nov 2013 10:29:54 +0000 Received: from cinmlip12.e2k.ad.ge.com ([165.156.4.1]) (using TLSv1) by exprod5ob111.postini.com ([64.18.4.12]) with SMTP ID DSNKUnd3DK5Ylc2YV36pgLlj+plcvASUt4bs@postini.com; Mon, 04 Nov 2013 02:29:33 PST Received: from unknown (HELO CINMBHT02.e2k.ad.ge.com) ([3.159.212.195]) by cinmlip12.e2k.ad.ge.com with ESMTP/TLS/AES128-SHA; 04 Nov 2013 05:29:31 -0500 Received: from LONURLNA10.e2k.ad.ge.com (3.159.242.59) by CINMBHT02.e2k.ad.ge.com (3.159.212.195) with Microsoft SMTP Server (TLS) id 14.3.146.0; Mon, 4 Nov 2013 05:29:31 -0500 Received: from LONURLNA18.e2k.ad.ge.com ([169.254.6.170]) by LONURLNA10.e2k.ad.ge.com ([169.254.4.64]) with mapi id 14.03.0146.000; Mon, 4 Nov 2013 10:29:23 +0000 From: "Turi, Ferenc (GE Power & Water, Non-GE)" To: "user@cassandra.apache.org" Subject: filter using timeuuid column type Thread-Topic: filter using timeuuid column type Thread-Index: Ac7ZSHwJZzaVCGwbSlKp3XRcDHBZ/A== Date: Mon, 4 Nov 2013 10:29:23 +0000 Message-ID: Accept-Language: hu-HU, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [3.159.242.224] Content-Type: multipart/alternative; boundary="_000_B4A315188FCBE84F8A6E1CE8757ED1A10662FBECLONURLNA18e2kad_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_B4A315188FCBE84F8A6E1CE8757ED1A10662FBECLONURLNA18e2kad_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Is it possible to filter records by using timeuuid column types in case the= column is not part of the primary key? I tried the followings: [cqlsh 3.1.2 | Cassandra 1.2.10.1 | CQL spec 3.0.0 | Thrift protocol 19.36.= 0] CREATE TABLE timeuuid_test2( row_key text, time timeuuid, time2 timeuuid, message text, PRIMARY KEY (row_key, time) ) Cqlsh: select * from timeuuid_test2 where time2>Bad Request: No indexed columns present in by-columns clause with Equal o= perator I tried to create the required index: create index timeuuid_test2_idx on timeuuid_test2 (time2); >>Bad Request: No indexed columns present in by-columns clause with Equal o= perator The result is the same... If the used column is time then everything is OK. select * from timeuuid_test2 where time

Hi,

 

Is it possible to filter records by using timeuuid c= olumn types in case the column is not part of the primary key?

 

I tried the followings:

 

[cqlsh 3.1.2 | Cassandra 1.2.10.1 | CQL spec 3.0.0 |= Thrift protocol 19.36.0]

 

CREATE TABLE timeuuid_test2(

row_key text,<= /p>

time timeuuid,=

time2 timeuuid,

message text,<= /p>

PRIMARY KEY (row_key, tim= e)

)

 

Cqlsh:    select * from timeuuid_t= est2 where time2<now();

 

>>Bad Request: No indexed columns present in b= y-columns clause with Equal operator

I tried to create the required index:

 

create index timeuuid_test2_idx on timeuuid_test2= (time2);

 

>>Bad Request: No indexed columns present in b= y-columns clause with Equal operator

The result is the same…

 

If the used column is time then everything is OK.

 

select * from timeuuid_test2 where time<now() = ALLOW FILTERING;

 

The question here. Why I can’t use the ‘= time2’ column  when filtering despite the column is indexed?

 

Thanks,

 

Ferenc

--_000_B4A315188FCBE84F8A6E1CE8757ED1A10662FBECLONURLNA18e2kad_--