> 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
On Sep 18, 2012, at 3:06 AM, aaron morton 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 i
> Could you explain the usage of the "sentinel"?
Queries that use a secondary index must include an equality clause. That's the
sentinel is there for…
> select filename from inode where filename > ‘/tmp’ and filename < ‘/tmq’ and
> sentinel = ‘x’;
Cheers
-
Aaron Morton
Freelanc
On Sep 17, 2012, at 3:04 AM, aaron morton wrote:
>> I have a schema that represents a filesystem and one example of a Super CF
>> is:
> This may help with some ideas
> http://www.datastax.com/dev/blog/cassandra-file-system-design
Could you explain the usage of the "sentinel"? Which nodes have i
On Sep 17, 2012, at 3:04 AM, aaron morton wrote:
>> I have a schema that represents a filesystem and one example of a Super CF
>> is:
> This may help with some ideas
> http://www.datastax.com/dev/blog/cassandra-file-system-design
>
> In general we advise to avoid Super Columns if possible. They
> I have a schema that represents a filesystem and one example of a Super CF is:
This may help with some ideas
http://www.datastax.com/dev/blog/cassandra-file-system-design
In general we advise to avoid Super Columns if possible. They are often slower,
and the sub columns are not indexed. Meaning
Hello.
I have a schema that represents a filesystem and one example of a Super CF is:
CF FilesPerDir: (DIRNAME -> (FILENAME -> (attribute1: value1, attribute2:
value2))
And in cases of directory moves, I have to fetch all files of that directory
and subdirectories. This implies one cassandra q
