Re: Inserting list data

Sorry this is so long after the initial. I wrote a dtest to try to make this happen here: https://github.com/bakerag1/cassandra-dtest/blob/master/collection_update_test.py This is my first dtest and my second python script, so I am not overly confident that it is doing a good job of this test, so

Re: Inserting list data

Are you sure you aren't using batches? These will assign the same timestamp to your inserts which can lead to unexpected behaviors. On Fri, Oct 14, 2016 at 9:45 PM Vladimir Yudovin wrote: > Did you try the same quires with Java driver without using prepared > statements? > > > Best regards, Vlad

Re: Inserting list data

Did you try the same quires with Java driver without using prepared statements? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Fri, 14 Oct 2016 15:13:38 -0400Aoi Kadoya wrote ---

Re: Inserting list data

Hi Vladimir, In fact I am having difficulty to reproduce this issue by cqlsh. I was reported this issue by one of our developers and he is using his client application that uses cassandra java driver 3.0.3. (we're using DSE5.0.1) app A: 2016-10-11 13:28:23,014 [TRACE] [core.QueryLogger.NORMAL]

Re: Inserting list data

I saw evidence of this behavior, but when we created a test to try to make it happen it never did, we assumed it was UDT related and lost interest, since it didn't have a big impact. I will try to carve some time to look into this some more and let you know if I find anything. On Wed, Oct 12, 2016

Re: Inserting list data

The data is actually appended. not overwritten. Strange, can you send exactly operators? Here is example I do: CREATE KEYSPACE events WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1}; CREATE TABLE events.data (id int primary key, events list); INSERT INTO events

Re: Inserting list data

yes, that's what I thought. but, when I use these forms, INSERT ... ['A'] INSERT ... ['B'] The data is actually appended. not overwritten. so I guess this is something unexpected? Thanks, Aoi 2016-10-12 20:55 GMT-07:00 Vladimir Yudovin : > If you use form > INSERT ... ['A'] > INSERT ... ['B'] >

Re: Inserting list data

If you use form INSERT ... ['A'] INSERT ... ['B'] latest INSERT will overwrite first, because this insert the whole list. It's better to use UPDATE like: UPDATE ... SET events = events + ['A'] UPDATE ... SET events = events + ['B'] These operations add new elements to the end of existing

Inserting list data

Hi, When inserting different data into a list type column from different clients at the same time, is data supposed to be combined into one list? For example, if these 2 queries were requested from clients at the same timing, how events list should look like after? INSERT INTO cycling.upcoming_