From user-return-28865-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Tue Sep 18 11:41:38 2012 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 C26EEDDAB for ; Tue, 18 Sep 2012 11:41:38 +0000 (UTC) Received: (qmail 4232 invoked by uid 500); 18 Sep 2012 11:41:36 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 3949 invoked by uid 500); 18 Sep 2012 11:41:35 -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 3931 invoked by uid 99); 18 Sep 2012 11:41:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 11:41:35 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of andre.cruz@co.sapo.pt designates 212.55.140.19 as permitted sender) Received: from [212.55.140.19] (HELO sl.pt) (212.55.140.19) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 11:41:30 +0000 Received: (qmail 18015 invoked from network); 18 Sep 2012 11:41:06 -0000 X-AntiVirus: PTMail-AV 0.3-0.95.1 X-Scan-Status: AV clean (0.03860 seconds); Received: from unknown (HELO [10.134.132.140]) (andre.cruz@co.sapo.pt@[10.134.132.140]) (envelope-sender ) by mail-sl-pt01 (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 18 Sep 2012 11:41:06 -0000 From: =?iso-8859-1?Q?Andr=E9_Cruz?= Content-Type: multipart/alternative; boundary="Apple-Mail=_73AC6557-5B50-401C-B839-16D7C44A4520" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 6.0 \(1486\)) Subject: Re: Query advice to prevent node overload Date: Tue, 18 Sep 2012 12:41:05 +0100 References: <91FC0B76-F284-416A-96AA-950CFF43302F@co.sapo.pt> To: In-Reply-To: X-Mailer: Apple Mail (2.1486) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_73AC6557-5B50-401C-B839-16D7C44A4520 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 On Sep 18, 2012, at 3:06 AM, aaron morton = wrote: >> select filename from inode where filename > =91/tmp=92 and filename < = =91/tmq=92 and sentinel =3D =91x=92; Wouldn't that return files from directories '/tmp1', '/tmp2', for = example? I thought the goal was to return files and subdirectories = recursively inside '/tmp'. If we store the slash with the parent_path, so '/tmp/', maybe we can = search for: select filename from inode where filename >=3D =91/tmp/=92 and filename = < =91/tmp0=92 and sentinel =3D =91x=92; Would this work? Thanks, Andr=E9 --Apple-Mail=_73AC6557-5B50-401C-B839-16D7C44A4520 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 aaron@thelastpickle.com> = wrote:
select = filename from inode where filename > =91/tmp=92 and filename < = =91/tmq=92 and sentinel =3D = =91x=92;

Wouldn= 't that return files from directories '/tmp1', '/tmp2', for example? I = thought the goal was to return files and subdirectories recursively = inside '/tmp'.

If we store the slash with the = parent_path, so '/tmp/', maybe we can search for:
select filename from inode where filename >=3D= =91/tmp/=92 and filename < =91/tmp0=92 and sentinel =3D = =91x=92;

Would = this work?