Re: Understanding cassandra data directory contents

2016-10-10 Thread Vladimir Yudovin
From: Vladimir Yudovin vla...@winguzone.com To: user@cassandra.apache.org; Jason Kania jason.ka...@ymail.com Sent: Saturday, October 8, 2016 2:05 PM Subject: Re: Understanding cassandra data directory contents Each table has unique id (suffix). If you drop and then recreate table

Re: Understanding cassandra data directory contents

2016-10-10 Thread Nicolas Douillet
other commands clean up these unused > directories? > > Thanks, > > Jason Kania > > -- > *From:* Vladimir Yudovin <vla...@winguzone.com> > *To:* user@cassandra.apache.org; Jason Kania <jason.ka...@ymail.com> > *Sent:* Saturday, Oct

Re: Understanding cassandra data directory contents

2016-10-08 Thread Jason Kania
these unused directories? Thanks, Jason Kania From: Vladimir Yudovin <vla...@winguzone.com> To: user@cassandra.apache.org; Jason Kania <jason.ka...@ymail.com> Sent: Saturday, October 8, 2016 2:05 PM Subject: Re: Understanding cassandra data directory contents Each table h

Re: Understanding cassandra data directory contents

2016-10-08 Thread Vladimir Yudovin
Each table has unique id (suffix). If you drop and then recreate table with the same name it gets new id. Try SELECT keyspace_name, table_name, id FROM system_schema.tables ; to determinate actual ID. You can limit request to specific keyspace or table. Best regards, Vladimir Yudovin,

Understanding cassandra data directory contents

2016-10-08 Thread Jason Kania
Hello, I am using Cassandra 3.0.9 and I have encountered an issue where the nodes in my 3 node cluster have vastly different amounts of data even though they should be roughly the same. When I looked through the data directory for my database on two of the nodes, I see a number of directories