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 B0720D1C8 for ; Mon, 8 Oct 2012 20:42:43 +0000 (UTC) Received: (qmail 31567 invoked by uid 500); 8 Oct 2012 20:42:41 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 31540 invoked by uid 500); 8 Oct 2012 20:42:41 -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 31532 invoked by uid 99); 8 Oct 2012 20:42:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Oct 2012 20:42:41 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a43.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Oct 2012 20:42:35 +0000 Received: from homiemail-a43.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTP id 6750A8C05F for ; Mon, 8 Oct 2012 13:42:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h= content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to; s= thelastpickle.com; bh=jcEm1HUQ8dV9GhdKEHZijdHU8SQ=; b=sVmz+OHbW4 8pFntCXzcFjZdTBUHYrkrUlKYevVwk3t/gKfljNmuKWlB4+KJb4CEqS+Hwllxt34 YwUiUkBAveaTmPlrt+jhQcodvpgITHVjU5oJhzvlvJOOKS9xAZ0kW9IWrtPxYpOP iHLzmNqoQikz6cJ8rgFZe6mspD6Up9T8w= Received: from [172.16.1.10] (unknown [203.86.207.101]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTPSA id 0B21E8C058 for ; Mon, 8 Oct 2012 13:42:18 -0700 (PDT) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 6.1 \(1498\)) Subject: Re: Text searches and free form queries From: aaron morton In-Reply-To: Date: Tue, 9 Oct 2012 09:42:12 +1300 Content-Transfer-Encoding: quoted-printable Message-Id: <48DB3BF1-A084-4CC2-861D-57A33A81A8D3@thelastpickle.com> References: <2E50C3F9-64FD-49B0-B6A5-AA5ACBE38DAD@thelastpickle.com> To: user@cassandra.apache.org X-Mailer: Apple Mail (2.1498) > It works pretty fast. Cool.=20 Just keep an eye out for how big the lucene token row gets.=20 Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/10/2012, at 2:57 AM, Oleg Dulin wrote: > So, what I ended up doing is this -- >=20 > As I write my records into the main CF, I tokenize some fields that I = want to search on using Lucene and write an index into a separate CF, = such that my columns are a composite of: >=20 > luceneToken:record key >=20 > I can then search my records by doing a slice for each lucene token in = the search query and then do an intersection of the sets. It works = pretty fast. >=20 > Regards, > Oleg >=20 > On 2012-09-05 01:28:44 +0000, aaron morton said: >=20 > AFAIk if you want to keep it inside cassandra then DSE, roll your own = from scratch or start with https://github.com/tjake/Solandra .=20 >=20 > Outside of Cassandra I've heard of people using Elastic Search or Solr = which I *think* is now faster at updating the index.=20 >=20 > Hope that helps.=20 >=20 > =20 > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com >=20 > On 4/09/2012, at 3:00 AM, Andrey V. Panov = wrote: > Some one did search on Lucene, but for very fresh data they build = search index in memory so data become available for search without = delays. >=20 > On 3 September 2012 22:25, Oleg Dulin wrote: > Dear Distinguished Colleagues: >=20 >=20 > --=20 > Regards, > Oleg Dulin > NYC Java Big Data Engineer > http://www.olegdulin.com/