incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Query advice to prevent node overload
Date Wed, 19 Sep 2012 22:29:50 GMT
> Wouldn't that return files from directories '/tmp1', '/tmp2', for example?
I believe so. 

> I thought the goal was to return files and subdirectories recursively inside '/tmp'.
I'm not sure what the purpose of the query was. 
The query query will return inodes where the file path starts with "/tmp"
 
> select filename from inode where filename >= ‘/tmp/’ and filename < ‘/tmp0’
and sentinel = ‘x’;
> 
> Would this work?
Sounds ok. 

Cheers


-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 18/09/2012, at 11:41 PM, André Cruz <andre.cruz@co.sapo.pt> wrote:

> 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