Re: Inserting list data

2016-11-30 Thread Andrew Baker
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

2016-10-15 Thread Russell Spitzer
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? >

Re: Inserting list data

2016-10-14 Thread Vladimir Yudovin
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 cadyan@gmail.com wrote

Re: Inserting list data

2016-10-14 Thread Aoi Kadoya
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

2016-10-13 Thread Andrew Baker
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,

Re: Inserting list data

2016-10-12 Thread Vladimir Yudovin
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 listtext); INSERT INTO

Re: Inserting list data

2016-10-12 Thread Aoi Kadoya
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 ...

Re: Inserting list data

2016-10-12 Thread Vladimir Yudovin
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