cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From André Cruz <andre.c...@co.sapo.pt>
Subject Re: Query advice to prevent node overload
Date Tue, 18 Sep 2012 11:41:05 GMT
On Sep 18, 2012, at 3:06 AM, aaron morton <aaron@thelastpickle.com> wrote:

>> select filename from inode where filename > ‘/tmp’ and filename < ‘/tmq’
and sentinel = ‘x’;

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 >= ‘/tmp/’ and filename < ‘/tmp0’
and sentinel = ‘x’;

Would this work?

Thanks,
André



Mime
View raw message