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 0684F7E49 for ; Mon, 12 Sep 2011 14:00:46 +0000 (UTC) Received: (qmail 70390 invoked by uid 500); 12 Sep 2011 13:57:08 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 69937 invoked by uid 500); 12 Sep 2011 13:56:34 -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 69898 invoked by uid 99); 12 Sep 2011 13:56:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Sep 2011 13:56:24 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW X-Spam-Check-By: apache.org Received-SPF: unknown (athena.apache.org: error in processing during lookup of evgeniy.ryabitskiy@wikimart.ru) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Sep 2011 13:56:17 +0000 Received: by wyg24 with SMTP id 24so3693268wyg.31 for ; Mon, 12 Sep 2011 06:55:54 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.229.221 with SMTP id h71mr2421219weq.112.1315835754379; Mon, 12 Sep 2011 06:55:54 -0700 (PDT) Received: by 10.216.174.74 with HTTP; Mon, 12 Sep 2011 06:55:54 -0700 (PDT) Date: Mon, 12 Sep 2011 17:55:54 +0400 Message-ID: Subject: Index search in provided list of rows (list of rowKeys). From: Evgeniy Ryabitskiy To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0016e64692f8b8f92f04acbee2c0 --0016e64692f8b8f92f04acbee2c0 Content-Type: text/plain; charset=ISO-8859-1 Hi, We have an issue to search over Cassandra and we are using Sphinx for indexing. Because of Sphinx architecture we can't use range queries over all fields that we need to. So we have to run Sphinx Query first to get List of rowKeys and perform additional range filtering over column values. First simple solution is to do it on Client side. That will increase network traffic and memory usage on client. Now I'm wondering if it possible to perform such filtering on Cassandra side. I wish to use some IndexExpression for range filtering in list of records (list of rowKeys returned from external Indexing Search Engine). Looking at get_indexed_slices I found out that in IndexClause is no possibility set List of rowKeys (like for multiget_slice), only start_key. So 2 questions: 1) Am I missing something and my idea is possible via some another API? 2) If not possible, can I add JIRA for this feature? Evgeny. --0016e64692f8b8f92f04acbee2c0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

We have an issue to search over Cassandra and we are using Sphin= x for indexing.
Because of Sphinx architecture we can't use range qu= eries over all fields that we need to.
So we have to run Sphinx Query fi= rst to get List of rowKeys and perform additional range filtering over colu= mn values.

First simple solution is to do it on Client side. That will increase ne= twork traffic and memory usage on client.

Now I'm wondering if i= t possible to perform such filtering on Cassandra side.
I wish to use so= me IndexExpression for range filtering in list of records (list of rowKeys = returned from external Indexing Search Engine).

Looking at get_indexed_slices I found out that in IndexClause is no pos= sibility set List of rowKeys (like for multiget_slice), only start_key.
=
So 2 questions:

1) Am I missing something and my idea is possibl= e via some another API?
2) If not possible, can I add JIRA for this feature?

Evgeny.




--0016e64692f8b8f92f04acbee2c0--