Multiple clustering column and ordering issue.

2016-04-18 Thread Michel
Hello, We have just started exploring cassandra for our project and learning basics for designing tables to meet our queries. We will have a table with following fields : user_id list_id fname lname email AND so on. We have each user with multiple lists (csv data) so have created table as below

JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
Hi all, I'm trying to test the new JSON functionalities in C* 2.2. I'm using this example: https://issues.apache.org/jira/browse/CASSANDRA-7970 I believe there is a typo in the CREATE TABLE statement that requires frozen: CREATE TABLE users (id int PRIMARY KEY,name text,addresses maptext,

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
want is: INSERT INTO users JSON '{id: 123,name: jbellis,address: {home: {street: 123 Cassandra Dr,city: Austin,zip_code: 78747,phones: [2101234567]}}}'; HTH On Mon, Jun 1, 2015 at 6:03 PM, Michel Blase mblas...@gmail.com wrote: Hi all, I'm trying to test the new JSON functionalities in C

Re: JSON Cassandra 2.2 - insert syntax

2015-06-01 Thread Michel Blase
wrote: Hi Michel, My only other guess is that you actually are running Cassandra 2.1, since thats the exact error I get if I try to execute a JSON statement against a version earlier than 2.2. On Mon, Jun 1, 2015 at 6:13 PM, Michel Blase mblas...@gmail.com wrote: Thanks Zach, tried

Re: TTL and disk space releasing

2021-10-06 Thread Michel Barret
these if you are still having problems please let us know. Thanks Paul On 6 Oct 2021, at 09:42, Michel Barret wrote: Hello, I try to use cassandra (3.11.5) with 8 nodes (in single datacenter). I use one simple table, all data are inserted with 31 days TTL (the data are never updated). I use

Re: TTL and disk space releasing

2021-10-06 Thread Michel Barret
Hi, it's not set before. I set it to ensure all data have a ttl. Thanks for your help. Le 06/10/2021 à 13:47, Bowen Song a écrit : What is the the table's default TTL? (Note: it may be different than the TTL of the data in the table) On 06/10/2021 09:42, Michel Barret wrote: Hello, I try

Re: TTL and disk space releasing

2021-10-07 Thread Michel Barret
emain on disk until that amount of time has passed. So you will need enough disk space for about twice the amount of data you are expecting to have in that table. On 06/10/2021 16:34, Michel Barret wrote: > Hi, it's not set before. I set it to ensure all data have a ttl.

TTL and disk space releasing

2021-10-06 Thread Michel Barret
Hello, I try to use cassandra (3.11.5) with 8 nodes (in single datacenter). I use one simple table, all data are inserted with 31 days TTL (the data are never updated). I use the TWCS strategy with: - 'compaction_window_size': '24' - 'compaction_window_unit': 'HOURS' - 'max_threshold': '32'

TimeWindowCompactionStrategy Operational Concerns

2022-09-15 Thread Michel Barret
Hi, I want to use TWCS on a cassandra table. Documentation explain 2 concerns about it: In case we mix old and new data "in the traditional write path". => How can I create another write path to ensure that my old data aren't in same sstable than new? If I query old data and that